RHPAM running on SpringBoot cannot find Sequences in DB2 DBMS

Solution Verified - Updated -

Issue

  • at startup time/runtime time of RHPAM, there is an ERROR on the log mentioning that Sequences can not be found, e.g:

The Sequence SESSIONINFO_ID_SEQ can not be found in the DB2 DBMS.

Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=UIBPSC.SESSIONINFO_ID_SEQ, DRIVER=4.28.11
    ... 48 more
    at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:756)
    at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107)
    at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:55)
    at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:128)
    at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:185)
    at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:114)
    at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:534)
    at org.hibernate.id.enhanced.PooledOptimizer.generate(PooledOptimizer.java:73)
    at org.hibernate.id.enhanced.SequenceStructure$1.getNextValue(SequenceStructure.java:107)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37)
    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
    ... 39 more
    at org.drools.persistence.PersistableRunner.<init>(PersistableRunner.java:117)

Environment

  • Red Hat Process Automation Manager (RHPAM)
    • 7.13

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content