Skip to main content
mayankv557314
mayankv557314
February 4, 2026
Question

Appian Record Sync Errors

  • February 4, 2026
  • 4 replies
  • 0 views

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
stefanhelzle0001
February 4, 2026

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

mayankv557314
mayankv557314Author
February 4, 2026

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
shubhama926776
February 4, 2026

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

harshas2775
harshas2775
February 4, 2026

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. 

Terms & ConditionsAccessibility statement