View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0004779SymmetricDSBugpublic2021-01-21 07:052021-01-21 13:13
ReporterJaiGanesh S Assigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.12.5 
Summary0004779: SQL Server error while syncing data with identity column
DescriptionHi,

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
Tagsdata sync, dialect: sql-server

Activities

JaiGanesh S

2021-01-21 07:05

reporter  

image.png (14,460 bytes)   
image.png (14,460 bytes)   

elong

2021-01-21 13:13

developer   ~0001882

That error came up during testing of 3.12.6 and was fixed. Try using version 3.12.6.

Issue History

Date Modified Username Field Change
2021-01-21 07:05 JaiGanesh S New Issue
2021-01-21 07:05 JaiGanesh S Tag Attached: data sync
2021-01-21 07:05 JaiGanesh S Tag Attached: dialect: sql-server
2021-01-21 07:05 JaiGanesh S File Added: image.png
2021-01-21 13:13 elong Note Added: 0001882