Skip to main content
mayankv557314
Known Participant
Feb 4, 2026 6:54 AM UTC
Question

Appian Record Sync Errors

HI All, We have been constantly facing an issue with Appian Records where whenever a smart service writes data to a table using write to records, an error is triggered like - Modified Source Rows By Primary Key: 246113, 246112, 246117, 246107, 246111. Manual Sync never fails afterwards and is always successful.

Note: We have multiple records referring the same Table which fails.

4 replies

stefanhelzle0001
Brainy
Feb 4, 2026 6:56 AM UTC

Do you see any additional details in the tomcat stdout log file?

mayankv557314
Known Participant
Feb 4, 2026 6:59 AM UTC

No Stefan. Nothing in stdout log file. Could It be a race condition since a 4 record types point to the same DB table (Note: Its MS SQL Server DB) and appian is attempting to sync all of them on a single write?

shubhama926776
Brainy
Feb 4, 2026 8:25 AM UTC

It might be the possibility that, Concurrent writes from multiple processes/records to the same primary keys create sync conflicts.

शुभम्
harshas2775
Brainy
Feb 4, 2026 8:58 AM UTC

The concurrency can create lock conditions and resulting in the error. Are you facing any data loss as well? I would assume from multiple records if write records is happening, possibility exists for data overwriting instead of insertion in the table. 

Happy to help. Even happier to optimize.