Data on UI

Question

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?

Harshit Bumb (Appyzie) · Accepted Answer

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

Harshit Bumb (Appyzie) · Answer

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.

Harshit Bumb (Appyzie) · Answer

An overnight sync happens somewhere between 1 and 2 AM. Assuming you are using records.

Mathieu Drouin · Answer

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

Data on UI

Top Replies