We are getting an error on PROD saying "Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator".
Checked the failed sync reason and it says "Unable to sync due to system failure". And Event type for this error is "Write To source".
This happened only on one particular day (17th September) and there is no error before or after that day.
We debugged and did not find any exact reason why it happened. The only reason we can see that there was some activity happened on DB side on that day and one of our scheduler Process in Appian runs everyday which updates the data in DB in batching of 65 rows so due to which this error might came.
Can anyone please suggest on which logs we can refer to look out for root cause of this failure and find that this issue happened cause of some DB connection or any other reason. In tomcat-stdout.log also did not found much detail.
Thanks in Advance..
Discussion posts and replies are publicly visible
Hello Nilesh, In tomcat-stdOut.log.2023-09-17 log file if you search with the UUID of the record, you will find the issue. Even I faced a similar issue with batching and it is due to Authentication issue. please try to check the issue in this way. Hope this will be helpful to troubleshoot the issue.