SQL Syntax Error while running jbpm6.0.1 with IBM DB2 9.7

[suraj.bahl.50]

Can someone please help me? i am getting below error while running jbpm6.0.1 with IBM DB2 9.7

15:08:23,205 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-localhost-127.0.0.1-8080-1) DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-206;42703;TASKIMPL0_.ID, DRIVER=3.59.81

15:08:23,207 ERROR [org.jbpm.services.task.commands.InitDeadlinesCommand] (http-localhost-127.0.0.1-8080-1) Error when executing deadlines: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=TASKIMPL0_.ID, DRIVER=3.59.81

  at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1361) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

  at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1289) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

  at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:261) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

  at org.jbpm.services.task.persistence.JPATaskPersistenceContext.queryInTransaction(JPATaskPersistenceContext.java:388) [jbpm-human-task-core-6.0.1.Final.jar:6.0.1.Final]

  at org.jbpm.services.task.commands.InitDeadlinesCommand.execute(InitDeadlinesCommand.java:37) [jbpm-human-task-core-6.0.1.Final.jar:6.0.1.Final]

  at org.jbpm.services.task.commands.InitDeadlinesCommand.execute(InitDeadlinesCommand.java:18) [jbpm-human-task-core-6.0.1.Final.jar:6.0.1.Final]

  at org.jbpm.services.task.commands.TaskCommandExecutorImpl$SelfExecutionCommandService.execute(TaskCommandExecutorImpl.java:65) [jbpm-human-task-core-6.0.1.Final.jar:6.0.1.Final]

  at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41) [drools-core-6.0.1.Final.jar:6.0.1.Final]

  at org.jbpm.services.task.persistence.TaskTransactionInterceptor.execute(TaskTransactionInterceptor.java:53) [jbpm-human-task-core-6.0.1.Final.jar:6.0.1.Final]

  at org.jbpm.services.task.commands.TaskCommandExecutorImpl.execute(TaskCommandExecutorImpl.java:40) [jbpm-human-task-core-6.0.1.Final.jar:6.0.1.Final]

  at org.jbpm.services.task.impl.TaskDeadlinesServiceImpl.initialize(TaskDeadlinesServiceImpl.java:358) [jbpm-human-task-core-6.0.1.Final.jar:6.0.1.Final]

  at org.jbpm.services.task.HumanTaskConfigurator.getTaskService(HumanTaskConfigurator.java:136) [jbpm-human-task-core-6.0.1.Final.jar:6.0.1.Final]

  at org.jbpm.kie.services.cdi.producer.HumanTaskServiceProducer.produceTaskService(HumanTaskServiceProducer.java:53) [jbpm-kie-services-6.0.1.Final.jar:6.0.1.Final]

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_45]

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_45]

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_45]

[suraj.bahl.50]

another similar issue JBPM code is trying to run below query whereas I18NText  don't have any column called "ID"? I have picked up the DDL script from installer db->db2 folder, is it not correct?

insert into I18NText (id, language, shortText, text) values (default, ?, ?, ?)

[suraj.bahl.50]

Can someone please tell me where can i report such issues? Looks like DDL scripts provided in JBPM installer is in-correct.

[swiderski.maciej]

it was already reported and fixed and will be released with next version. For the time being you can try this one that should solve your problems.

HTH