JR40404: When a PK in deleted in source db, reimport of tables with IEM OR istools resutls in DeleteViolatesRestrictRuleException

APAR status

• Closed as program error.

Error description

• customer deleted a PK in the source DB and tried to re import
  the table and it fails with:-
  
  com.ascential.xmeta.exception.data.DeleteViolatesRestrictRuleExc
  eption: The request to delete DataField object with RID
  "b1c497ce.60641b50.agjj34ajo.4hni6im.elm7ar.1l8pjeh1llo23u0p464m
  8" violates a restrict delete rule on the reference
  "references_DataField" from KeyComponent object with RID
  "b1c497ce.99fdad7e.agjj34ajo.u5js9dc.2c7163.h4papms5m3b767eib5b7
  u"
  

Local fix

Problem summary

• Re-import of database table using Import Export Manager or
  istool command line interface after deleting a primary key of a
  table fails with:-
  com.ascential.xmeta.exception.data.DeleteViolatesRestrictRuleExc
  eption: The request to delete DataField object with RID
  "b1c497ce.60641b50.agjj34ajo.4hni6im.elm7ar.1l8pjeh1llo23u0p464m
  8" violates a restrict delete rule on the reference
  "references_DataField" from KeyComponent object with RID
  "b1c497ce.99fdad7e.agjj34ajo.u5js9dc.2c7163.h4papms5m3b767eib5b7
  u"
  

Problem conclusion

• Removed the RESTRICT delete rule for
  KeyComponent->references_DataField and
  ForeignKey->references_CandidateKey.
  
  Limitations with the patch:
  If the user re-imports tables by filtering primary keys, then
  primary keys are deleted in the target repository, but not the
  foreign keys that reference the deleted primary keys. As a
  result, the foreign keys that reference these primary keys
  become invalid. Later, to re-construct the foreign key
  relationships, the user needs to re-import the tables that
  contain the invalidated foreign keys.
  

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

  WIS INFORM ANAL

• Fixed component ID

  5724Q36IA

Applicable component levels

• R850 PSY

     UP