OO Designer IDM failed to query LONG object in the IDM DB

  • KM03249366
  • 18-Sep-2018
  • 21-May-2021

Summary

IDM failing when querying LONG object in the IDM DB.

Question

While setting the DB LDAP authentication for the IDM, it failed after loading the certificate, the logs are showing this error:
2018-09-18 14:05:52,295 [https-jsse-nio-8443-exec-6] WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 17027, SQLState: 99999
2018-09-18 14:05:52,295 [https-jsse-nio-8443-exec-6] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Stream has already been closed
2018-09-18 14:05:52,295 [https-jsse-nio-8443-exec-6] ERROR com.hp.ccue.identity.domain.persistence.PersistenceService - JDBCException executing query 'select e from com.hp.ccue.identity.domain.configuration.BaseAuthenticationConfiguration as e inner join e.organization as o with ((o.id = :orgId or lower(o.name) = lower(:orgId)) and o.deleted is null) where e.deleted is null'. Database may be down or unavailable.
org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.loader.Loader.doList(Loader.java:2557)
at org.hibernate.loader.Loader.doList(Loader.java:2540)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
at org.hibernate.loader.Loader.list(Loader.java:2365)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)
(..)

 

Answer

Issue

OO Designer IDM failed to query LONG object in the IDM DB

 

Solution:
To fix this issue in /opt/microfocus/oo-designer/designer/conf/designer-wrapper.conf, modify the line below and set it to true. If the line is not present, add it by following the correct numbering.


wrapper.java.additional.34=-Doracle.jdbc.useFetchSizeWithLongColumn=true

Finally, restart the Designer's service.