Support Article
Error on obj-save on a table with an identity column
SA-14973
Summary
Error on performing obj-save on a table that has an identity column.
Error Messages
Step Status FAIL
Step Status Info
Problem writing an instance to the database: code: 8102 SQLState: S0001 Message: Cannot update identity column 'your_column'.
Steps to Reproduce
- Define a column as identity column in a table.
- Try to perform obj-save on that table.
Root Cause
Pega does not support obj-save on a table where any column is defined as identity column.
Resolution
Use Rule-Conect-Sql or RDB-save instead of obj-save.
Published October 20, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.