search cancel

TDM - Error while registering Tables from DataMaker

book

Article ID: 257010

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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 4.10.5.0.

Portal version is 4.10.82.0.

Environment

Release : 4.10

Resolution

 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.