Fixes are available
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
IBM Operational Decision Manager V8.10.5 Download Document
IBM Operational Decision Manager V8.10.5 Refresh Pack
Operational Decision Manager V8.9.2.1: Interim Fix 30
Operational Decision Manager V8.9.2.1: Interim Fix 31
APAR status
Closed as program error.
Error description
IlrElementDAO E Was running std query: insert into ILOG.RULEARTIFACT (ID, TYPE, STARTID, ENDID, ORIGINALID, BASELINE, CATEGORIES, LOCALE, TEMPLATE, RETURNTYPE, NAME, UUID, RULEPACKAGE, DOCUMENTATION, GRP, PROJECT, PRIORITY, ACTIVE, IMPORTS) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [7/8/20 6:34:17:771 PDT] 000000a5 IlrElementDAO E Was running xtd query: insert into ILOG.RULEARTIFACTSIBLING (ID, PRIORITY_EXT, EXPIRATIONDATE, STATUS, HIGHER_ACTION, INCLUDED_COUNTRIES, INCLUDED_COUNTRIES_SELLER, OWNER, MO, CG, RULE_ID, VERSION_ID, SAMPLING, ALL_TAGS, CONSOLIDATION_RULE, DISABLE_THRESHOLD, COMPLIANCEENTITYTYPE, COMPLIANCESMNAME, COMPLIANCESMSTATE, COMPLIANCEREGION) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [7/8/20 6:34:17:962 PDT] 000000a5 IlrSQLInvocat E insert into ILOG.RULEARTIFACT (ID, TYPE, STARTID, ENDID, ORIGINALID, BASELINE, CATEGORIES, LOCALE, TEMPLATE, RETURNTYPE, NAME, UUID, RULEPACKAGE, DOCUMENTATION, GRP, PROJECT, PRIORITY, ACTIVE, IMPORTS) values (693093, 28, 1835415, 2147483647, 226935, 73426, java.io.StringReader@f9580947, en_US, 4, 2005, xxxxx, 4320ab63-b906-4672-a2ce-513f8944d7b4, 697, 2005, rtsBatch, 62, 12, T, 2005) Error: com.ibm.websphere.ce.cm.DuplicateKeyException: ORA-00001: unique constraint (ILOG.SYS_C0030195) violated at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance (NativeConstructorAccessorImpl.java:86)
Local fix
rerun the merge operation
Problem summary
**************************************************************** * USERS AFFECTED: * * Users merging branches. * **************************************************************** * PROBLEM DESCRIPTION: * * Unique constraint violation may happen when merging branches * * in Decision Center and merge will fail. * * * * IlrElementDAO E Was running std query: insert into * * ILOG.RULEARTIFACT (ID, TYPE, STARTID, ENDID, ORIGINALID, * * BASELINE, CATEGORIES, LOCALE, TEMPLATE, RETURNTYPE, NAME, * * UUID, RULEPACKAGE, DOCUMENTATION, GRP, PROJECT, PRIORITY, * * ACTIVE, IMPORTS) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, * * ?, ?, ?, ?, ?, ?, ?) [7/8/20 6:34:17:771 PDT] 000000a5 * * IlrElementDAO E Was running xtd query: insert into * * ILOG.RULEARTIFACTSIBLING (ID, PRIORITY_EXT, EXPIRATIONDATE, * * STATUS, HIGHER_ACTION, INCLUDED_COUNTRIES, * * INCLUDED_COUNTRIES_SELLER, OWNER, MO, CG, RULE_ID, * * VERSION_ID, SAMPLING, ALL_TAGS, CONSOLIDATION_RULE, * * DISABLE_THRESHOLD, COMPLIANCEENTITYTYPE, COMPLIANCESMNAME, * * COMPLIANCESMSTATE, COMPLIANCEREGION) values (?, ?, ?, ?, ?, * * ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [7/8/20 * * 6:34:17:962 PDT] 000000a5 IlrSQLInvocat E insert into * * ILOG.RULEARTIFACT (ID, TYPE, STARTID, ENDID, ORIGINALID, * * BASELINE, CATEGORIES, LOCALE, TEMPLATE, RETURNTYPE, NAME, * * UUID, RULEPACKAGE, DOCUMENTATION, GRP, PROJECT, PRIORITY, * * ACTIVE, IMPORTS) values (693093, 28, 1835415, 2147483647, * * 226935, 73426, java.io.StringReader@f9580947, en_US, 4, * * 2005, icc10_sender_t2_models, * * 4320ab63-b906-4672-a2ce-513f8944d7b4, 697, 2005, rtsBatch, * * 62, 12, T, 2005) Error: * * com.ibm.websphere.ce.cm.DuplicateKeyException: ORA-00001: * * unique constraint (ILOG.SYS_C0030195) violated at * * sun.reflect.NativeConstructorAccessorImpl.newInstance0(Nativ * * e Method) at * * sun.reflect.NativeConstructorAccessorImpl.newInstance(Native * * ConstructorAccessorImpl.java:86) * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The code is fixed.
Temporary fix
Comments
APAR Information
APAR number
RS03652
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
2020-07-21
Closed date
2020-07-22
Last modified date
2020-07-22
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