Error: Export Report to Excel – Server Timeout After 3 Minutes

[ai.adma]

When attempting to export the Clients Report to Excel from the system, the request fails after approximately 3 minutes, and the server returns a 504 Gateway Timeout error.
Actual Result:

• The request to the endpoint /api/v1/Report/action/exportList keeps processing for around 3 minutes.
• The server responds with 504 Gateway Timeout.

Impact:

• Users cannot export the report (3,397 records).
• Affects reporting and business operations.

Technical Details (from browser console):

• HTTP Status: 504 Gateway Timeout
• Request Method: POST
• Server: awselb/2.0
• Duration: ~180 seconds
• Content-Type: text/html

Suspected Causes:

• Export operation taking too long due to large dataset size.
• Backend process not optimized (heavy queries, or slow Excel generation).

[yuri]

Big lists should be exported in Lite mode as the docs suggests:

https://docs.espocrm.com/user-guide/export/#lite-mode

[ai.adma]

Thank you for the update yuri

I’m try using Lite mode as shown in the attached file, but the export still times out with a 504 error

[ai.adma]

Thank you for the update yuri

I’m try using Lite mode as shown in the attached file, but the export still times out with a 504 error.

[lazovic]

Hi ai.adma,

Your provider may be blocking such requests. I tested exporting 11,000 records in Lite mode with about 20 columns in the report, and everything exported in literally a minute, if not less.