3 Replies Latest reply on Mar 5, 2014 2:16 AM by Maciej Swiderski

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

    Suraj Bahl Newbie

      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]