Fixes are available
Operational Decision Manager V8.9.2.1: Interim Fix 20
Operational Decision Manager V8.9.2.2: Interim Fix 11
IBM Operational Decision Manager V8.9.2.3 Fix Pack
IBM Operational Decision Manager for z/OS 8.9.2.3 Fix Pack
Operational Decision Manager V8.9.2.1: Interim Fix 22
Operational Decision Manager V8.9.2.1: Interim Fix 23
Operational Decision Manager V8.9.2.1: Interim Fix 24
Operational Decision Manager for z/OS 8.10.2.2 Fix Pack
IBM Operational Decision Manager V8.10.2.2 Fix Pack
Operational Decision Manager V8.9.2.1: Interim Fix 26
Operational Decision Manager V8.9.2.1: Interim Fix 27
Operational Decision Manager V8.9.2.2: Interim Fix 13
Operational Decision Manager V8.9.2.1: Interim Fix 28
IBM Operational Decision Manager V8.10.4 Download Document
IBM Operational Decision Manager V8.10.4 Mod Pack
IBM Operational Decision Manager for z/OS 8.10.4 Mod Pack
Operational Decision Manager V8.9.2.1: Interim Fix 30
Operational Decision Manager V8.9.2.1: Interim Fix 31
Operational Decision Manager V8.9.2.2: Interim Fix 14
Operational Decision Manager V8.9.2.1: Interim Fix 34
Operational Decision Manager V8.9.2.2: Interim Fix 15 for Decision Center
APAR status
Closed as program error.
Error description
10/17/19 16:52:28:010 PDT] 00002df5 BranchCompare I Initialization of merge details not persisted yet for xxxxx - release / %current_key [10/17/19 16:52:28:081 PDT] 00002df5 IlrSQLInvocat E INSERT INTO ILOG.MERGEDTLS(LOCALBSLN, REMOTEBSLN, ORIGINALID, TYPE, VERSION) VALUES (48347, 1971, 5387, 56, 0) Error: java.sql.BatchUpdateException: ORA-00001: unique constraint (ILOG.SYS_C0010765) violated at oracle.jdbc.d river.OraclePreparedStatement.executeBatch(OraclePreparedStateme nt.java:10345) at oracle.jdbc.driver.OracleStatementWrapper.exec uteBatch(OracleStatementWrapper.java:230) at com.ibm.ws.rsadapte r.jdbc.WSJdbcPreparedStatement.pmiExecuteBatch(WSJdbcPreparedSta tement.java:1145) at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.e xecuteBatch(WSJdbcStatement.java:855) at sun.reflect.GeneratedMethodAccessor269.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Deleg atingMethodAccessorImpl.java:55) at java.lang.reflect.Method.invoke(Method.java:613) at ilog.rules.t eamserver.transaction.logger.IlrStatementInvocationHandler.execu teStatement(IlrStatementInvocationHandler.java:59) at ilog.rules .teamserver.transaction.logger.IlrPreparedStatementInvocationHan dler.invoke(IlrPreparedStatementInvocationHandler.java:32) at com.sun.proxy.$Proxy68.executeBatch(Unknown Source) at ilog.rule s.teamserver.ejb.service.dao.util.BranchCompare.initMissingMerre sgeDtls(BranchCompare.java:954) at ilog.rules.teamserver.ejb.ser vice.dao.util.BranchCompare.initMergeDtls(BranchCompare.java:813 ) at ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.getS yncInfoData(IlrSessionFacadeImpl.java:12632) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at s un.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorI mpl.java:88) at sun.reflect.DelegatingMethodAccessorImpl.invoke( DelegatingMethodAccessorImpl.java:55) at java.lang.reflect.Method.invoke(Method.java:613) at ilog.rules.t eamserver.transaction.IlrTransactionalInvocationHandler.invoke(I lrTransactionalInvocationHandler.java:107) at com.sun.proxy.$Proxy229.getSyncInfoData(Unknown Source) at ilog. rules.teamserver.model.impl.IlrAbstractSession.getSyncInfoData(I lrAbstractSession.java:3607) at ilog.rules.teamserver.model.data access.RTSBranchDataProvider.getSyncInfo(RTSBranchDataProvider.j ava:844) at com.ibm.rules.decisioncenter.web.core.merge.MergeCon troller.getDiffsToMerge(MergeController.java:298) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Local fix
Verify the project dependencies in the branches being merged. One or more project is referenced from different branches creating this problem.
Problem summary
**************************************************************** * USERS AFFECTED: * * Users performing a merge operation from the Business * * Console. * **************************************************************** * PROBLEM DESCRIPTION: * * During merge an error is thrown "Unable to load * * /decisioncenter/s/diffsToMerge?baselineId=brm.Branch:758101: * * 758101&otherBaselineId=brm.Branch:758098:758098&handledReque * * st=true&__dcsid=df91098ea05f09c593b6a6066181ee41&dojo.preven * * tCache=1571356365342 status: 500" * * * * Exception in the log * * * * 10/17/19 16:52:28:010 PDT] 00002df5 BranchCompare I * * Initialization of merge details not persisted yet for xxxxx * * - release / %current_key * * [10/17/19 16:52:28:081 PDT] 00002df5 IlrSQLInvocat E * * INSERT INTO ILOG.MERGEDTLS(LOCALBSLN, REMOTEBSLN, * * ORIGINALID, TYPE, VERSION) VALUES (48347, 1971, 5387, 56, 0) * * Error: java.sql.BatchUpdateException: ORA-00001: unique * * constraint (ILOG.SYS_C0010765) violated * * * * at * * oracle.jdbc.driver.OraclePreparedStatement.executeBatch(Orac * * lePreparedStatement.java:10345) * * at * * oracle.jdbc.driver.OracleStatementWrapper.executeBatch(Oracl * * eStatementWrapper.java:230) * * at * * com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute * * Batch(WSJdbcPreparedStatement.java:1145) * * at * * com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeBatch(WSJdb * * cStatement.java:855) * * at sun.reflect.GeneratedMethodAccessor269.invoke(Unknown * * Source) * * at * * sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe * * thodAccessorImpl.java:55) * * at java.lang.reflect.Method.invoke(Method.java:613) * * at * * ilog.rules.teamserver.transaction.logger.IlrStatementInvocat * * ionHandler.executeStatement(IlrStatementInvocationHandler.ja * * va:59) * * at * * ilog.rules.teamserver.transaction.logger.IlrPreparedStatemen * * tInvocationHandler.invoke(IlrPreparedStatementInvocationHand * * ler.java:32) * * at com.sun.proxy.$Proxy68.executeBatch(Unknown Source) * * at * * ilog.rules.teamserver.ejb.service.dao.util.BranchCompare.ini * * tMissingMerresgeDtls(BranchCompare.java:954) * * at * * ilog.rules.teamserver.ejb.service.dao.util.BranchCompare.ini * * tMergeDtls(BranchCompare.java:813) * * at * * ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.getSy * * ncInfoData(IlrSessionFacadeImpl.java:12632) * * at sun.reflect.NativeMethodAccessorImpl.invoke0(Native * * Method) * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
An additional check was added when trying to merge two branches to detect invalid dependencies.
Temporary fix
Comments
APAR Information
APAR number
RS03499
Reported component name
WS DECISION CTR
Reported component ID
5725B6900
Reported release
892
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-10-24
Closed date
2019-11-13
Last modified date
2019-11-13
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
WS DECISION CTR
Fixed component ID
5725B6900
Applicable component levels
R892 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"892","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
03 November 2021