Error: ora-00001: unique constraint ( pk_txt_header ) violated

SYMPTOM:

image

odi-10182: Uncategorized exception during repository access

ora-00001: unique constraint ( pk_txt_header) violated

 

CAUSE:

The table definition was created by duplicating metadata for another table. Indexes are defined as constraints in ODI, when duplicating the original table object the index definitions are duplicated with the original names, for some reason this does not trigger an error at the time of duplicating the tables, the primary key validation for the index name is triggered –in my case- at the time of saving a mapping where the table duplicate is a target.

 

SOLUTION:

On Design > Models look up the duplicate table. Once located review and update the names of each of the constraints / indexes defined on metadata and save them. Once you have completed the review you should be able to save the mapping throwing the original issue message.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.