Fixes are available
APAR status
Closed as program error.
Error description
When merging 2 branches with a rule conflicting on a tag by overriding one the following error is thrown: There is already an item for which the property 'brm.Tag.name' is 'testing'
Local fix
resolve the conflict manually by deleting the tag in the version of the rule that is going to be modified by the merge
Problem summary
**************************************************************** * USERS AFFECTED: * * Users merging branches. * **************************************************************** * PROBLEM DESCRIPTION: * * When merging 2 branches with a rule conflicting on a tag by * * overriding one the following error is thrown: * * * * "message":"There is already an item for which the property * * 'brm.Tag.name' is 'testing'","timestamp":1610398544231} * * * * Exception * * * * Got exception :Unique index or primary key violation: * * "RULARTTAGNAMEUNIQUE ON PUBLIC.RULEARTIFACTTAG(CONTAINER, * * ENDID, NAME, BASELINE) VALUES (186, 2147483647, 'testing', * * 167, 5)"; SQL statement: * * insert into PUBLIC.RULEARTIFACTTAG (ID, CONTAINER, STARTID, * * ENDID, ORIGINALID, BASELINE, TYPE, NAME, VALUE) values (?, * * ?, ?, ?, ?, ?, ?, ?, ?) [23505-190] * * [1/11/21 20:55:44:195 GMT] 00002e00 * * ilog.rules.teamserver.ejb.service.dao.IlrElementDAOJDBC * * E Was running std query: insert into PUBLIC.RULEARTIFACTTAG * * (ID, CONTAINER, STARTID, ENDID, ORIGINALID, BASELINE, TYPE, * * NAME, VALUE) values (?, ?, ?, ?, ?, ?, ?, ?, ?) * * [1/11/21 20:55:44:206 GMT] 00002e00 * * eamserver.transaction.logger.IlrSQLInvocationExceptionLogger * * E insert into PUBLIC.RULEARTIFACTTAG (ID, CONTAINER, * * STARTID, ENDID, ORIGINALID, BASELINE, TYPE, NAME, VALUE) * * values (7, 186, 841, 2147483647, 6, 167, 62, testing, * * java.io.StringReader@16076af) * * Error: org.h2.jdbc.JdbcSQLException: Unique index or primary * * key violation: "RULARTTAGNAMEUNIQUE ON * * PUBLIC.RULEARTIFACTTAG(CONTAINER, ENDID, NAME, BASELINE) * * VALUES (186, 2147483647, 'testing', 167, 5)"; SQL statement: * * insert into PUBLIC.RULEARTIFACTTAG (ID, CONTAINER, STARTID, * * ENDID, ORIGINALID, BASELINE, TYPE, NAME, VALUE) values (?, * * ?, ?, ?, ?, ?, ?, ?, ?) [23505-190] * * at * * org.h2.message.DbException.getJdbcSQLException(DbException.j * * ava:345) * * at org.h2.message.DbException.get(DbException.java:179) * * at org.h2.message.DbException.get(DbException.java:155) * * at * * org.h2.index.BaseIndex.getDuplicateKeyException(BaseIndex.ja * * va:102) * * at * * org.h2.mvstore.db.MVSecondaryIndex.checkUnique(MVSecondaryIn * * dex.java:231) * * at * * org.h2.mvstore.db.MVSecondaryIndex.add(MVSecondaryIndex.java * * :190) * * at org.h2.mvstore.db.MVTable.addRow(MVTable.java:704) * * at org.h2.command.dml.Insert.insertRows(Insert.java:156) * * at org.h2.command.dml.Insert.update(Insert.java:114) * * at * * org.h2.command.CommandContainer.update(CommandContainer.java * * :78) * * at org.h2.command.Command.executeUpdate(Command.java:253) * * at * * org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatem * * ent.java:198) * * at * * com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WS * * JdbcPreparedStatement.java:391) * * at sun.reflect.GeneratedMethodAccessor414.invoke(Unknown * * Source) * * at * * sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe * * thodAccessorImpl.java:55) * * at java.lang.reflect.Method.invoke(Method.java:507) * * at * * ilog.rules.teamserver.transaction.logger.IlrStatementInvocat * * ionHandler.executeStatement(IlrStatementInvocationHandler.ja * * va:66) * * at * * ilog.rules.teamserver.transaction.logger.IlrPreparedStatemen * * tInvocationHandler.invoke(IlrPreparedStatementInvocationHand * * ler.java:38) * * at com.sun.proxy.$Proxy332.execute(Unknown Source) * * at sun.reflect.GeneratedMethodAccessor414.invoke(Unknown * * Source) * * at * * sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe * * thodAccessorImpl.java:55) * * at java.lang.reflect.Method.invoke(Method.java:507) * * at * * ilog.rules.teamserver.progress.IlrSQLProgressProxy$Statement * * InvocationHandler.invoke(IlrSQLProgressProxy.java:76) * * at com.sun.proxy.$Proxy332.execute(Unknown Source) * * at * * ilog.rules.teamserver.ejb.service.dao.IlrElementDAOJDBC.inse * * rtAggregatedElement(IlrElementDAOJDBC.java:6164) * * at * * ilog.rules.teamserver.ejb.service.dao.IlrElementDAOJDBC.upda * * teAggregateElement(IlrElementDAOJDBC.java:8145) * * at * * ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.updat * * eElementDetails(IlrSessionFacadeImpl.java:3024) * * at * * ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.commi * * tAggregatedElementDetails(IlrSessionFacadeImpl.java:782) * * at * * ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.commi * * t(IlrSessionFacadeImpl.java:1553) * * at * * ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.commi * * t(IlrSessionFacadeImpl.java:1139) * * at * * ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.commi * * t(IlrSessionFacadeImpl.java:9948) * * at * * ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl$34.ru * * n(IlrSessionFacadeImpl.java:12037) * * at * * ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.run(I * * lrSessionFacadeImpl.java:9710) * * at sun.reflect.GeneratedMethodAccessor283.invoke(Unknown * * Source) * * at * * sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe * * thodAccessorImpl.java:55) * * at java.lang.reflect.Method.invoke(Method.java:507) * * at * * ilog.rules.teamserver.transaction.IlrTransactionalInvocation * * Handler.invoke(IlrTransactionalInvocationHandler.java:107) * * at com.sun.proxy.$Proxy328.run(Unknown Source) * * at * * ilog.rules.teamserver.model.impl.IlrAbstractSession.run(IlrA * * bstractSession.java:2642) * * at * * ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.commi * * tBranchMergeToWorkingBaseline(IlrSessionFacadeImpl.java:1204 * * 1) * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The code has been fixed and error message updated.
Temporary fix
Comments
APAR Information
APAR number
RS03737
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
2021-01-11
Closed date
2021-01-25
Last modified date
2021-01-25
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:
06 December 2021