AnsweredAssumed Answered

Identity_Insert in Test Data Manager in 3.6 is not working and it is error out

Question asked by bala.madamala on Jan 11, 2017
Latest reply on Jan 11, 2017 by bala.madamala

i am getting the below error :

Publish errors

Error 545 for Row #1 in table CAP_RLS_AWARD. SQLSTATE = 37000
[Microsoft][SQL Server Native Client 10.0][SQL Server]Explicit value must be specified for identity column in table 'CAP_RLS_AWARD' either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column.

No changes made to database.

INSERT INTO dbo.CAP_RLS_AWARD ( CAP_RLS_OFR_NBR, CAP_RLS_BID_NBR, ACCTG_CO_ID, CTRCT_NBR, CTRCT_TYPE, DLY_QTY, MAX_AVBL_STOR_CAP, REPL_TOT_VAL, LAST_MOD_USER_ID, LAST_MOD_DATE, CTRCT_DMD_QTY, CTRCT_SRVC_TYPE, INTRADAY_DLY_QTY ) VALUES ( 36285, 0, 1, 142482, 'TFO', 24523, 0, 448415931.0500, 'MICHELLA', '2007-05-02 11:56:08.700', 0, 'TF-1', 1646)
Deleted 1 rows from CAP_RLS_OFR.
Deleted 0 rows from cap_rls_recall_tree_pt.

 

Now how i can turn this on in CA Test Data Manager 3.6 or is there any way to handle the identity columns in the Test Data Manager ? Please help me out on this 

Outcomes