Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-9514

New CorrelationKeyInfo constraint upgrade in DDL script is failing for DB2 databases

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 7.48.0.Final
    • None
    • Persistence
    • None
    • False
    • False
    • NEW
    • NEW
    • Undefined
    • ---
    • ---

      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
      
      

       

      Caused by: https://github.com/kiegroup/jbpm/blob/master/jbpm-db-scripts/src/main/resources/db/ddl-scripts/db2/db2-jbpm-schema.sql#L505

      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

              elguardian@gmail.com Enrique González Martínez (Inactive)
              antferna Antonio Fernandez Alhambra (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: