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.