Skip to main content
A
Anonymous
April 26, 2023
Solved

Getting Sync Failed Error when Updating a Record

  • April 26, 2023
  • 3 replies
  • 1 view

Hi Everyone,

I am new to Appian and still learning basics. While updating a record, I am getting Data sync error. But if I do manual sync, record is getting updated. What should I do for automatic sync instead of doing it manually after updating a record? I am not using CDTs or DSE.

Best answer by sanchitg0002

I have seen such error in the past and it is somewhere related to mismatch in the datatype of primary key column in database and recordType. Like for example, if the primary key column in database has been set to UNSIGNED or it is BIGINT then try to change it to simple INT and then trigger a manual sync before automatic sync.

3 replies

S
sanchitg0002Answer
April 27, 2023

I have seen such error in the past and it is somewhere related to mismatch in the datatype of primary key column in database and recordType. Like for example, if the primary key column in database has been set to UNSIGNED or it is BIGINT then try to change it to simple INT and then trigger a manual sync before automatic sync.

A
Anonymous
April 27, 2023

Yep, PK in database was set to UNSIGNED. Thanks for help!!

gopalk2865
gopalk2865
Participating Frequently
April 27, 2023

hi, Can you check your record and table structure if they are configured properly. IF yes then you can also check logs once for details.

Terms & ConditionsAccessibility statement