Direct links to fixes
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