odi-10182: Uncategorized exception during repository access Error: ora-00001: unique constraint ( pk_txt_header ) violated

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

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.

SOLUTION1:
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.

or

SOLUTION2:
Please check if all the table names used in interface mapping expressions are in interface source tables list/interface joins list because all the tables in mapping expressions are referenced with tables used in interface table source list.