IBM Support

JR47207: RUNNING UPGRADE6X.BAT MIGRATION SCRIPT RESULTS IN VIOLATION OF PRIMARY KEY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Customer ran
    the\IBM\WebSphere\AppServer\BPM\Lombardi\tools\upgrade\upgrade_6
    x>upgrad
    e_6
    x.bat migration script to upgrade development environment with
    prod data and hit this error:
    
    Jul 8, 2013 9:39:33 AM SEVERE:
    
    com.lombardi.upgrade.inflight.UpgradeContext - TWU-0043:
    Unexpected
    
    error occurred on remote call.
    
    com.lombardisoftware.client.delegate.BusinessDelegateException:
    
    PreparedStatementCallback; SQL [insert into LSW_USR_GRP_XREF
    
    (GROUP_ID,GROUP_NAME,DISPLAY_NAME,GROUP_TYPE,DESCRIPTION,GROUP_S
    TATE,PAR
    
    ENT_GROUP_ID) values (?,?,?,?,?,?,?)]; Violation of PRIMARY KEY
    
    constraint 'LSWC_GXREF_PK'. Cannot insert duplicate key in
    object
    
    'bpmadmin.LSW_USR_GRP_XREF'. The duplicate key value is
    (11520).;
    
    nested exception is java.sql.BatchUpdateException: Violation of
    PRIMARY
    
    KEY constraint 'LSWC_GXREF_PK'. Cannot insert duplicate key in
    object
    
    'bpmadmin.LSW_USR_GRP_XREF'. The duplicate key value is (11520).
    
        at
    
    com.lombardisoftware.client.delegate.BusinessDelegateException.a
    sBusines
    
    sDelegateException(BusinessDelegateException.java:41)
    
        at
    
    com.lombardisoftware.client.delegate.PersistenceServicesDelegate
    Default.
    
    save(PersistenceServicesDelegateDefault.java:271)
    
        at
    
    com.lombardisoftware.client.persistence.common.factorydelegate.U
    nversion
    
    edFactoryDelegate.save(UnversionedFactoryDelegate.java:84)
    
        at
    
    com.lombardisoftware.client.persistence.common.AbstractUnversion
    edPOFact
    
    ory.save(AbstractUnversionedPOFactory.java:159)
    
        at
    
    com.lombardisoftware.server.ejb.security.InternalGroupsCore.upda
    teIntern
    
    alGroup(InternalGroupsCore.java:65)
    
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
    Method)
    
        at
    
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
    Impl.jav
    
    a:60)
    
        at
    
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
    Accessor
    
    Impl.java:37)
    

Local fix

  • need ifix
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  IBM Business Process Manager v7.5.1.1       *
    ****************************************************************
    * PROBLEM DESCRIPTION: migration failed at step "Upgrading     *
    *                      LSW_LOG_GRP_MEM to                      *
    *                      LSW_GRP_GRP_MEM_XREF and                *
    *                      LSW_GRP_GRP_MEM_EXPLODED_XREF" due to   *
    *                      Violation of PRIMARY KEY                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Error occurs when updating the participant group type to
    internal group type.
    Issue is manifested when running
    the\IBM\WebSphere\AppServer\BPM\Lombardi\tools\upgrade\upgrade_6
    x>upgrade_6x.bat migration script to upgrade development
    environment. The issue is as follows:
    Jul 8, 2013 9:39:33 AM SEVERE:
    com.lombardi.upgrade.inflight.UpgradeContext - TWU-0043:
    Unexpected
    error occurred on remote call.
    com.lombardisoftware.client.delegate.BusinessDelegateException:
    PreparedStatementCallback; SQL [insert into LSW_USR_GRP_XREF
    (GROUP_ID,GROUP_NAME,DISPLAY_NAME,GROUP_TYPE,DESCRIPTION,GROUP_S
    TATE,PAR
    ENT_GROUP_ID) values (?,?,?,?,?,?,?)]; Violation of PRIMARY KEY
    constraint 'LSWC_GXREF_PK'. Cannot insert duplicate key in
    object
    'bpmadmin.LSW_USR_GRP_XREF'. The duplicate key value is
    (11520).;
    nested exception is java.sql.BatchUpdateException: Violation of
    PRIMARY
    KEY constraint 'LSWC_GXREF_PK'. Cannot insert duplicate key in
    object
    'bpmadmin.LSW_USR_GRP_XREF'. The duplicate key value is
    (11520).
    at
    com.lombardisoftware.client.delegate.BusinessDelegateException.a
    sBusines
    sDelegateException(BusinessDelegateException.java:41)
    at
    com.lombardisoftware.client.delegate.PersistenceServicesDelegate
    Default.
    save(PersistenceServicesDelegateDefault.java:271)
    at
    com.lombardisoftware.client.persistence.common.factorydelegate.U
    nversion
    edFactoryDelegate.save(UnversionedFactoryDelegate.java:84)
    at
    com.lombardisoftware.client.persistence.common.AbstractUnversion
    edPOFact
    ory.save(AbstractUnversionedPOFactory.java:159)
    at
    com.lombardisoftware.server.ejb.security.InternalGroupsCore.upda
    teIntern
    alGroup(InternalGroupsCore.java:65)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
    Method)
    at
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
    Impl.jav
    a:60)
    at
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
    Accessor
    Impl.java:37)
    

Problem conclusion

  • The iFix delivered removes the update participant
    group type step from migration code.
    
    Ifix is deliverred for this problem. Install/Dependency
    information is available in the readme.txt on FixCentral. When
    the user goes to the download files page in FixCentral, the
    readme will be available with the fix package as a separate
    download.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR47207

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    751

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-11

  • Closed date

    2013-09-28

  • Last modified date

    2013-09-28

  • 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

  • R750 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":"7.5.1","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
28 September 2013