Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!
The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
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.
Discussion posts and replies are publicly visible
Do you see any additional details in the tomcat stdout log file?
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?
It might be the possibility that, Concurrent writes from multiple processes/records to the same primary keys create sync conflicts.
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.