IBM Support

IT15888: SERVICES INSTALLATION OR SETUP CHANGES ARE NOT PUBLISHED IN AN IBM STERLING B2B INTEGRATOR CLUSTER CAUSING PKEY VIOLATION

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Changes to Services Installation or Setup configuration are not
    published to other nodes in an IBM Sterling B2B Integrator
    cluster.
    
    This causes primary key constraint violation when trying to
    re-apply the configuration changes manually on the other node.
    
    Simulation Steps
    Node 1 > Dashboard > Deployment > Services > Installation/Setup
    > choose any service with editable options (e.g. WebSphereMQ
    Suite Open Session)
    > verify current settings by clicking service name
    ("WebSphereMQ Suite Open Session") > e.g. "Trace Level (1-5)"
    is "5"
    > edit > change any option (e.g. set Trace Level (1-5): 1) >
    save > finish > return
    > verify changes setting by clicking service name ("WebSphereMQ
    Suite Open Session") > "Trace Level (1-5)" is "1"
    Node 2 > Dashboard > Deployment > Services > Installation/Setup
    > choose the same service that has been changed on node 1
    > verify current settings by clicking service name
    ("WebSphereMQ Suite Open Session") > "Trace Level (1-5)" is
    still "5"
    > edit > change any option (e.g. set Trace Level (1-5): 1) >
    save > finish > "The system update ended with errors. Check
    system logs for more details."
    noapp.log, system.log and ui.log on node 2 are showing
    [2016-03-02 11:04:05.562] ERROR 000410010018
    SERVICES.SERVICES.ERR_SDI_save SDI.save
    [2016-03-02 11:04:05.562] ERROR [1456913045562] DB2 SQL Error:
    SQLCODE=-803, SQLSTATE=23505,
    SQLERRMC=1;SI525_W2012_CLUSTER.SERVICE_DEF_PARMS, DRIVER=4.19.26
    [2016-03-02 11:04:05.562] ERRORDTL
    [1456913045562]com.ibm.db2.jcc.am.SqlIntegrityConstraintViolatio
    nException: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505,
    SQLERRMC=1;SI525_W2012_CLUSTER.SERVICE_DEF_PARMS, DRIVER=4.19.26
        at com.ibm.db2.jcc.am.kd.a(Unknown Source)
        at com.ibm.db2.jcc.am.kd.a(Unknown Source)
        at com.ibm.db2.jcc.am.kd.a(Unknown Source)
        at com.ibm.db2.jcc.am.fp.b(Unknown Source)
        at com.ibm.db2.jcc.am.fp.c(Unknown Source)
        at com.ibm.db2.jcc.t4.bb.l(Unknown Source)
        at com.ibm.db2.jcc.t4.bb.a(Unknown Source)
        at com.ibm.db2.jcc.t4.p.a(Unknown Source)
        at com.ibm.db2.jcc.t4.wb.b(Unknown Source)
        at com.ibm.db2.jcc.am.gp.tc(Unknown Source)
        at com.ibm.db2.jcc.am.gp.b(Unknown Source)
        at com.ibm.db2.jcc.am.gp.lc(Unknown Source)
        at com.ibm.db2.jcc.am.gp.executeUpdate(Unknown Source)
        at
    com.sterlingcommerce.woodstock.services.SDI.save(SDI.java:1065)
        at
    com.sterlingcommerce.woodstock.ui.ServiceEditor.save(ServiceEdit
    or.java:322)
        at
    com.sterlingcommerce.woodstock.ui.ServiceEditor.save(ServiceEdit
    or.java:310)
        at
    com.sterlingcommerce.woodstock.adminui.servlet.SaveService.run(S
    aveService.java:114)
    customer has reported the following exception (quite the same
    for Oracle DB instead of DB2 above)
    2016-02-22 08:39:07.907] ERROR 000410010018
    SERVICES.SERVICES.ERR_SDI_save SDI.save
    [2016-02-22 08:39:07.907] ERROR [1456130347907] ORA-00001:
    unique constraint (MFG_OWNER.SCI_PK_156) violated
    [2016-02-22 08:39:07.908] ERRORDTL
    [1456130347907]java.sql.SQLIntegrityConstraintViolationException
    : ORA-00001: unique constraint (MFG_OWNER.SCI_PK_156) violated
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
    at
    oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedState
    ment.java:205)
    at
    oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPrepar
    edStatement.java:1008)
    at
    oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleSt
    atement.java:1307)
    at
    oracle.jdbc.driver.OraclePreparedStatement.executeInternal(Oracl
    ePreparedStatement.java:3449)
    at
    oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OracleP
    reparedStatement.java:3530)
    at
    oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(
    OraclePreparedStatementWrapper.java:1350)
    at
    com.sterlingcommerce.woodstock.services.SDI.save(SDI.java:1065)
    at
    com.sterlingcommerce.woodstock.ui.ServiceEditor.save(ServiceEdit
    or.java:322)
    at
    com.sterlingcommerce.woodstock.ui.ServiceEditor.save(ServiceEdit
    or.java:310)
    at
    com.sterlingcommerce.woodstock.adminui.servlet.SaveService.run(S
    aveService.java:114)
    

Local fix

  • call: "./bin/opscmd.sh -nnode2 -cREFRESHSDI
    -pID=WSMQOpenSession"
    or restart node
    

Problem summary

  • Users Affected:
    All
    
    Problem Description:
    Changes to Services Installation/Setup configuration are not
    published to other nodes in an IBM Sterling B2B Integrator
    cluster.
    This causes primary key constraint violation when trying to
    reapply the configuration changes manually on the other node.
    
    Platforms Affected:
    All
    

Problem conclusion

  • Resolution Summary:
    A code fix is provided.
    
    Delivered In:
    5020500_14
    5020603
    5020601_7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT15888

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    525

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-06-28

  • Closed date

    2016-09-27

  • Last modified date

    2017-03-08

  • 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

    STR B2B INTEGRA

  • Fixed component ID

    5725D0600

Applicable component levels

  • R525 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.5","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
08 March 2017