0 Replies Latest reply on Aug 26, 2015 3:03 AM by maulee17

    WorkItem info is not created

    maulee17

      Hi,

       

      After calling localtaskService.complete(taskId,userId,content), for some of the process instances, Workitem info entry is not done, task went to completed status. There is no error or exception in logs.

      The only difference found in logs for success and failure scenarios is following:

       

      SUCCESS

      -------------------

       

      8/19/15 2:18:03:029 EDT] 00000037 SystemOut     O Hibernate: select enddeadlin0_.Deadlines_EndDeadLine_Id as Deadlines5_1_, enddeadlin0_.id as id1_, enddeadlin0_.id as id14_0_, enddeadlin0_.deadline_date as deadline2_14_0_, enddeadlin0_.escalated as escalated14_0_ from Deadline enddeadlin0_ where enddeadlin0_.Deadlines_EndDeadLine_Id=?

      [8/19/15 2:18:03:031 EDT] 00000037 SystemOut     O Hibernate: select workitemin0_.workItemId as workItemId6_0_, workitemin0_.creationDate as creation2_6_0_, workitemin0_.name as name6_0_, workitemin0_.processInstanceId as processI4_6_0_, workitemin0_.state as state6_0_, workitemin0_.OPTLOCK as OPTLOCK6_0_, workitemin0_.workItemByteArray as workItem7_6_0_ from WorkItemInfo workitemin0_ where workitemin0_.workItemId=?

      [8/19/15 2:18:03:032 EDT] 00000037 SystemOut     O Hibernate: select processins0_.InstanceId as InstanceId0_0_, processins0_.OPTLOCK as OPTLOCK0_0_, processins0_.processId as processId0_0_, processins0_.startDate as startDate0_0_, processins0_.lastReadDate as lastRead5_0_0_, processins0_.lastModificationDate as lastModi6_0_0_, processins0_.state as state0_0_, processins0_.processInstanceByteArray as processI8_0_0_ from ProcessInstanceInfo processins0_ where processins0_.InstanceId=?

      [8/19/15 2:18:03:034 EDT] 00000037 SystemOut     O Hibernate: select hibernate_sequence.nextval from dual

      [8/19/15 2:18:03:035 EDT] 00000037 SystemOut     O Hibernate: select hibernate_sequence.nextval from dual

      [8/19/15 2:18:03:035 EDT] 00000037 SystemOut     O Hibernate: select hibernate_sequence.nextval from dual

      [8/19/15 2:18:03:036 EDT] 00000037 SystemOut     O Hibernate: select hibernate_sequence.nextval from dual

      [8/19/15 2:18:03:037 EDT] 00000037 SystemOut     O Hibernate: select hibernate_sequence.nextval from dual

      [8/19/15 2:18:03:038 EDT] 00000037 SystemOut     O Hibernate: select WORKITEMINFO_ID_SEQ.nextval from dual

      [8/19/15 2:18:03:039 EDT] 00000037 SystemOut     O Hibernate: select hibernate_sequence.nextval from dual

      [8/19/15 2:18:03:040 EDT] 00000037 SystemOut     O Hibernate: select hibernate_sequence.nextval from dual

      [8/19/15 2:18:03:040 EDT] 00000037 SystemOut     O Hibernate: select hibernate_sequence.nextval from dual

      [8/19/15 2:18:03:041 EDT] 00000037 SystemOut     O Hibernate: select hibernate_sequence.nextval from dual

       

       

      FAILURE:

      ---------------

       

      [8/19/15 2:08:28:014 EDT] 00000046 SystemOut     O Hibernate: select hibernate_sequence.nextval from dual

      [8/19/15 2:08:28:015 EDT] 00000046 SystemOut     O Hibernate: select subtaskstr0_.Task_Id as Task4_1_, subtaskstr0_.id as id1_, subtaskstr0_.id as id22_0_, subtaskstr0_.name as name22_0_, subtaskstr0_.DTYPE as DTYPE22_0_ from SubTasksStrategy subtaskstr0_ where subtaskstr0_.Task_Id=?

      [8/19/15 2:08:28:017 EDT] 00000046 SystemOut     O Hibernate: select startdeadl0_.Deadlines_StartDeadLine_Id as Deadlines4_1_, startdeadl0_.id as id1_, startdeadl0_.id as id14_0_, startdeadl0_.deadline_date as deadline2_14_0_, startdeadl0_.escalated as escalated14_0_ from Deadline startdeadl0_ where startdeadl0_.Deadlines_StartDeadLine_Id=?

      [8/19/15 2:08:28:020 EDT] 00000046 SystemOut     O Hibernate: select enddeadlin0_.Deadlines_EndDeadLine_Id as Deadlines5_1_, enddeadlin0_.id as id1_, enddeadlin0_.id as id14_0_, enddeadlin0_.deadline_date as deadline2_14_0_, enddeadlin0_.escalated as escalated14_0_ from Deadline enddeadlin0_ where enddeadlin0_.Deadlines_EndDeadLine_Id=?

       

      User id exist in organization entity table and it is also in the group of potential user group. Process Instance is also alive.

      Any idea why is it happening randomly ? and how can I fix it ?

       

      Thanks.