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
And tell me if you have any API that writes data in the table. Any source from which the data is getting written to the DB other than "Write Records"?
Nothing
Harshit Bumb (Appyzie) said:You don't have access to the DataStore You don't have access to the recordType You are not in the record level security configuration You have some default filters working The record type is not synced The connection to DB is broken The mapping between your CDT and table in the DB in invalid
Can't think of anything other than these. If it happened only once, there could be one of these problems. You can try to check for the logs of that day if they are still available. And if this happens regularly, then I think the right time to debug is when the data isn't coming up. That time, you can test objects individually to see what is causing this issue.
Sure, Thanks
Can you please mention more details about the logs. What kind of logs are available?
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
You can look for sync history in the record type to see if it failed someday.
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.