4 Replies Latest reply on Aug 31, 2012 7:10 AM by Jiri Svitak

    problems in jbpm5 with db2 integration

    Deepak Singhvi Newbie

      What i am doing:

                  Trying to use DB2 with jbpm5 (5.3)

         Problems:

           a. Some tables are not created ---> (mentioned below).

           b. Exception when running the sample program (sample.bpmn from evaluation project)--->(mentioned below)

       

       

         My war got deployed ( jbpm-gwt-console-server.war including other wars like designer.war, drools-guvnor.war,jbpm-form-builder.war, jbpm-gwt-console.war,jbpm-human-task-war.war) but i do not see

         ProcessInstanceInfo, WorkItemInfo, SessionInfo, etc tables in db.

         Following are the tables which are present in jbpm5 database

       

        ATTACHMENT,BOOLEANEXPRESSION,DEADLINE,DELEGATION_DELEGATES,EMAIL_HEADER,ESCALATION,I18NTEXT,NOTIFICATION,

      NOTIFICATION_BAS,NOTIFICATION_EMAIL_HEADER, NOTIFICATION_RECIPIENTS,ORGANIZATIONALENTITY,PEOPLEASSIGNMENTS_BAS,

      PEOPLEASSIGNMENTS_EXCLOWNERS,PEOPLEASSIGNMENTS_POTOWNERS,PEOPLEASSIGNMENTS_RECIPIENTS,PEOPLEASSIGNMENTS_STAKEHOLDERS,

      REASSIGNMENT,REASSIGNMENT_POTENTIALOWNERS,SUBTASKSSTRATEGY,TASK,TASK_COMMENT

       

        These are the table which are available in

        Q.1 When does processInstaceInfo, etc table gets created?

         Q.2 I get the error when i start sample program.

       

         Error on console ( ProcessTest.java)

      0    30/08 09:30:02,395[main] ERROR workitem.wsht.GenericHTWorkItemHandler.executeWorkItem  - Thu Aug 30 09:30:02 GMT+05:30 2012: Error when creating task on task server for work item id 1. Error reported by task server: Command AddTaskRequest faild due to Operation failed. Please contact task server administrator.

      java.lang.RuntimeException: Command AddTaskRequest faild due to Operation failed. Please contact task server administrator.

                at org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:662)

                at org.jbpm.task.service.hornetq.HornetQTaskServerHandler.messageReceived(HornetQTaskServerHandler.java:44)

                at org.jbpm.task.service.hornetq.BaseHornetQTaskServer.run(BaseHornetQTaskServer.java:85)

                at java.lang.Thread.run(Thread.java:619)

      Process started ...

       

      Error in server.log of jboss7

        09:30:02,379 ERROR [stderr] (Thread-16) java.lang.RuntimeException: Operation failed

        09:30:02,379 ERROR [stderr] (Thread-16)           at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:994)

        09:30:02,379 ERROR [stderr] (Thread-16)           at org.jbpm.task.service.TaskServiceSession.addTask(TaskServiceSession.java:186)

        09:30:02,379 ERROR [stderr] (Thread-16)           at org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:144)

        09:30:02,379 ERROR [stderr] (Thread-16)           at org.jbpm.task.service.hornetq.HornetQTaskServerHandler.messageReceived(HornetQTaskServerHandler.java:44)

        09:30:02,379 ERROR [stderr] (Thread-16)           at org.jbpm.task.service.hornetq.BaseHornetQTaskServer.run(BaseHornetQTaskServer.java:85)

        09:30:02,379 ERROR [stderr] (Thread-16)           at java.lang.Thread.run(Thread.java:619)

        09:30:02,379 ERROR [stderr] (Thread-16) Caused by: javax.persistence.PersistenceException: org.hibernate.HibernateException: The database returned no natively generated identity value

        09:30:02,379 ERROR [stderr] (Thread-16)           at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614)

       

       

       

      Deepak

       

        • 1. Re: problems in jbpm5 with db2 integration
          Deepak Singhvi Newbie

          I have another error now. after a clean, install demo ans starting demo

           

           

          0    30/08 10:11:13,136[main] ERROR workitem.wsht.GenericHTWorkItemHandler.executeWorkItem  - Thu Aug 30 10:11:13 GMT+05:30 2012: Error when creating task on task server for work item id 1. Error reported by task server: Task operation request timed out

          java.lang.RuntimeException: Task operation request timed out

                    at org.jbpm.task.service.SyncTaskServiceWrapper.addTask(SyncTaskServiceWrapper.java:118)

                    at org.jbpm.process.workitem.wsht.GenericHTWorkItemHandler.executeWorkItem(GenericHTWorkItemHandler.java:145)

                    at org.drools.process.instance.impl.DefaultWorkItemManager.internalExecuteWorkItem(DefaultWorkItemManager.java:70)

                    at org.jbpm.workflow.instance.node.WorkItemNodeInstance.internalTrigger(WorkItemNodeInstance.java:105)

                    at org.jbpm.workflow.instance.impl.NodeInstanceImpl.trigger(NodeInstanceImpl.java:124)

                    at org.jbpm.workflow.instance.impl.NodeInstanceImpl.triggerNodeInstance(NodeInstanceImpl.java:205)

                    at org.jbpm.workflow.instance.impl.NodeInstanceImpl.triggerCompleted(NodeInstanceImpl.java:164)

                    at org.jbpm.workflow.instance.node.StartNodeInstance.triggerCompleted(StartNodeInstance.java:49)

                    at org.jbpm.workflow.instance.node.StartNodeInstance.internalTrigger(StartNodeInstance.java:41)

                    at org.jbpm.workflow.instance.impl.NodeInstanceImpl.trigger(NodeInstanceImpl.java:124)

                    at org.jbpm.ruleflow.instance.RuleFlowProcessInstance.internalStart(RuleFlowProcessInstance.java:35)

                    at org.jbpm.process.instance.impl.ProcessInstanceImpl.start(ProcessInstanceImpl.java:188)

                    at org.jbpm.workflow.instance.impl.WorkflowProcessInstanceImpl.start(WorkflowProcessInstanceImpl.java:303)

                    at org.jbpm.process.instance.ProcessRuntimeImpl.startProcessInstance(ProcessRuntimeImpl.java:168)

                    at org.jbpm.process.instance.ProcessRuntimeImpl.startProcess(ProcessRuntimeImpl.java:138)

                    at org.drools.common.AbstractWorkingMemory.startProcess(AbstractWorkingMemory.java:1082)

                    at org.drools.impl.StatefulKnowledgeSessionImpl.startProcess(StatefulKnowledgeSessionImpl.java:320)

                    at com.sample.ProcessTest.main(ProcessTest.java:31)

          Process started ...

          • 2. Re: problems in jbpm5 with db2 integration
            Jiri Svitak Novice

            Hello Deepak,

             

            which version of Hibernate do you use?

            • 3. Re: problems in jbpm5 with db2 integration
              Deepak Singhvi Newbie

              Hi Jiri,

                I am using hibernate3 as suggested in jbpm5 with JbossAS7,

               

              And now i have started getting

               

              javax.naming.NameNotFoundException: persistence not bound

              I have checked in jboss console i can see the datasource but i am not able to see with the context lookup ( even in the simple program)

               

               

              Deepak

               


              • 4. Re: problems in jbpm5 with db2 integration
                Jiri Svitak Novice

                Before testing business processes, make sure that everything was deployed on your AS successfully, as it seems that there are problems related to your persistence configuration. Do a clean, install and start demo again, check the status of your deployment. It seems that you have badly configured JNDI name for your datasource. If you cannot deploy your jbpm without errors, you can send your server.log, standalone.xml and two persistence.xml files (from jbpm-gwt-console-server and jbpm-human-task).