Direct links to fixes
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 number
JR53171
Reported component name
BPM STANDARD
Reported component ID
5725C9500
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-04-21
Closed date
2015-06-10
Last modified date
2015-08-19
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
31 August 2023