Skip to main content
New Participant
Apr 8, 2025 1:13 AM UTC
Question

Can't see records in Data Preview | Synced Record Type | Preview currently unavailable due to an error on the source

Hi, 

I'm trying to find the root cause to why I can't see any records in the "Data Preview" screen of a Synced Record Type.

The application works normally and I'm able to push a full sync without any issues. Other records stored in the same database are available in "Data Preview".

Context: The data is stored in company hosted SQL Server.

Error message: Preview currently unavailable due to an error on the source

 

Any recommendation to logiles, or actions I can take to understand why the data isn't displaying is appricated. 

Thanks for your help

 

4 replies

jayaprakashr0001
Participating Frequently
Apr 8, 2025 5:24 AM UTC

Hi [mention:ec08a80d39a94ed081204c57182d091f:e9ed411860ed4f2ba0265705b8793d05] , 

Please check the security of the record and the database table if you have. Check the logs it will give the exact issue why you can't see  the data.

Similar issue

New Participant
Apr 8, 2025 10:40 PM UTC

Hi [mention:44bed26f1d96482687e4003414c7d8ec:e9ed411860ed4f2ba0265705b8793d05] , 
Thanks for your reply! Which log files would tell me about error in the Data Preview?

Been trying to use the Appian logfile documentation to identify the correct one. 

mathieud0001
Genius
Apr 8, 2025 11:41 PM UTC

This might help: docs.appian.com/.../Records_Monitoring_Details.html

I'd start by making sure that the Connected System for the Data Source is functional.

Can you show the Data Model tab?

New Participant
Apr 14, 2025 5:52 AM UTC

Hi [mention:f5e81b8502fa4e77ad12697686a4fc56:e9ed411860ed4f2ba0265705b8793d05] , thanks for your reply!

The database is connected using the old "Data Source" option in Admin Console. Several other Record Types are connected to the same DB and the "Data Preview" is working. 

This is the Data Model Tab:

All full syncs pass with a green symbol.