Skip to main content
October 26, 2021
Question

Record sync issue post write to DB smart service call

  • October 26, 2021
  • 4 replies
  • 1 view

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
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.

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
March 14, 2023

Yes. Thank you so much for responding