Bulk execution of task operations fails with ConstraintViolationException exception on the ORGANIZATIONALENTITY table
Issue
We are facing a ConstraintViolationException
exception on the ORGANIZATIONALENTITY
table if a user not present in the table while claiming the tasks in bulk with RHPAM 7:
WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-1) SQL Error: -803, SQLState: 23505
ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-1) DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;PAM.ORGANIZATIONALENTITY
WARN [org.jbpm.services.task.persistence.TaskTransactionInterceptor] (default task-1) Could not commit session: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
Caused by: com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;PAM.ORGANIZATIONALENTITY
at com.ibm.db2.jcc.am.kd.a(kd.java:743)
at com.ibm.db2.jcc.am.kd.a(kd.java:66)
Environment
- Red Hat Process Automation Manager
- 7.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.