1 Reply Latest reply on Nov 13, 2007 5:38 AM by cheets

    JBPM 3.2.2 and DB2 V8.1

    javaspacemarine

      Hi everybody,

      We use db2 db and at moment we evaluate jbpm 3.2.2.

      But there are errors in the lock.
      it seems that db2 does not like index longer then 18 characters.
      jbpm 3.1.3 still work.
      Does someone knows any workaround ?

      10:59:13,561 [main] ERROR SchemaExport : Unsuccessful: create index IDX_PSTATE_SBPRCDEF on ENGPADM.JBPM_NODE (SUBPROCESSDEFINITION_)
      10:59:13,561 [main] ERROR SchemaExport : [IBM][CLI Driver][DB2/NT] SQL0107N Der Name "IDX_PSTATE_SBPRCDEF" ist zu lang. Die maximale Länge beträgt "18". SQLSTATE=42622

      10:59:14,718 [main] ERROR SchemaExport : Unsuccessful: create index IDX_VARINST_TKVARMP on ENGPADM.JBPM_VARIABLEINSTANCE (TOKENVARIABLEMAP_)
      10:59:14,718 [main] ERROR SchemaExport : [IBM][CLI Driver][DB2/NT] SQL0107N Der Name "IDX_VARINST_TKVARMP" ist zu lang. Die maximale Länge beträgt "18". SQLSTATE=42622

      Timo

        • 1. Re: JBPM 3.2.2 and DB2 V8.1
          cheets

          hi Timo,
          I faced the same problem, and i changed the index name to a shorter name, and my installation worked perfectly. I am not sure about this, but i think changing the index name should not cause any problem since we are not (/we dont have a need of) referring to the database index by name anywhere.
          I also had an issue with the size of jbpm_log table, and i had to change the settings of db2 explicitly as mentioned in the jbpm wiki.
          hth..
          :)