Test Data Manager

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 

Hi Bala, 

This problem will be too lengthy to resolve over the community forum. Please open a support case so that we can troubleshoot this with you further. We will post the solution to here once the case is closed. 

Resolution:

When Identity_Insert is set to ON, you must include the column referenced in the insert statement.

https://docops.ca.com/ca-test-data-manager/4-0/en/getting-started/datamaker-concepts-and-features 

https://docops.ca.com/ca-test-data-manager/4-0/en/installing/upgrade-product-components 

Best regards,

Taylor

Taylor , thanks for your reply and i raised the case , please help me on this as soon as possible

The case number :     CA Support Online