Skip to main content
February 16, 2021
Question

export to excel in record

  • February 16, 2021
  • 8 replies
  • 0 views

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

8 replies

danny.verb
February 16, 2021

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.

February 17, 2021

It’s a table and the table has 135 columns