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

si_52_build_5020500_interimfix_14
si_52_build_5020500_interimfix_14
si_52_build_5020500_interimfix_14

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 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