JR44435: TW.SYSTEM.USER.PARTICIPANTGROUPS NOT WORK IN BPM 7.5.1

Version 8.0 Refresh Pack 1 for the IBM Business Process Manager products
Version 7.5.1 Fix Pack 2 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• tw.local.userParticipantGroup=tw.system.user.participantGroups[0
  ].id;
  does not work and generate below error messages
  
  
  
  -------------
  [8/22/12 2:44:34:343 GMT] 00000bda wle           E   CWLLG0594E:
  An
  exception occurred while initializing the runnable thread.
  Error:
  com.lombardisoftware.component.common.workflow.WorkflowProcessIt
  emExcept
  ion: Runtime error
   in script ("Process: 'test_coach' ProcessItem: 'get participant
  group'
  Type: 'ITEM'" 1:0).Internal Script error:
  java.lang.IllegalArgumentException: snapshotId is not the id of
  a known
  snapshot
  Script (line 1):
  <B>   1 :
  tw.local.userParticipantGroup=tw.system.user.participantGroups[0
  ].id;</B
  >
  -------------
  

Local fix

• 1. please do backup the data in below table
  
  LSW_GRP_GRP_MEM_XREF
  LSW_GRP_GRP_MEM_EXPLODED_XREF
  LSW_PARTICIPANT_GROUP
  LSW_USR_GRP_XREF
  LSW_USR_GRP_MEM_XREF
  
  2. Just run the below SQL
  
  
  CREATE GLOBAL TEMPORARY TABLE tempTable1(
  group_id DECIMAL)
  ON COMMIT PRESERVE ROWS;
  
  
  INSERT INTO tempTable1
  (SELECT group_id
  FROM BPMADMIN.lsw_participant_group
  WHERE branch_id NOT IN(SELECT branch_id FROM
  BPMADMIN.lsw_branch)
  OR snapshot_id NOT IN(
  SELECT snapshot_id FROM BPMADMIN.lsw_snapshot));
  
  select * from temptable1;
  
  
  DELETE FROM BPMADMIN.LSW_GRP_GRP_MEM_XREF WHERE
  container_group_id
  in(SELECT group_id FROM temptable1);
  DELETE FROM BPMADMIN.LSW_GRP_GRP_MEM_EXPLODED_XREF WHERE
  container_group_id in(SELECT group_id FROM temptable1);
  DELETE FROM BPMADMIN.LSW_PARTICIPANT_GROUP WHERE group_id
  in(SELECT
  group_id FROM temptable1);
  DELETE FROM BPMADMIN.LSW_USR_GRP_XREF WHERE group_id in(SELECT
  group_id
  FROM temptable1);
  DELETE FROM BPMADMIN.LSW_USR_GRP_MEM_XREF WHERE group_id
  in(SELECT
  group_id FROM temptable1);
  
  DROP TABLE tempTable1;
  
  
  Note: if the customer db is oracle, need remove the BPMADMIN
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  Business process Manager Version 7.5 and    *
  *                  later                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: TW.SYSTEM.USER.PARTICIPANTGROUPS        *
  *                      didn't work in BPMV751                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  running
  tw.local.userParticipantGroup=tw.system.user.participantGroups[0
  ].id will fail
  

Problem conclusion

• The fix introduces a new method in ProjectDeleteSupport, which
  will gather security group ids and make sure
  tw.local.userParticipantGroup=tw.system.user.participantGroups[0
  ].id can work.
  
  Install/Dependency information is available in the readme.txt
  on FixCentral. When the user goes to the download files page
  in FixCentral, the readme will be available with the fix
  package as a separate download.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  BPM ADVANCED

• Fixed component ID

  5725C9400

Applicable component levels

• R750 PSY

     UP