View Revisions: Issue #4779

Summary 0004779: SQL Server error while syncing data with identity column
Revision 2021-01-21 07:05 by JaiGanesh S
Description Hi,

I get an error when syncing the updates for tables with Identity column in sql server. Here is the error message I get

Cannot update identity column 'Identity column name'.

This is the config I have for the table.
channel_id reload_channel_id sync_on_update sync_on_insert sync_on_delete use_stream_lobs use_capture_lobs use_capture_old_data use_handle_key_updates stream_row
default reload 1 1 1 1 0 1 1 0
Revision 2022-08-09 13:11 by elong
Description Hi,

I get an error when syncing the updates for tables with Identity column in sql server. Here is the error message I get

Cannot update identity column 'Identity column name'.

This is the config I have for the table.
channel_id reload_channel_id sync_on_update sync_on_insert sync_on_delete use_stream_lobs use_capture_lobs use_capture_old_data use_handle_key_updates stream_row
default reload 1 1 1 1 0 1 1 0