IBM Support

RS03407: BRANCH MERGE FAILS WITH THERE IS ALREADY AN ITEM FOR WHICH THE PROPERTY BRM.RULEARTIFACT.DEFINITION IS ILRELEMENTHANDLE

Fixes are available

Operational Decision Manager V8.9.2.1: Interim Fix 15
Operational Decision Manager V8.9.2.1: Interim Fix 16
Operational Decision Manager V8.9.2.1: Interim Fix 18
Operational Decision Manager V8.10.2.0: Interim Fix 2
Operational Decision Manager V8.9.2.2: Interim Fix 6
Operational Decision Manager V8.9.2.2: Interim Fix 7
Operational Decision Manager V8.8.1.4: Interim Fix 5
IBM Operational Decision Manager V8.10.3 Download Document
IBM Operational Decision Manager V8.10.3 Mod Pack
Operational Decision Manager for z/OS 8.10.3 Mod Pack
Operational Decision Manager V8.10.2.0: Interim Fix 4
Operational Decision Manager V8.10.2.0: Interim Fix 5
Operational Decision Manager V8.9.2.2: Interim Fix 9
Operational Decision Manager V8.9.2.1: Interim Fix 20
Operational Decision Manager V8.10.2.0: Interim Fix 6
Operational Decision Manager V8.9.2.2: Interim Fix 10
Operational Decision Manager V8.9.2.2: Interim Fix 11
Operational Decision Manager V8.10.2.0: Interim Fix 8
Operational Decision Manager V8.8.1.4: Interim Fix 6
Operational Decision Manager V8.10.2.0: Interim Fix 9
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.10.2.0: Interim Fix 10
Operational Decision Manager V8.10.2.0: Interim Fix 11
Operational Decision Manager V8.9.2.1: Interim Fix 24
Operational Decision Manager V8.8.1.4: Interim Fix 7
Operational Decision Manager V8.10.2.0: Interim Fix 13
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
Operational Decision Manager V8.9.2.1: Interim Fix 30
Operational Decision Manager V8.9.2.1: Interim Fix 31
Operational Decision Manager V8.8.1.4: Interim Fix 9
Operational Decision Manager V8.9.2.2: Interim Fix 14
Operational Decision Manager V8.8.1.4: Interim Fix 10
Operational Decision Manager V8.8.1.4: Interim Fix 07
Operational Decision Manager V8.9.2.1: Interim Fix 34
Operational Decision Manager V8.9.2.2: Interim Fix 15 for Decision Center
IBM Operational Decision Manager V8.10.4 Mod Pack

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Merging branches may fail when processing a rule, that was
    exported from one branch and imported in the other.
    The branch merge dialog in the ODM Business Console shows the
    following message in a warning popup: "There is already an item
    for which the property
    'brm.RuleArtifact.definition' is 'IlrElementHandle@..."
    In the Decision Center server log, an exception like this
    appears:
    Error: java.sql.SQLIntegrityConstraintViolationException:
    ORA-00001: unique constraint (ODM.DEFINITIONCONTAINERUNIQUE)
    violated
     at
    oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
     at
    oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
     at
    oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
     at
    oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedState
    ment.java:208)
     at
    oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPrepar
    edStatement.java:1046)
     at
    oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleSt
    atement.java:1336)
     at
    oracle.jdbc.driver.OraclePreparedStatement.executeInternal(Oracl
    ePreparedStatement.java:3613)
     at
    oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePrepare
    dStatement.java:3714)
     at
    oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(Oracle
    PreparedStatementWrapper.java:1378)
     at
    org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute
    (DelegatingPreparedStatement.java:318)
     at
    org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute
    (DelegatingPreparedStatement.java:318)
     at sun.reflect.GeneratedMethodAccessor203.invoke(Unknown
    Source)
     at
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
    AccessorImpl.java:43)
     at java.lang.reflect.Method.invoke(Method.java:498)
     at
    ilog.rules.teamserver.transaction.logger.IlrStatementInvocationH
    andler.executeStatement(IlrStatementInvocationHandler.java:67)
     at
    ilog.rules.teamserver.transaction.logger.IlrPreparedStatementInv
    ocationHandler.invoke(IlrPreparedStatementInvocationHandler.java
    :38)
     at com.sun.proxy.$Proxy184.execute(Unknown Source)
     at sun.reflect.GeneratedMethodAccessor203.invoke(Unknown
    Source)
     at
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
    AccessorImpl.java:43)
     at java.lang.reflect.Method.invoke(Method.java:498)
     at
    ilog.rules.teamserver.progress.IlrSQLProgressProxy$StatementInvo
    cationHandler.invoke(IlrSQLProgressProxy.java:76)
     at com.sun.proxy.$Proxy184.execute(Unknown Source)
     at
    ilog.rules.teamserver.ejb.service.dao.IlrElementDAOJDBC.insertAg
    gregatedElement(IlrElementDAOJDBC.java:6128)
     at
    ilog.rules.teamserver.ejb.service.dao.IlrElementDAOJDBC.updateAg
    gregateElement(IlrElementDAOJDBC.java:8103)
     at
    ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.updateEle
    mentDetails(IlrSessionFacadeImpl.java:2921)
     at
    ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.commitAgg
    regatedElementDetails(IlrSessionFacadeImpl.java:751)
     at
    ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.commit(Il
    rSessionFacadeImpl.java:1539)
     at
    ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.commit(Il
    rSessionFacadeImpl.java:1108)
     at
    ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.commit(Il
    rSessionFacadeImpl.java:9776)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
    Method)
     at
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
    Impl.java:62)
     at
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
    AccessorImpl.java:43)
     at java.lang.reflect.Method.invoke(Method.java:498)
     at
    ilog.rules.teamserver.transaction.IlrTransactionalInvocationHand
    ler.invoke(IlrTransactionalInvocationHandler.java:107)
     at com.sun.proxy.$Proxy181.commit(Unknown Source)
     at
    ilog.rules.teamserver.model.impl.IlrAbstractSession.commit(IlrAb
    stractSession.java:2711)
     at
    ilog.rules.teamserver.model.impl.IlrAbstractCachingSession.commi
    t(IlrAbstractCachingSession.java:167)
     at
    ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.commitBra
    nchMergeToWorkingBaseline(IlrSessionFacadeImpl.java:11857)
     at
    ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.commitBra
    nchMerge(IlrSessionFacadeImpl.java:11587)
     at
    ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.commitBra
    nchMerge(IlrSessionFacadeImpl.java:11466)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
    Method)
     at
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
    Impl.java:62)
     at
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
    AccessorImpl.java:43)
     at java.lang.reflect.Method.invoke(Method.java:498)
     at
    ilog.rules.teamserver.transaction.IlrTransactionalInvocationHand
    ler.invoke(IlrTransactionalInvocationHandler.java:107)
     at com.sun.proxy.$Proxy181.commitBranchMerge(Unknown Source)
     at
    ilog.rules.teamserver.model.impl.IlrAbstractSession.commitBranch
    Merge(IlrAbstractSession.java:3566)
     at
    ilog.rules.teamserver.model.dataaccess.RTSBranchDataProvider.com
    mitBranchMerge(RTSBranchDataProvider.java:289)
     at
    ilog.rules.teamserver.model.impl.ApplyMergeRunner.run(ApplyMerge
    Runner.java:60)
     at
    ilog.rules.teamserver.model.BranchHelper.applyMerge(BranchHelper
    .java:207)
     at
    ilog.rules.teamserver.model.merge.commands.MergeBranches.applyMe
    rgeOperations(MergeBranches.java:270)
     at
    ilog.rules.teamserver.model.merge.commands.MergeBranches.applyMe
    rge(MergeBranches.java:243)
     at
    ilog.rules.teamserver.model.merge.commands.MergeBranches.apply(M
    ergeBranches.java:179)
     at
    ilog.rules.teamserver.model.commands.ConcreteCommand.execute(Con
    creteCommand.java:92)
     at
    com.ibm.rules.decisioncenter.web.core.CommandController.executeC
    ommand(CommandController.java:154)
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users merging branches using the Business Console.           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Merging branches may fail when processing a rule, that was   *
    * exported from one branch and imported in the other.          *
    * The branch merge dialog in the ODM Business Console shows    *
    * the                                                          *
    * following message in a warning popup: "There is already an   *
    * item                                                         *
    * for which the property                                       *
    * 'brm.RuleArtifact.definition' is 'IlrElementHandle@..."      *
    * In the Decision Center server log, an exception like this    *
    * appears:                                                     *
    * Error: java.sql.SQLIntegrityConstraintViolationException:    *
    * ORA-00001: unique constraint (ODM.DEFINITIONCONTAINERUNIQUE) *
    * violated                                                     *
    * at                                                           *
    * oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447 *
    * )                                                            *
    * at                                                           *
    * oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396 *
    * )                                                            *
    * at                                                           *
    * oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)  *
    * at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)  *
    * at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)    *
    * at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)     *
    * at                                                           *
    * oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedS *
    * tate                                                         *
    * ment.java:208)                                               *
    * at                                                           *
    * oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPr *
    * epar                                                         *
    * edStatement.java:1046)                                       *
    * at                                                           *
    * oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Orac *
    * leSt                                                         *
    * atement.java:1336)                                           *
    * at                                                           *
    * oracle.jdbc.driver.OraclePreparedStatement.executeInternal(O *
    * racl                                                         *
    * ePreparedStatement.java:3613)                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • The code is fixed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    RS03407

  • 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-07-03

  • Closed date

    2019-07-24

  • Last modified date

    2019-08-06

  • 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:
24 November 2021