IBM Support

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

Subscribe

You can track all active APARs for this component.

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

  • 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

  • R801 PSY

       UP

  • R850 PSY

       UP

  • R855 PSY

       UP

  • R856 PSY

       UP



Document information

More support for: IBM Business Process Manager Standard

Software version: 8.0.1

Reference #: JR53171

Modified date: 19 August 2015