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.
Discussion posts and replies are publicly visible
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.
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.
Yep, PK in database was set to UNSIGNED. Thanks for help!!