Skip to main content
Participating Frequently
October 26, 2021
Question

Record sync issue post write to DB smart service call

  • October 26, 2021
  • 4 replies
  • 6 views

Title: Record sync issue post write to DB smart service call

Body: I have used Write to datastore entity smart service for updating a record in database table, this works fine via a record action but when I'm using a related action, I am getting sync issue in recordType after related action process flow completes and returns back to the record summary dashboard.

Below are the logs I could find for the issue:

1. Loading updates to synced record type(s) in ADS failed, invalidated record type(s)

2. 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-4205-039)

Can you please let me know why is this issue happening and how to fix it.

4 replies

vaishals
Inspiring
March 13, 2023

Hi [mention:1358ba57f86b464895b3a54c84157fc5:e9ed411860ed4f2ba0265705b8793d05]. Were you able to resolve this issue? If so, Could you please share how you resolved it. Thanks in advance.

Participating Frequently
March 14, 2023

Hi Vaishal

I have resolved this issue.

In Data Base Table we need to take integer (Data Type) for primary key autoincrement column.
please find below screenshot.


Need to take integer datatype in table(Primary Key column) and update the foreign keys (if any) as well.


Hope you have got understood.
Thank You

vaishals
Inspiring
March 14, 2023

Yes. Thank you so much for responding