JR53171: SYNCHRONIZING GROUPS WHEN THE SERVER STARTS DUPLICATES GROUP ENTRIES IF CAPITALIZATION WAS CHANGED IN THE USER REGISTRY

8.0.1.1-WS-BPM-IFJR53171
8.0.1.2-WS-BPM-IFJR53171
8.5.6.0-WS-BPM-IFJR53171
bpm.8560.cf1.delta.repository.1
bpm.8560.cf1.delta.repository.2
8.0.1.3-WS-BPM-IFJR53171
8.5.0.1-WS-BPM-IFJR53171
8.5.5.0-WS-BPM-IFJR53171
Version 8.5.0 Fix Pack 2 for the IBM Business Process Manager products
Version 8.5 Refresh Pack 7 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• The IBM Business Process Manager (BPM) database contains entries
  for groups that are imported from the user registry. If the
  capitalization of a group name is changed in the user registry,
  IBM BPM mistakenly tries to create an entry in the database the
  next time the server starts. This attempt fails with the
  following exception when SQL-SERVER is in use as database:
  
  java.sql.BatchUpdateException: Cannot insert duplicate key row
  in object
  
  'dbo.LSW_USR_GRP_XREF' with unique index 'LSWC_GXREF_UQ'.
  
     This is the error message logged with this exception.
  [3/19/15 14:51:15:235 CDT] 00000078 wle_servlet   E
  CWLLG0055E:
  Initialization of a new login has failed due to an unexpected
  exception.   Error:
  com.lombardisoftware.client.delegate.BusinessDelegateException:
  PreparedStatementCallback; SQL [insert into LSW_USR_GRP_MEM_XREF
  (USER_ID, GROUP_ID) values (?, ?)]; The INSERT statement
  conflicted with the FOREIGN KEY constraint "LSWC_UGXREF_FK2".
  The conflict occurred in database "BPMDB", table
  "bpmuser.LSW_USR_GRP_XREF", column 'GROUP_ID'.; nested
  exception is
  com.microsoft.sqlserver.jdbc.SQLServerException: The INSERT
  statement conflicted with the FOREIGN KEY constraint
  "LSWC_UGXREF_FK2".
  The conflict occurred in database "BPMDB", table
  "bpmuser.LSW_USR_GRP_XREF", column 'GROUP_ID'.
  
  com.lombardisoftware.client.delegate.BusinessDelegateException:
  PreparedStatementCallback; SQL [insert into LSW_USR_GRP_MEM_XREF
  (USER_ID, GROUP_ID) values (?, ?)]; The INSERT statement
  conflicted with the FOREIGN KEY constraint "LSWC_UGXREF_FK2".
  The conflict occurred in database "BPMDB", table
  "bpmuser.LSW_USR_GRP_XREF", column 'GROUP_ID'.; nested
  exception is
  com.microsoft.sqlserver.jdbc.SQLServerException: The INSERT
  statement conflicted with the FOREIGN KEY constraint
  "LSWC_UGXREF_FK2".
  The conflict occurred in database "BPMDB", table
  "bpmuser.LSW_USR_GRP_XREF", column 'GROUP_ID'.
      at
  com.lombardisoftware.client.delegate.BusinessDelegateException.a
  sBusinessDelegateException(BusinessDelegateException.java:41)
      at
  com.lombardisoftware.client.delegate.common.WebsphereDelegateHel
  per.doAsCurrentSubjectContextSensitive
  (WebsphereDelegateHelper.java:199)
      at
  com.lombardisoftware.client.delegate.SecurityDelegateDefault.ini
  tializeN ewLogin(SecurityDelegateDefault.java:201)
  

Local fix

• In the Process Admin Console, select IBM BPM Admin and then
  select ManageCaches. On the page that opens, click Reset to
  clear the GroupInfoCache.
  

Problem summary

• No additional information is available.
  

Problem conclusion

• A fix is/will be available for IBM BPM that makes sure that
  group names are identified as equivalent if only the
  capitalization of their names differs. When the server starts, a
  group  is not added to the database corresponding to the group
  whose name capitalization changed if the group name exists in
  the database in a different capitalization style.
  
  On Fix Central (http://www.ibm.com/support/fixcentral), search
  for JR53171:
  
  1. Select IBM Business Process Manager with your edition from
    the product selector, the installed version to the fix pack
    level, and your platform, and then click Continue.
  
  2. Select APAR or SPR, enter JR53171, and click Continue.
  
  When you download fix packages, ensure that you also download
  the readme file for each fix. Review each readme file for
  additional installation instructions and information about the
  fix.
  

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

  BPM STANDARD

• Fixed component ID

  5725C9500

Applicable component levels