RS01465: MIGRATION SCRIPT MAY FAIL WITH BASELINECONTENT FOREIGN KEY VIOLATION.

Operational Decision Manager V8.5.1: Interim Fix 13 Rev B
Operational Decision Manager V8.0.1.2 Fix Pack
Operational Decision Manager V8.5.1: Interim Fix 23 Revision B
Operational Decision Manager V8.5.1.1 Fix Pack
Operational Decision Manager V8.5.1.0: Interim Fix 69

APAR status

• Closed as program error.

Error description

• The migration script may fail if the migrated repository
  contains "orphaned" versions. Those are records in the version
  tables that are not referenced by any element.
  This should not happen in usual case.
  Depending on the database, the SQL error will be similar to :
  "insert or update on table baselinecontent violates foreign key
  
  constraint baselinecontent_version".
  

Local fix

• Delete this record from the BASELINECONTENT table in the old
  schema :
  delete from <oldSchema>.BASELINECONTENT where VERSION =
  <orphanId>
  

Problem summary

• orphan versions can be found in a repository and the migration
  scripts does not expect this type and fails
  

Problem conclusion

• the migration scripts is modified so that orphan elements are
  included in the migration so that no error is generated.
  

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:

Modules/Macros

• 999
  

Fix information

• Fixed component name

  WS DECISION CTR

• Fixed component ID

  5725B6900

Applicable component levels

• R851 PSY

     UP