Hi Team,
Sometimes, the data was not available on UI and it is available on DB.
What could be the scenarios, would this be a performance issue?
Discussion posts and replies are publicly visible
Definitely looks like a data sync issue.
Likely, you have something writing directly to the database that doesn't subsequently sync.
Are you using the Stored Procedure or Query Database Smart Service by any chance?
https://docs.appian.com/suite/help/23.4/Query_Database_Smart_Service.html
No, we are using Write to data store entity smart service.
But, if this is a sync issue how the already available data could be disappeared?
Because only data persisted with the 3 smart services above are synced back to the Record.
Any other changes to the DB (either via a SQL Script on the backend or the 2 Smart Services I listed above) won't be synched at the time the data is changed, they will be picked up in the next scheduled sync.
We are using Write to data store entity smart service to update/insert the data, still is there a chance of data sync?
If you are using the Write to Data Store there shouldn't be an issue.
But if the data is not being synced, that would indicate there is some other process (either in Appian or outside Appian) that is writing data that doesn't support data sync.
Another doubt, if we use "Delete from data store entity", then how it the possibility of record sync
It Syncs Automatically
Quick suggestion. If you are writing the data using write to DSE and getting data from records, why not to use write records and delete records directly?