IDENTIFY_INSERT is set to OFF error message
Article ID: KB0078189
Updated On:
| Products | Versions |
|---|---|
| TIBCO Scribe Insight | 7.9.2 |
Description
Issue: After upgrading from TIBCO Scribe Insight 7.8.0 to 7.9.2, a DTS that ran without error in 7.8.0 now returns the following error:
[23000] SQL call failed. Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF.
The target SQL table contains an identity column. I am not explicitly setting the identity value in the integration, and “Allow auto foreign key assignment” is not enabled on the step. Where is the IDENTITY_INSERT set?
Resolution: Uncheck "Allow auto foreign key assignment" from each step in the DTS to ensure the identity column is not mapped.
[23000] SQL call failed. Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF.
The target SQL table contains an identity column. I am not explicitly setting the identity value in the integration, and “Allow auto foreign key assignment” is not enabled on the step. Where is the IDENTITY_INSERT set?
Resolution: Uncheck "Allow auto foreign key assignment" from each step in the DTS to ensure the identity column is not mapped.
- Open DTS and click on Configure Steps
- Select each Step, select the Operation tab, and uncheck the "Allow auto foreign key assignment" option.
- Save the DTS
Issue/Introduction
After upgrading to 7.9.2, DTS with target SQL table containing an identity column receives error:
[23000] SQL call failed. Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF.
Environment
TIBCO Scribe Insight
Feedback
Yes
No
Powered by
