Details
-
Bug
-
Resolution: Done
-
Major
-
None
-
None
-
False
-
False
-
NEW
-
NEW
-
Undefined
-
---
-
---
Description
New changed added in jBPM database scripts (JBPM-9503) is failing when running it on DB2 databases.
Below error is thrown:
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-542, SQLSTATE=42831, SQLERRMC=NAME, DRIVER=4.25.1301 at com.ibm.db2.jcc.am.b6.a(b6.java:810) at com.ibm.db2.jcc.am.b6.a(b6.java:66) at com.ibm.db2.jcc.am.b6.a(b6.java:140) at com.ibm.db2.jcc.am.k3.b(k3.java:2471) at com.ibm.db2.jcc.am.k3.c(k3.java:2452) at com.ibm.db2.jcc.t4.ab.n(ab.java:914) at com.ibm.db2.jcc.t4.ab.a(ab.java:120) at com.ibm.db2.jcc.t4.p.a(p.java:50) at com.ibm.db2.jcc.t4.aw.b(aw.java:220) at com.ibm.db2.jcc.am.k4.bm(k4.java:3599) at com.ibm.db2.jcc.am.k4.a(k4.java:4644) at com.ibm.db2.jcc.am.k4.b(k4.java:4182) at com.ibm.db2.jcc.am.k4.bg(k4.java:2880) at com.ibm.db2.jcc.am.k4.execute(k4.java:2855) at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94) at org.jbpm.test.persistence.scripts.TestPersistenceContextBase.executeStatement(TestPersistenceContextBase.java:171) at org.jbpm.test.persistence.scripts.TestPersistenceContextBase.executeScripts(TestPersistenceContextBase.java:147) ... 43 more
This is basically due to the fact that column `name` in `CorrelationKeyInfo` table can allowed NULL values.
https://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/codes/src/tpc/n542.html
Attachments
Issue Links
- is caused by
-
-
- Resolved
-