Hi, I'm facing the issue while executing a process.
When I ran a process it'll insert data into database. The process is working in DEV & I deployed the code in test and tried to run the process but the record sync is failing. I can see the data is inserted into table but node is failed. Also, I tried to sync manually, it's still failing.
I found the below from logs, but not much help. If anyone have idea on how to resolve this error.
2025-06-03 09:53:23,215 [Appian Timer - 1] WARN com.appiancorp.common.ObjectSynchronizer - 1 services were missing users.
2025-06-03 09:53:41,677 [RecordSyncScheduler_Worker-2] INFO com.appiancorp.record.service.quartz.LoggingTriggerListener - Trigger [group: record_load_group, name: 43_663b0ec2-ac3e-43a8-9ea1-b226c63274cc] fired for job [group: record_load_group, name: 43]
2025-06-03 09:53:41,893 [RecordSyncScheduler_Worker-2] ERROR com.appiancorp.record.service.BulkLoadServiceImpl - Unrecoverable error in record data sync com.appiancorp.suiteapi.common.exceptions.AppianException: Unable to sync due to a system failure. (APNX-1-4521-016)
Discussion posts and replies are publicly visible
Do you know if there have been any changes to the data source? Perhaps a field was modified or added recently.
Another possibility is that the data source contains values that are not allowed by the record type—such as nulls or invalid formats. You might want to check for those
I did delete everything from database and sync the record with empty table. After that I ran the process again, Still facing same issue.
Below is error message on sync
Alert
Unable to sync due to a system failure.
Details
Modified Source Rows By Primary Key: 1, 2, 3, 4, 5 and more
Recreate the record from scratch would be a option?
Could it be that one or more groups related to this record are missing in that environment?