1 Reply Latest reply on Feb 19, 2014 3:03 PM by Ramses Hernández

    Problem persisting process session

    Ramses Hernández Newbie

      Hello, I have a project with jBPM 5.4 Final, this project is using persistence and HornetQ with JBoss 7.1.1 Postgresql 9.1 for DB.

       

      When I create a new process everything is O.K, i can proceed the task and assigns the new task to the group (the first status task is completed), when the new task is proceeded, the workitem in the database doesn't change and the new task is not created in table task, but the task is completed.

       

      JBoss log throws an error:

       

      16:29:36,219 INFO  [stdout] (Thread-73) Hibernate: select task0_.id as id83_3_, task0_.archived as archived83_3_, task0_.allowedToDelegate as allowedT3_83_3_, task0_.taskInitiator_id as taskIni28_83_3_, task0_.priority as priority83_3_, task0_.activationTime as activati5_83_3_, task0_.actualOwner_id as actualO29_83_3_, task0_.completedOn as complete6_83_3_, task0_.createdBy_id as createdBy30_83_3_, task0_.createdOn as createdOn83_3_, task0_.documentAccessType as document8_83_3_, task0_.documentContentId as document9_83_3_, task0_.documentType as documen10_83_3_, task0_.expirationTime as expirat11_83_3_, task0_.faultAccessType as faultAc12_83_3_, task0_.faultContentId as faultCo13_83_3_, task0_.faultName as faultName83_3_, task0_.faultType as faultType83_3_, task0_.outputAccessType as outputA16_83_3_, task0_.outputContentId as outputC17_83_3_, task0_.outputType as outputType83_3_, task0_.parentId as parentId83_3_, task0_.previousStatus as previou20_83_3_, task0_.processId as processId83_3_, task0_.processInstanceId as process22_83_3_, task0_.processSessionId as process23_83_3_, task0_.skipable as skipable83_3_, task0_.status as status83_3_, task0_.workItemId as workItemId83_3_, task0_.OPTLOCK as OPTLOCK83_3_, user1_.id as id79_0_, user2_.id as id79_1_, user3_.id as id79_2_ from Task task0_ left outer join OrganizationalEntity user1_ on task0_.taskInitiator_id=user1_.id left outer join OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id left outer join OrganizationalEntity user3_ on task0_.createdBy_id=user3_.id where task0_.id=?
      16:29:36,229 INFO  [stdout] (Thread-73) Hibernate: select nextval ('CONTENT_ID_SEQ')
      16:29:36,230 INFO  [stdout] (Thread-73) Hibernate: select subtaskstr0_.Task_Id as Task4_83_1_, subtaskstr0_.id as id1_, subtaskstr0_.id as id81_0_, subtaskstr0_.name as name81_0_, subtaskstr0_.DTYPE as DTYPE81_0_ from SubTasksStrategy subtaskstr0_ where subtaskstr0_.Task_Id=?
      16:29:36,233 INFO  [stdout] (Thread-73) Hibernate: insert into Content (content, id) values (?, ?)
      16:29:36,234 INFO  [stdout] (Thread-73) Hibernate: update Task set archived=?, allowedToDelegate=?, taskInitiator_id=?, priority=?, activationTime=?, actualOwner_id=?, completedOn=?, createdBy_id=?, createdOn=?, documentAccessType=?, documentContentId=?, documentType=?, expirationTime=?, faultAccessType=?, faultContentId=?, faultName=?, faultType=?, outputAccessType=?, outputContentId=?, outputType=?, parentId=?, previousStatus=?, processId=?, processInstanceId=?, processSessionId=?, skipable=?, status=?, workItemId=?, OPTLOCK=? where id=? and OPTLOCK=?
      16:29:36,243 INFO  [stdout] (Thread-73) Hibernate: select startdeadl0_.Deadlines_StartDeadLine_Id as Deadlines4_83_1_, startdeadl0_.id as id1_, startdeadl0_.id as id75_0_, startdeadl0_.deadline_date as deadline2_75_0_, startdeadl0_.escalated as escalated75_0_ from Deadline startdeadl0_ where startdeadl0_.Deadlines_StartDeadLine_Id=?
      16:29:36,246 INFO  [stdout] (Thread-73) Hibernate: select enddeadlin0_.Deadlines_EndDeadLine_Id as Deadlines5_83_1_, enddeadlin0_.id as id1_, enddeadlin0_.id as id75_0_, enddeadlin0_.deadline_date as deadline2_75_0_, enddeadlin0_.escalated as escalated75_0_ from Deadline enddeadlin0_ where enddeadlin0_.Deadlines_EndDeadLine_Id=?
      16:29:36,279 INFO  [stdout] (Thread-73) Hibernate: select task0_.id as id83_3_, task0_.archived as archived83_3_, task0_.allowedToDelegate as allowedT3_83_3_, task0_.taskInitiator_id as taskIni28_83_3_, task0_.priority as priority83_3_, task0_.activationTime as activati5_83_3_, task0_.actualOwner_id as actualO29_83_3_, task0_.completedOn as complete6_83_3_, task0_.createdBy_id as createdBy30_83_3_, task0_.createdOn as createdOn83_3_, task0_.documentAccessType as document8_83_3_, task0_.documentContentId as document9_83_3_, task0_.documentType as documen10_83_3_, task0_.expirationTime as expirat11_83_3_, task0_.faultAccessType as faultAc12_83_3_, task0_.faultContentId as faultCo13_83_3_, task0_.faultName as faultName83_3_, task0_.faultType as faultType83_3_, task0_.outputAccessType as outputA16_83_3_, task0_.outputContentId as outputC17_83_3_, task0_.outputType as outputType83_3_, task0_.parentId as parentId83_3_, task0_.previousStatus as previou20_83_3_, task0_.processId as processId83_3_, task0_.processInstanceId as process22_83_3_, task0_.processSessionId as process23_83_3_, task0_.skipable as skipable83_3_, task0_.status as status83_3_, task0_.workItemId as workItemId83_3_, task0_.OPTLOCK as OPTLOCK83_3_, user1_.id as id79_0_, user2_.id as id79_1_, user3_.id as id79_2_ from Task task0_ left outer join OrganizationalEntity user1_ on task0_.taskInitiator_id=user1_.id left outer join OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id left outer join OrganizationalEntity user3_ on task0_.createdBy_id=user3_.id where task0_.id=?
      16:29:36,287 INFO  [stdout] (Thread-73) Hibernate: select names0_.Task_Names_Id as Task6_83_1_, names0_.id as id1_, names0_.id as id80_0_, names0_.language as language80_0_, names0_.shortText as shortText80_0_, names0_.text as text80_0_ from I18NText names0_ where names0_.Task_Names_Id=?
      16:29:36,295 INFO  [stdout] (Thread-73) Hibernate: select subjects0_.Task_Subjects_Id as Task5_83_1_, subjects0_.id as id1_, subjects0_.id as id80_0_, subjects0_.language as language80_0_, subjects0_.shortText as shortText80_0_, subjects0_.text as text80_0_ from I18NText subjects0_ where subjects0_.Task_Subjects_Id=?
      16:29:36,305 INFO  [stdout] (Thread-73) Hibernate: select descriptio0_.Task_Descriptions_Id as Task7_83_1_, descriptio0_.id as id1_, descriptio0_.id as id80_0_, descriptio0_.language as language80_0_, descriptio0_.shortText as shortText80_0_, descriptio0_.text as text80_0_ from I18NText descriptio0_ where descriptio0_.Task_Descriptions_Id=?
      16:29:36,309 INFO  [stdout] (Thread-73) Hibernate: select potentialo0_.task_id as task1_83_1_, potentialo0_.entity_id as entity2_1_, organizati1_.id as id79_0_, organizati1_.DTYPE as DTYPE79_0_ from PeopleAssignments_PotOwners potentialo0_ inner join OrganizationalEntity organizati1_ on potentialo0_.entity_id=organizati1_.id where potentialo0_.task_id=?
      16:29:36,312 INFO  [stdout] (Thread-73) Hibernate: select excludedow0_.task_id as task1_83_1_, excludedow0_.entity_id as entity2_1_, organizati1_.id as id79_0_, organizati1_.DTYPE as DTYPE79_0_ from PeopleAssignments_ExclOwners excludedow0_ inner join OrganizationalEntity organizati1_ on excludedow0_.entity_id=organizati1_.id where excludedow0_.task_id=?
      16:29:36,314 INFO  [stdout] (Thread-73) Hibernate: select taskstakeh0_.task_id as task1_83_1_, taskstakeh0_.entity_id as entity2_1_, organizati1_.id as id79_0_, organizati1_.DTYPE as DTYPE79_0_ from PeopleAssignments_Stakeholders taskstakeh0_ inner join OrganizationalEntity organizati1_ on taskstakeh0_.entity_id=organizati1_.id where taskstakeh0_.task_id=?
      16:29:36,315 INFO  [stdout] (Thread-73) Hibernate: select businessad0_.task_id as task1_83_1_, businessad0_.entity_id as entity2_1_, organizati1_.id as id79_0_, organizati1_.DTYPE as DTYPE79_0_ from PeopleAssignments_BAs businessad0_ inner join OrganizationalEntity organizati1_ on businessad0_.entity_id=organizati1_.id where businessad0_.task_id=?
      16:29:36,317 INFO  [stdout] (Thread-73) Hibernate: select recipients0_.task_id as task1_83_1_, recipients0_.entity_id as entity2_1_, organizati1_.id as id79_0_, organizati1_.DTYPE as DTYPE79_0_ from PeopleAssignments_Recipients recipients0_ inner join OrganizationalEntity organizati1_ on recipients0_.entity_id=organizati1_.id where recipients0_.task_id=?
      16:29:36,320 INFO  [stdout] (Thread-73) Hibernate: select delegates0_.task_id as task1_83_1_, delegates0_.entity_id as entity2_1_, organizati1_.id as id79_0_, organizati1_.DTYPE as DTYPE79_0_ from Delegation_delegates delegates0_ inner join OrganizationalEntity organizati1_ on delegates0_.entity_id=organizati1_.id where delegates0_.task_id=?
      16:29:36,322 INFO  [stdout] (Thread-73) Hibernate: select comments0_.TaskData_Comments_Id as TaskData5_83_2_, comments0_.id as id2_, comments0_.id as id73_1_, comments0_.addedAt as addedAt73_1_, comments0_.addedBy_id as addedBy4_73_1_, comments0_.text as text73_1_, user1_.id as id79_0_ from task_comment comments0_ left outer join OrganizationalEntity user1_ on comments0_.addedBy_id=user1_.id where comments0_.TaskData_Comments_Id=?
      16:29:36,324 INFO  [stdout] (Thread-73) Hibernate: select attachment0_.TaskData_Attachments_Id as TaskData9_83_2_, attachment0_.id as id2_, attachment0_.id as id71_1_, attachment0_.accessType as accessType71_1_, attachment0_.attachedAt as attachedAt71_1_, attachment0_.attachedBy_id as attachedBy8_71_1_, attachment0_.attachmentContentId as attachme4_71_1_, attachment0_.contentType as contentT5_71_1_, attachment0_.name as name71_1_, attachment0_.attachment_size as attachment7_71_1_, user1_.id as id79_0_ from Attachment attachment0_ left outer join OrganizationalEntity user1_ on attachment0_.attachedBy_id=user1_.id where attachment0_.TaskData_Attachments_Id=?
      16:29:36,327 INFO  [stdout] (Thread-73) Hibernate: select startdeadl0_.Deadlines_StartDeadLine_Id as Deadlines4_83_1_, startdeadl0_.id as id1_, startdeadl0_.id as id75_0_, startdeadl0_.deadline_date as deadline2_75_0_, startdeadl0_.escalated as escalated75_0_ from Deadline startdeadl0_ where startdeadl0_.Deadlines_StartDeadLine_Id=?
      16:29:36,329 INFO  [stdout] (Thread-73) Hibernate: select enddeadlin0_.Deadlines_EndDeadLine_Id as Deadlines5_83_1_, enddeadlin0_.id as id1_, enddeadlin0_.id as id75_0_, enddeadlin0_.deadline_date as deadline2_75_0_, enddeadlin0_.escalated as escalated75_0_ from Deadline enddeadlin0_ where enddeadlin0_.Deadlines_EndDeadLine_Id=?
      16:29:36,330 INFO  [stdout] (Thread-73) Hibernate: select subtaskstr0_.Task_Id as Task4_83_1_, subtaskstr0_.id as id1_, subtaskstr0_.id as id81_0_, subtaskstr0_.name as name81_0_, subtaskstr0_.DTYPE as DTYPE81_0_ from SubTasksStrategy subtaskstr0_ where subtaskstr0_.Task_Id=?
      16:29:36,335 INFO  [stdout] (Thread-73) Hibernate: select task0_.id as id83_3_, task0_.archived as archived83_3_, task0_.allowedToDelegate as allowedT3_83_3_, task0_.taskInitiator_id as taskIni28_83_3_, task0_.priority as priority83_3_, task0_.activationTime as activati5_83_3_, task0_.actualOwner_id as actualO29_83_3_, task0_.completedOn as complete6_83_3_, task0_.createdBy_id as createdBy30_83_3_, task0_.createdOn as createdOn83_3_, task0_.documentAccessType as document8_83_3_, task0_.documentContentId as document9_83_3_, task0_.documentType as documen10_83_3_, task0_.expirationTime as expirat11_83_3_, task0_.faultAccessType as faultAc12_83_3_, task0_.faultContentId as faultCo13_83_3_, task0_.faultName as faultName83_3_, task0_.faultType as faultType83_3_, task0_.outputAccessType as outputA16_83_3_, task0_.outputContentId as outputC17_83_3_, task0_.outputType as outputType83_3_, task0_.parentId as parentId83_3_, task0_.previousStatus as previou20_83_3_, task0_.processId as processId83_3_, task0_.processInstanceId as process22_83_3_, task0_.processSessionId as process23_83_3_, task0_.skipable as skipable83_3_, task0_.status as status83_3_, task0_.workItemId as workItemId83_3_, task0_.OPTLOCK as OPTLOCK83_3_, user1_.id as id79_0_, user2_.id as id79_1_, user3_.id as id79_2_ from Task task0_ left outer join OrganizationalEntity user1_ on task0_.taskInitiator_id=user1_.id left outer join OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id left outer join OrganizationalEntity user3_ on task0_.createdBy_id=user3_.id where task0_.id=?
      16:29:36,342 INFO  [stdout] (Thread-73) Hibernate: select names0_.Task_Names_Id as Task6_83_1_, names0_.id as id1_, names0_.id as id80_0_, names0_.language as language80_0_, names0_.shortText as shortText80_0_, names0_.text as text80_0_ from I18NText names0_ where names0_.Task_Names_Id=?
      16:29:36,348 INFO  [stdout] (Thread-73) Hibernate: select subjects0_.Task_Subjects_Id as Task5_83_1_, subjects0_.id as id1_, subjects0_.id as id80_0_, subjects0_.language as language80_0_, subjects0_.shortText as shortText80_0_, subjects0_.text as text80_0_ from I18NText subjects0_ where subjects0_.Task_Subjects_Id=?
      16:29:36,350 INFO  [stdout] (Thread-73) Hibernate: select descriptio0_.Task_Descriptions_Id as Task7_83_1_, descriptio0_.id as id1_, descriptio0_.id as id80_0_, descriptio0_.language as language80_0_, descriptio0_.shortText as shortText80_0_, descriptio0_.text as text80_0_ from I18NText descriptio0_ where descriptio0_.Task_Descriptions_Id=?
      16:29:36,353 INFO  [stdout] (Thread-73) Hibernate: select potentialo0_.task_id as task1_83_1_, potentialo0_.entity_id as entity2_1_, organizati1_.id as id79_0_, organizati1_.DTYPE as DTYPE79_0_ from PeopleAssignments_PotOwners potentialo0_ inner join OrganizationalEntity organizati1_ on potentialo0_.entity_id=organizati1_.id where potentialo0_.task_id=?
      16:29:36,356 INFO  [stdout] (Thread-73) Hibernate: select excludedow0_.task_id as task1_83_1_, excludedow0_.entity_id as entity2_1_, organizati1_.id as id79_0_, organizati1_.DTYPE as DTYPE79_0_ from PeopleAssignments_ExclOwners excludedow0_ inner join OrganizationalEntity organizati1_ on excludedow0_.entity_id=organizati1_.id where excludedow0_.task_id=?
      16:29:36,358 INFO  [stdout] (Thread-73) Hibernate: select taskstakeh0_.task_id as task1_83_1_, taskstakeh0_.entity_id as entity2_1_, organizati1_.id as id79_0_, organizati1_.DTYPE as DTYPE79_0_ from PeopleAssignments_Stakeholders taskstakeh0_ inner join OrganizationalEntity organizati1_ on taskstakeh0_.entity_id=organizati1_.id where taskstakeh0_.task_id=?
      16:29:36,359 INFO  [stdout] (Thread-73) Hibernate: select businessad0_.task_id as task1_83_1_, businessad0_.entity_id as entity2_1_, organizati1_.id as id79_0_, organizati1_.DTYPE as DTYPE79_0_ from PeopleAssignments_BAs businessad0_ inner join OrganizationalEntity organizati1_ on businessad0_.entity_id=organizati1_.id where businessad0_.task_id=?
      16:29:36,363 INFO  [stdout] (Thread-73) Hibernate: select recipients0_.task_id as task1_83_1_, recipients0_.entity_id as entity2_1_, organizati1_.id as id79_0_, organizati1_.DTYPE as DTYPE79_0_ from PeopleAssignments_Recipients recipients0_ inner join OrganizationalEntity organizati1_ on recipients0_.entity_id=organizati1_.id where recipients0_.task_id=?
      16:29:36,364 INFO  [stdout] (Thread-73) Hibernate: select delegates0_.task_id as task1_83_1_, delegates0_.entity_id as entity2_1_, organizati1_.id as id79_0_, organizati1_.DTYPE as DTYPE79_0_ from Delegation_delegates delegates0_ inner join OrganizationalEntity organizati1_ on delegates0_.entity_id=organizati1_.id where delegates0_.task_id=?
      16:29:36,366 INFO  [stdout] (Thread-73) Hibernate: select comments0_.TaskData_Comments_Id as TaskData5_83_2_, comments0_.id as id2_, comments0_.id as id73_1_, comments0_.addedAt as addedAt73_1_, comments0_.addedBy_id as addedBy4_73_1_, comments0_.text as text73_1_, user1_.id as id79_0_ from task_comment comments0_ left outer join OrganizationalEntity user1_ on comments0_.addedBy_id=user1_.id where comments0_.TaskData_Comments_Id=?
      16:29:36,368 INFO  [stdout] (Thread-73) Hibernate: select attachment0_.TaskData_Attachments_Id as TaskData9_83_2_, attachment0_.id as id2_, attachment0_.id as id71_1_, attachment0_.accessType as accessType71_1_, attachment0_.attachedAt as attachedAt71_1_, attachment0_.attachedBy_id as attachedBy8_71_1_, attachment0_.attachmentContentId as attachme4_71_1_, attachment0_.contentType as contentT5_71_1_, attachment0_.name as name71_1_, attachment0_.attachment_size as attachment7_71_1_, user1_.id as id79_0_ from Attachment attachment0_ left outer join OrganizationalEntity user1_ on attachment0_.attachedBy_id=user1_.id where attachment0_.TaskData_Attachments_Id=?
      16:29:36,371 INFO  [stdout] (Thread-73) Hibernate: select startdeadl0_.Deadlines_StartDeadLine_Id as Deadlines4_83_1_, startdeadl0_.id as id1_, startdeadl0_.id as id75_0_, startdeadl0_.deadline_date as deadline2_75_0_, startdeadl0_.escalated as escalated75_0_ from Deadline startdeadl0_ where startdeadl0_.Deadlines_StartDeadLine_Id=?
      16:29:36,373 INFO  [stdout] (Thread-73) Hibernate: select enddeadlin0_.Deadlines_EndDeadLine_Id as Deadlines5_83_1_, enddeadlin0_.id as id1_, enddeadlin0_.id as id75_0_, enddeadlin0_.deadline_date as deadline2_75_0_, enddeadlin0_.escalated as escalated75_0_ from Deadline enddeadlin0_ where enddeadlin0_.Deadlines_EndDeadLine_Id=?
      16:29:36,374 INFO  [stdout] (Thread-73) Hibernate: select subtaskstr0_.Task_Id as Task4_83_1_, subtaskstr0_.id as id1_, subtaskstr0_.id as id81_0_, subtaskstr0_.name as name81_0_, subtaskstr0_.DTYPE as DTYPE81_0_ from SubTasksStrategy subtaskstr0_ where subtaskstr0_.Task_Id=?
      16:29:36,379 INFO  [stdout] (Thread-73) Hibernate: select content0_.id as id74_0_, content0_.content as content74_0_ from Content content0_ where content0_.id=?
      16:29:36,383 ERROR [stderr] (Thread-92) Exception in thread "Thread-92" org.hibernate.service.UnknownServiceException: Unknown service requested [org.hibernate.service.jdbc.connections.spi.ConnectionProvider]
      16:29:36,384 INFO  [stdout] (Thread-73) Hibernate: select content0_.id as id74_0_, content0_.content as content74_0_ from Content content0_ where content0_.id=?
      16:29:36,384 ERROR [stderr] (Thread-92) at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:126)
      16:29:36,385 ERROR [stderr] (Thread-92) at org.hibernate.internal.AbstractSessionImpl.getJdbcConnectionAccess(AbstractSessionImpl.java:254)
      16:29:36,386 ERROR [stderr] (Thread-92) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.<init>(JdbcCoordinatorImpl.java:75)
      16:29:36,387 ERROR [stderr] (Thread-92) at org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl.<init>(TransactionCoordinatorImpl.java:87)
      16:29:36,387 ERROR [stderr] (Thread-92) at org.hibernate.internal.SessionImpl.<init>(SessionImpl.java:227)
      16:29:36,388 ERROR [stderr] (Thread-92) at org.hibernate.internal.SessionFactoryImpl$SessionBuilderImpl.openSession(SessionFactoryImpl.java:1636)
      16:29:36,388 ERROR [stderr] (Thread-92) Exception in thread "Thread-93" at org.hibernate.ejb.EntityManagerImpl.getRawSession(EntityManagerImpl.java:120)
      16:29:36,389 ERROR [stderr] (Thread-92) at org.hibernate.ejb.EntityManagerImpl.getSession(EntityManagerImpl.java:97)
      16:29:36,389 ERROR [stderr] (Thread-92) at org.hibernate.ejb.AbstractEntityManagerImpl.joinTransaction(AbstractEntityManagerImpl.java:1184)
      16:29:36,390 ERROR [stderr] (Thread-92) at org.hibernate.ejb.AbstractEntityManagerImpl.postInit(AbstractEntityManagerImpl.java:176)
      16:29:36,390 ERROR [stderr] (Thread-92) at org.hibernate.ejb.EntityManagerImpl.<init>(EntityManagerImpl.java:89)
      16:29:36,390 ERROR [stderr] (Thread-92) at org.hibernate.ejb.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:125)
      16:29:36,391 ERROR [stderr] (Thread-92) at org.hibernate.ejb.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:120)
      16:29:36,392 ERROR [stderr] (Thread-92) at org.drools.persistence.jpa.JpaPersistenceContextManager.getApplicationScopedPersistenceContext(JpaPersistenceContextManager.java:55)
      16:29:36,392 ERROR [stderr] (Thread-92) at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:350)
      16:29:36,393 ERROR [stderr] (Thread-92) at org.drools.command.impl.CommandBasedStatefulKnowledgeSession.getEnvironment(CommandBasedStatefulKnowledgeSession.java:478)
      16:29:36,393 ERROR [stderr] (Thread-92) at org.jbpm.process.workitem.wsht.GenericHTWorkItemHandler$TaskCompletedHandler.handleCompletedTask(GenericHTWorkItemHandler.java:260)
      16:29:36,394 ERROR [stderr] (Thread-92) at org.jbpm.process.workitem.wsht.GenericHTWorkItemHandler$TaskCompletedHandler$1.run(GenericHTWorkItemHandler.java:239)
      16:29:36,394 ERROR [stderr] (Thread-92) at java.lang.Thread.run(Thread.java:744)
      16:29:36,395 ERROR [stderr] (Thread-93) org.hibernate.service.UnknownServiceException: Unknown service requested [org.hibernate.service.jdbc.connections.spi.ConnectionProvider]
      16:29:36,396 ERROR [stderr] (Thread-93) at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:126)
      16:29:36,396 ERROR [stderr] (Thread-93) at org.hibernate.internal.AbstractSessionImpl.getJdbcConnectionAccess(AbstractSessionImpl.java:254)
      16:29:36,397 ERROR [stderr] (Thread-93) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.<init>(JdbcCoordinatorImpl.java:75)
      16:29:36,397 ERROR [stderr] (Thread-93) at org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl.<init>(TransactionCoordinatorImpl.java:87)
      16:29:36,398 ERROR [stderr] (Thread-93) at org.hibernate.internal.SessionImpl.<init>(SessionImpl.java:227)
      16:29:36,398 ERROR [stderr] (Thread-93) at org.hibernate.internal.SessionFactoryImpl$SessionBuilderImpl.openSession(SessionFactoryImpl.java:1636)
      16:29:36,399 ERROR [stderr] (Thread-93) at org.hibernate.ejb.EntityManagerImpl.getRawSession(EntityManagerImpl.java:120)
      16:29:36,399 ERROR [stderr] (Thread-93) at org.hibernate.ejb.EntityManagerImpl.getSession(EntityManagerImpl.java:97)
      16:29:36,400 ERROR [stderr] (Thread-93) at org.hibernate.ejb.AbstractEntityManagerImpl.joinTransaction(AbstractEntityManagerImpl.java:1184)
      16:29:36,400 ERROR [stderr] (Thread-93) at org.hibernate.ejb.AbstractEntityManagerImpl.postInit(AbstractEntityManagerImpl.java:176)
      16:29:36,400 ERROR [stderr] (Thread-93) at org.hibernate.ejb.EntityManagerImpl.<init>(EntityManagerImpl.java:89)
      16:29:36,401 ERROR [stderr] (Thread-93) at org.hibernate.ejb.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:125)
      16:29:36,401 ERROR [stderr] (Thread-93) at org.hibernate.ejb.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:120)
      16:29:36,402 ERROR [stderr] (Thread-93) at org.drools.persistence.jpa.JpaPersistenceContextManager.getApplicationScopedPersistenceContext(JpaPersistenceContextManager.java:55)
      16:29:36,404 ERROR [stderr] (Thread-93) at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:350)
      16:29:36,404 ERROR [stderr] (Thread-93) at org.drools.command.impl.CommandBasedStatefulKnowledgeSession.getEnvironment(CommandBasedStatefulKnowledgeSession.java:478)
      16:29:36,405 ERROR [stderr] (Thread-93) at org.jbpm.process.workitem.wsht.GenericHTWorkItemHandler$TaskCompletedHandler.handleCompletedTask(GenericHTWorkItemHandler.java:260)
      16:29:36,406 ERROR [stderr] (Thread-93) at org.jbpm.process.workitem.wsht.GenericHTWorkItemHandler$TaskCompletedHandler$1.run(GenericHTWorkItemHandler.java:239)
      16:29:36,407 ERROR [stderr] (Thread-93) at java.lang.Thread.run(Thread.java:744)
      

       

      My persistence.xml is :

       

      <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
      <persistence version="1.0"
        xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
                                       http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd
                                       http://java.sun.com/xml/ns/persistence/orm 
                                       http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"
        xmlns:orm="http://java.sun.com/xml/ns/persistence/orm" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns="http://java.sun.com/xml/ns/persistence">
      <persistence-unit name="org.jbpm.task"
        transaction-type="JTA">
        <provider>org.hibernate.ejb.HibernatePersistence</provider>
        <jta-data-source>java:jboss/datasources/jbpmDS</jta-data-source>
        <mapping-file>META-INF/Taskorm-JPA2.xml</mapping-file>
      <mapping-file>META-INF/ProcessInstanceInfoMapping.xml</mapping-file>
      
        <class>org.drools.persistence.info.SessionInfo</class>
        <class>org.drools.persistence.info.WorkItemInfo</class>
        <class>org.jbpm.process.audit.ProcessInstanceLog</class>
        <class>org.jbpm.process.audit.NodeInstanceLog</class>
        <class>org.jbpm.process.audit.VariableInstanceLog</class>
      
      
        <class>org.jbpm.task.Attachment</class>
        <class>org.jbpm.task.BooleanExpression</class>
        <class>org.jbpm.task.Comment</class>
        <class>org.jbpm.task.Content</class>
        <class>org.jbpm.task.Deadline</class>
        <class>org.jbpm.task.Delegation</class>
        <class>org.jbpm.task.EmailNotification</class>
        <class>org.jbpm.task.EmailNotificationHeader</class>
        <class>org.jbpm.task.Escalation</class>
        <class>org.jbpm.task.Group</class>
        <class>org.jbpm.task.I18NText</class>
        <class>org.jbpm.task.Notification</class>
        <class>org.jbpm.task.OnAllSubTasksEndParentEndStrategy</class>
        <class>org.jbpm.task.OnParentAbortAllSubTasksEndStrategy</class>
        <class>org.jbpm.task.PeopleAssignments</class>
        <class>org.jbpm.task.Reassignment</class>
        <class>org.jbpm.task.Status</class>
        <class>org.jbpm.task.SubTasksStrategy</class>
        <class>org.jbpm.task.Task</class>
        <class>org.jbpm.task.TaskData</class>
        <class>org.jbpm.task.User</class>
        <properties>
        <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect" />
        <property name="hibernate.max_fetch_depth" value="3" />
        <property name="hibernate.hbm2ddl.auto" value="update" />
        <property name="hibernate.show_sql" value="false" />
        <property name="hibernate.transaction.manager_lookup_class"
            value="org.hibernate.transaction.JBossTransactionManagerLookup" />
        <property name="hibernate.id.new_generator_mappings" value="false" />
        </properties>
        </persistence-unit>
      
      
      </persistence>
      rLookup" />
      

       

      And my code is the next:

       

      responseHandler = new BlockingTaskOperationResponseHandler();
        ContentData cd = ContentMarshallerHelper.marshal(params, null);
        taskClient.complete(taskId, user, cd, responseHandler);
        kSession.getWorkItemManager().completeWorkItem(idSess, params);
      

       

      Thanks in advance.

        • 1. Re: Problem persisting process session
          Ramses Hernández Newbie

          Hi, checking the JBoss log, I have a previous error that I think is causing the previous error.

           

          13:07:03,294 ERROR [stderr] (Thread-87) Exception in thread "Thread-87" java.lang.RuntimeException: Timeout : unable to retrieve Attachment Content
          13:07:03,296 ERROR [stderr] (Thread-87) at org.jbpm.task.service.responsehandlers.BlockingGetContentResponseHandler.getContent(BlockingGetContentResponseHandler.java:41)
          13:07:03,297 ERROR [stderr] (Thread-87) at org.jbpm.task.service.SyncTaskServiceWrapper.getContent(SyncTaskServiceWrapper.java:320)
          13:07:03,298 ERROR [stderr] (Thread-87) at org.jbpm.process.workitem.wsht.GenericHTWorkItemHandler$TaskCompletedHandler.handleCompletedTask(GenericHTWorkItemHandler.java:259)
          13:07:03,299 ERROR [stderr] (Thread-87) at org.jbpm.process.workitem.wsht.GenericHTWorkItemHandler$TaskCompletedHandler$1.run(GenericHTWorkItemHandler.java:239)
          13:07:03,300 ERROR [stderr] (Thread-87) at java.lang.Thread.run(Thread.java:744)
          

           

          This error happend after around 3 seconds the next code is executed:

          responseHandler = new BlockingTaskOperationResponseHandler();  
            ContentData cd = ContentMarshallerHelper.marshal(params, null);  
            taskClient.complete(taskId, user, cd, responseHandler);  
            kSession.getWorkItemManager().completeWorkItem(idSess, params); 
          

           

          I hope you can help me, thanks.