Cannot Insert Explicit Value for Identity Column for MSSQL Database Adapter
Scenario:
AFter performing a transformation in our business process, we attempt to perform a SQL database insert. While attmpting to do the insert into the MSSQL table we get an error.
The error below is issued when we perform the SQL Insert to the MSSQL JDBC connection.
Issue:
When MS SQL table was set-up via SQL CREATE command, an identity column was created.
EXTOL error message:
Step #4: Execute Adapter: insert using F47011 Prod Schema
[INFO] - Starting Comm
[INFO] - Invoking Interface Adapter.
[INFO] - Name : F4011_insert_PO
[INFO] - Version : 1.0
[INFO] - Interaction : Insert
[INFO] - com.extol.logging.framework.storage.LogStorageNode@66e4ec53
[INFO] - JDBC Resource Adapter is executing a batch with 1 rows.
[INFO] - JDBC Resource Adapter is executing a batch with 3 rows.
[ERROR] - SQLException:
Message : Cannot insert explicit value for identity column in table 'F47011' when IDENTITY_INSERT is set to OFF.
State : 23000
Error Code : 544
Resolution:
DBA removed identity column and SQL insert performed without any issues.
By: Sean Hoppe on
