> > MSSQL Insert


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

Cleo Clarify / Remove entries from schema text editor

To download the issue and resolution, CLICK HERE

By: on