Summary
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.