Test Data Manager

Tech Tip: Datamaker: Violation of PRIMARY KEY constraint 'gtrep_clob_pk'. Cannot insert duplicate key in object 'dbo.gtrep_clob'.

  • 1.  Tech Tip: Datamaker: Violation of PRIMARY KEY constraint 'gtrep_clob_pk'. Cannot insert duplicate key in object 'dbo.gtrep_clob'.

    Posted Jan 04, 2018 04:32 PM

    We are trying to use the copy repository function to copy the projects between environments. However, this does not copy the saved sql programs. After the copying everything else, we try to create the sql programs manually, but it conflicts with existing data and we receive the following error message:

     

    Database Error Message: SQLSTATE = 23000 
    Microsoft SQL Server Native Client 10.0 
    Violation of PRIMARY KEY constraint 'gtrep_clob_pk'. Cannot 
    insert duplicate key in object 'dbo.gtrep_clob'. The duplicate 
    key value is (xxxx). 

     

    Transaction Error Code: -1 
    Database Error Code: 2627 

     

    To view the cause and resolution of this issue, please go here- https://support.ca.com/us/knowledge-base-articles.TEC1852635.html