Data Sync issue in Record Type

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 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 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 table

Dropped 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,