IBM Support

JR51409: RECEIVE SQL ERROR WHEN LOG IN OR SYNCHRONIZE USERS THAT HAVE LONG LDAP DISTINGUISHED NAMES, LONGER THAN 128 CHARACTERS

Subscribe

You can track all active APARs for this component.

 

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:

    JR51417

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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"855","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
04 January 2016