Question

Data Sync issue in Record Type

Forum|Forum|3 years ago
March 28, 2023
5 replies
0 views

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)

stefanhelzle0001

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?

shukurs2366Author

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)

adityag9712

Hi shukurs2366r, 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?