Record Sync : Unable to Sync due to system issue

Certified Lead Developer

Facing the following error when creating a new record where record sync is enabled. No recent changes in the code or in the record.

The record is marked as synced but its data has not yet been synced.

More than 50% of the hard disk space is available in the server. Doesn't seem to be a disk space issue. 

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer

    I recently ran into this exact error message and scenario (writes to DSE consistently caused Record Type's data sync to fail, even though the data changes do get persisted, and manually running a data sync has no problems). In my case, the underlying database table's PK was configured as INT UNSIGNED. When I updated it to be simply INT, the data sync errors on DSE writes went away.

    I have no idea why the use of UNSIGNED might cause this data sync error, or why Appian might complain about updating "the same entity multiple times in the same transaction", when that's not what was going on.

Reply
  • 0
    Certified Senior Developer

    I recently ran into this exact error message and scenario (writes to DSE consistently caused Record Type's data sync to fail, even though the data changes do get persisted, and manually running a data sync has no problems). In my case, the underlying database table's PK was configured as INT UNSIGNED. When I updated it to be simply INT, the data sync errors on DSE writes went away.

    I have no idea why the use of UNSIGNED might cause this data sync error, or why Appian might complain about updating "the same entity multiple times in the same transaction", when that's not what was going on.

Children
No Data