JR64642: GROUP SYNCHRONIZATION FAILS DURING SERVER STARTUP IF DEPRECATED GROUPS EXIST

workflow.21031.delta.repository
21.0.3-WS-CP4BA-IF007

APAR status

• Closed as program error.

Error description

• During the server startup of Business Automation Workflow the
  group synchronization reports an error in SystemOut.log
  
  [2/3/22 9:37:56:840 CET] 00000142 BaseGroupSync E
  com.lombardisoftware.server.core.BaseGroupSynchronizer
  saveUserGroups CWLLG3224E: Error saving user
  groups:[groupId(true) = UserGroup.10452, groupName(true) =
  myGroupName= (9202), displayName(true) = myGroupDisplayName=
  (9202), parentGroupId(true) = null,groupType(true) = 0,
  description(true) = MyGroupDescription= (9202), groupState(true)
  = 0, participantId(true) = null, state  = RECORD_STATE_NEW,
  saveSyncId =
  com.lombardisoftware.client.persistence.UserGroup:0,
  changedProperties: [participantId, groupName, groupType,
  displayName, groupId, parentGroupId, description, groupState]].
  The groups were not saved due to following reason:
  PreparedStatementCallback; SQL [insert into LSW_USR_GRP_XREF
  (GROUP_ID,GROUP_NAME,DISPLAY_NAME,GROUP_TYPE,DESCRIPTION,GROUP_S
  TATE,PARENT_GROUP_ID,PARTICIPANT_ID)values (?,?,?,?,?,?,?,?)];
  OR (BPMPSRR1.LSWC_GXREF_UQ) violated
  ; nested exception is
  java.sql.SQLIntegrityConstraintViolationException:
  ORA-00001:unique constraint (BPMPSRR1.LSWC_GXREF_UQ) violated
  
  PRODUCTS AFFECTED:
  IBM Business Automation Workflow
  

Local fix

Problem summary

• Ad-hoc groups are created as a result of executing team filter
  services. For reuse, a hash of all members in an ad-hoc group is
   encoded in the group's name.
  BAW 18.0.0.1 introduced a feature to delete personal data and
  group membership of users. Upon deletion of group membership,
  the hash in ad-hoc group names no longer reflects membership
  correctly, hence the concept of "deprecated groups" is
  introduced to prevent future reuse.
  
  Server startup group synchronization does not properly handle
  deprecated groups and fails to properly update the BPM database
  with correct group information.
  SystemOut.log will contain an exception message about violating
  SQL constraint LSWC_GXREF_UQ
  
  PRODUCTS AFFECTED
  IBM Business Automation Workflow
  

Problem conclusion

• A fix is available or will be available that ensures deprecated
  groups will be handled correctly during server startup Group
  synchronization
  

Temporary fix

• Not applicable.
  

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

  BUS AUTO WORKFL

• Fixed component ID

  5737H4100

Applicable component levels