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

Did you follow the data sync troubleshooting guide?

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

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.

A few questions:

1. 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?
2. I'm assuming that data actually makes it into the DB (as a manual sync works) but can you confirm?
3. Is there any manipulation of the data done after the write (ie. DB triggers, stored procs, other Appian processes?)
4. Are there any sync source filters involved?
5. Does it actually require a manual sync or does refreshing the data work without a manual sync?
6. 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.

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.

hi Madhuri Atmakuri  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

Hi Mathieu,

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

Let me check with appain support.

Hi Abhishek,

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

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. 

Hi Andrew,

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

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.