Hi,
we have a record of type entity backed .when we export 5000 records to excel, it displays error in the downloaded excel as "Query has failed: An error occurred while retrieving the data".
Please suggest
Thanks in advance
Discussion posts and replies are publicly visible
Here is our documentation regarding query timeouts for export to excel https://docs.appian.com/suite/help/20.4/Optimizing_Record_Lists_for_Export_to_Excel.html#avoiding-query-timeouts-when-exporting-data
Do you know how many columns your backing table has? Is it a table or a view? If it's a view, the statement could potentially be very slow.
It’s a table and the table has 135 columns