MSSSQL :: Cannot Insert Explicit Value for Identity Column
Clarify Scenario:
With Cleo Clarify we are trying to insert records, via Database Adapter, to a MSSQL table.
Clarify Issue:
We retrieved updated MSSQL gateway table descriptions. After we retrieved the data we encountered the following error when trying to move outbound Invoice data from AS400 -> Gateway
Studio Error:
Message: Cannot insert explicit value for identity column in table 'OBInvoiceHeader' when IDENTITY_INSERT is set to OFF.
State: 23000
Error Code : 544
Clarify Resolution:
- Delete SQL controlled ‘control’ field rec_id in each instance of the related tables.
- Save updated schema
- Run process
To download the issue and resolution, CLICK HERE
By: Sean Hoppe on