Hi Techie,
Record is getting updating/inserting in the external database however when coming to Record Type, it is failing to sync.Can anyone please look on it.
Caused by: com.appiancorp.core.expr.exceptions.IssuedException: com.appiancorp.core.expr.exceptions.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error [evaluation ID = f7383:f3bde] at function a!recordList: An error occurred while retrieving the data for "PEG_CMP Request". Details: 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. (APNX-1-4198-000)
Discussion posts and replies are publicly visible
Did you already visit the documentation about how to resolve sync errors? Did you already check the log files? Did you create the database table manually? What is the table structure?
Hi Shukur,
As Stefan mentioned check the table structure and data again. Or check out the Appian documentation.
docs.appian.com/.../Records_Monitoring_Details.html
Hi Stefan,Table was created manually in external DB.Approval Record was syncing without any issues, but Request Record was not syncing, if I do manual sync then it is syncing. I found this in system logs:Caused by: com.appiancorp.core.expr.exceptions.IssuedException: com.appiancorp.core.expr.exceptions.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error [evaluation ID = f7383:f3bde] at function a!recordList: An error occurred while retrieving the data for "PEG_CMP Request". Details: 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. (APNX-1-4198-000)
Hi Shukur, can you please verify, are all the fields you using have correct dataType and does your table contains more then 50 fields in table you have created the record Type?
Hi Techies,Thanks to | subhad |
Issue - Data structure difference between the Appian and Db tableDropped Foreign key and index of the Child table,Dropped Primary key constraint for Parent Table,|Altered data type & added Primary key to thr RequestId of the Parent Table, Added Relationships in the Child table,