The Requested Record Type Is Not Available Expression evaluation error [evaluation ID = 9f493:5743c] at function a!recordList: An error occurred because the record type’s source is currently unavailable, or the query reached a timeout or memory limit. (APN

Hi makkenasai ,

The data source linked to the record type might:
1. Be deleted or renamed
2. Have connectivity issues
3. Have permission restrictions
Please Check the data source and ensure the connected table and the data store entity is published.Check if the data store is still valid (no red error messages) Test the database connection.

Thanks for the quick response Harshmodi ,

We have verified the data, that we are fetching around 7 lakhs of records that might be causing the timeout error. Is there any way we can fetch the data without timeout error

what is the record source?

If your data source is view, how much time is it taking in DB? Try optimizing the Sql : 
1. Only select columns that are required in the view
2. Use appropriate joins
3. Ensure indexes exist on the columns used in JOIN, WHERE, and ORDER BY clauses—particularly when working with large tables. This significantly improves query performance.

7 Lakhs isn't a big number but we need consider the columns ?? Can we know the number of columns in that record and  size of the data that you are trying to retrieve. Check tomcat logs and performance logs to understand better about the issue that caused it . 

How much time does it take to retrieve the data via a regular query?