Direct links to fixes
APAR status
Closed as program error.
Error description
When you have users that have LDAP distinguished names that are longer than 128 characters, a number of actions can result in a database SQL constraint violation. These actions include: * user login to IBM BPM Process Portal * user login to IBM BPM Process Center Console * user login to IBM BPM Process Admin Console * attempt to synchronize user in IBM BPM Process Admin Console * attempt to add User to Team definition in BPM Process Designer The SQL error will be similar to the these errors: Error from Oracle database: Error 500: com.lombardisoftware.client.delegate.BusinessDelegateException: PreparedStatementCallback; uncategorized SQLException for SQL insert into LSW_USR_XREF (USER_ID,USER_NAME,FULL_NAME,PROVIDER) values (?,?,?,?) ; SQL state 72000 ; error code 12899 ; ORA-12899: value too large for column "BPM_DES"."LSW_USR_XREF"."PROVIDER" (actual: 131, maximum: 128) ; nested exception is java.sql.SQLException: ORA-12899: value too large for column "BPM_DES"."LSW_USR_XREF"."PROVIDER" (actual: 131, maximum: 128). OR a slightly different presentation of the same exception insert into LSW_USR_XREF(USER_ID, USER_NAME, FULL_NAME, PROVIDER) values (?,?,?,?)]; SQL state [72000]; error code [12899]; ORA-12899: value too large for column LSW_USR_XREF.PROVIDER. Error from DB2 database: CWLLG2229E: An exception occurred in an EJB call. Error: PreparedStatementCallback; SQL [insert into LSW_USR_XREF (USER_ID,USER_NAME,FULL_NAME,PROVIDER) values (?,?,?,?)]; Error for batch element #1: DB2 SQL Error: SQLCODE=-545, SQLSTATE=23513, SQLERRMC=DB2ADMIN.LSW_USR_XREF.PROVIDER, DRIVER=4.11.69; nested exception is com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: Error for batch element #1: DB2 SQL Error: SQLCODE=-545, SQLSTATE=23513, SQLERRMC=DB2ADMIN.LSW_USR_XREF.PROVIDER, DRIVER=4.11.69 com.lombardisoftware.core.TeamWorksException: PreparedStatementCallback; SQL [insert into LSW_USR_XREF (USER_ID,USER_NAME,FULL_NAME,PROVIDER) values (?,?,?,?)]; Error for batch element #1: DB2 SQL Error: SQLCODE=-545, SQLSTATE=23513, SQLERRMC=DB2ADMIN.LSW_USR_XREF.PROVIDER, DRIVER=4.11.69; nested exception is com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: Error for batch element #1: DB2 SQL Error: SQLCODE=-545, SQLSTATE=23513, SQLERRMC=DB2ADMIN.LSW_USR_XREF.PROVIDER, DRIVER=4.11.69
Local fix
Problem summary
The database table LSW_USR_XREF can store up to 128 characters in the PROVIDER column. If the distinguished name of a user is longer than 128 characters, you receive an SQL error.
Problem conclusion
A fix is available for IBM BPM V8.0.1.3 and V8.5.5.0 that enlarges the column size of the PROVIDER column in table LSW_USR_XREF to 256 so that users may have LDAP distinguished names that are longer than 128 characters. On Fix Central (http://www.ibm.com/support/fixcentral), search for JR51409: 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 JR51409, 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
JR51409
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
855
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-09-30
Closed date
2014-11-14
Last modified date
2016-01-04
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
R801 PSY
UP
R855 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"855","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
16 October 2021