Question

Syncing of records is not occurring when inserting or updating data in the database using the "Write to Datastore" smart service.

Forum|Forum|1 year ago
February 25, 2025
10 replies
0 views

Hi,

I need help understanding why record sync is not occurring when using the "Write to Datastore" smart service in one environment, while the latest data appears in the records in another environment.

In the environment where sync is not happening, a manual sync is required to view the latest data.

Can someone help me understand the cause of this issue?

stefanhelzle0001

Did you follow the data sync troubleshooting guide?

https://docs.appian.com/suite/help/24.4/Records_Monitoring_Details.html#

M

madhuria635Author

Hi stefan,

There is no record sync failure i have checked in sync history.And record is available.

in interface we are querying data using records hence we encountered this issue.but to view/query latest data from record we need a manual sync.

In order to overcome this issue we have moved write to datastore from write to records which works as expected.

but i need to understand why the same has been not work when write to datastore smart service is used.

davidj137213

IN case you are using synced records, your processes must be prepared to this issue.... because if sync fails, you will be using an old version of the data.

andrewh6762

A few questions:

Can you give more info on the setup you've got? For example, is it an interface that triggers a process model and then returns and loads a record summary?
I'm assuming that data actually makes it into the DB (as a manual sync works) but can you confirm?
Is there any manipulation of the data done after the write (ie. DB triggers, stored procs, other Appian processes?)
Are there any sync source filters involved?
Does it actually require a manual sync or does refreshing the data work without a manual sync?
Is there any record level security on the record in question?

I understand that you are only experiencing this in one environment and it does work with CDT/Datastores. I can also see you've probably answered some of the above questions but I'm being extra clear so we can help.

M

madhuria635Author

Hi Andrew,

The table is been inserting/updating in process model (which changed now insert/update to write to records).
Yes, the data writes into db by write to datastore smart service , but not avaiable in record until a manual sync.
No manipulation
No sync source filters.
Tried a manual refresh on the page does not work , and the did a manual sync and can see the data.

andrewh6762

All the obvious things seem to be covered. The only other thing I can think of is if there are two records involved with the same source and the write is happening with one record but the read is with another. From what you've described though, this doesn't appear to be the case. And again, it works in another environment. Good luck! The case with Appian I'm sure will resolve things.

mathieud0001

If its only occurring in one environment, I would first look at the data source connection or connected system and look for differences with other environments.

If there is nothing apparent, I would suspect something maybe in the Appian instance itself in which case I would advise logging a case with Appian Support to investigate further.

M

madhuria635Author

Hi Mathieu,

Thanks for the suggestion , i have compared the environments but there are no differences.

Let me check with appain support.

karumurua531442

hi [mention:aa5aca9e4b314d30a92f266363c7155e:e9ed411860ed4f2ba0265705b8793d05] is it okay to share your record configurations/process conf fig. if data is not sensitive? and also did you check all your fields in your record mapped correctly

M

madhuria635Author

Hi Abhishek,

Yes i have checked all fields in records are mapped correctly.

Sign up

Login with SSO

Login to the community

Login with SSO