RS03652: UNIQUE CONSTRAINT VIOLATION MAY HAPPEN WHEN MERGING BRANCHES

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