RS03355: FAIL TO RESTORE SNAPSHOT RESTORE DUE TO DUPLICATE KEY ERROR

Operational Decision Manager V8.8.1.3: Interim Fix 95
IBM Operational Decision Manager V8.10.2 Mod Pack
IBM Operational Decision Manager V8.10.2 Download Document
Operational Decision Manager V8.9.2.2 Fix Pack
Operational Decision Manager for z/OS 8.9.2.2 Fix Pack
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.8.1.3: Interim Fix 97
Operational Decision Manager V8.8.1.4: Interim Fix 5
Operational Decision Manager V8.8.1.3: Interim Fix 98
Operational Decision Manager V8.9.2.1: Interim Fix 20
Operational Decision Manager V8.8.1.4: Interim Fix 6
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 V8.8.1.4: Interim Fix 7
Operational Decision Manager V8.9.2.1: Interim Fix 26
Operational Decision Manager V8.9.2.1: Interim Fix 27
Operational Decision Manager V8.8.1.3: Interim Fix 101
Operational Decision Manager V8.8.1.4: Interim Fix 8
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.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

APAR status

• Closed as program error.

Error description

• In Decision Center Business Console, user may fail to restore
  snapshot due to duplicate key error in VTSUITE table:
  One or more values in the INSERT statement, UPDATE statement,
  or foreign key update caused by a DELETE statement are not
  valid because the primary key, unique constraint or unique
  index identified by "3" constrains table "DB2ADMIN.VTSUITE"
  from having duplicate values for the index key.. SQLCODE=-803,
  SQLSTATE=23505, DRIVER=3.69.49
  Running Diagnostics in Decision Center shows warning in
  DB2ADMIN.BRSTUDIO able:
  DB2ADMIN.BRSTUDIO { UUID=b166ca1f-0cd3-48e7-8e32-2c29568c0690;
  PROJECT=377; ELTORIGINALID=1042; TYPE=131(validation.TestSuite)
  }
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Decision Center users in the Business console.               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Deleted elements which are un-deleted using RD               *
  * synchronization caused problems in the database keys.        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The code was 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

• R881 PSY

     UP