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

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.

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.

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.