IBM Support

A SqlIntegrityConstraintViolationException occurs during the group replication process for IBM Business Process Manager (BPM)

Troubleshooting


Problem

When IBM Business Process Manager (BPM) is configured to use LDAP and LDAP has duplicate groups, a SqlIntegrityConstraintViolationException gets thrown during group replication process. Additionally, upon server startup, LDAP groups are not visible from WebSphere Application Server Administrative Console or Process Admin Console.

Symptom

Group replication is a process of synchronizing external security repositories with the Business Process Manager database. This process is kicked off at following times:

  • Automatically during server start up.
  • Internally when system components request with a Java™ Message Service (JMS) cache reset message.
  • Manually when an administrator logs on to Process Admin Console and clicks theGroup Cache reset button.


With the previously described problem, the error messages are similar to the following text:
Caused by: com.lombardisoftware.client.delegate.BusinessDelegateException: PreparedStatementCallback; SQL [insert into LSW_USR_GRP_XREF (GROUP_ID,GROUP_NAME,DISPLAY_NAME,GROUP_TYPE,DESCRIPTION,GROUP_STATE,PARENT_GROUP_ID) values (?,?,?,?,?,?,?)]; Error for batch element #41: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=2;DB2BPM.LSW_USR_GRP_XREF, DRIVER=3.61.65; nested exception is com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: Error for batch element #41: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=2;DB2BPM.LSW_USR_GRP_XREF, DRIVER=3.61.65

The stack trace is similar to the following text:
Caused by: com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: Error for batch element #41: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=2;DB2BPM.LSW_USR_GRP_XREF, DRIVER=3.61.65
at com.ibm.db2.jcc.am.ed.a(ed.java:672)
at com.ibm.db2.jcc.am.ed.a(ed.java:60)
at com.ibm.db2.jcc.am.ed.a(ed.java:127)
at com.ibm.db2.jcc.t4.cb.a(cb.java:480)
at com.ibm.db2.jcc.t4.cb.a(cb.java:69)
at com.ibm.db2.jcc.t4.q.a(q.java:57)

[{"Product":{"code":"SSFTN5","label":"IBM Business Process Manager Advanced"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Security","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"8.0.1;8.0;7.5.1.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Security","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"","label":"Linux zSeries"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.0.1;8.0;7.5.1.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSFTBX","label":"IBM Business Process Manager Express"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Security","Platform":[{"code":"PF016","label":"Linux"},{"code":"","label":"Linux zSeries"},{"code":"PF033","label":"Windows"}],"Version":"8.0.1;8.0;7.5.1.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
28 April 2025

UID

swg21619620

Page Feedback