search cancel

TDM - Error while registering Tables from DataMaker


Article ID: 257010


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


While trying to register table from DataMaker ,I am getting error as "Violation of PRIMARY KEY constraint 'gtrep_table_col_def_pk'. Cannot insert duplicate key in object 'dbo.gtrep_table_col_def'. The duplicate key value is (0)." 

The DataMaker Version we are using is

Portal version is


Release : 4.10


 It'll be huge effort to fix the issue in DM. So as an alternative we are suggesting the following options:

1) If you don't care about the data in repository database we can reset the sequence and delete the data.

2) Or we can export the data, reset the sequence, delete the data and import exported data again. In that case we also suggest to test the import first before the database is cleaned.