Troubleshooting the "503 Gateway Timeout" Issue While Exporting large CSV file from Bold BI

In Docker environment, when exporting large data from Bold BI Dashboards, users may encounter a “503 Gateway Timeout” error. This error typically occurs when the Export API takes longer than the configured proxy read timeout. For instance, if the proxy_read_timeout is set to 120 seconds in Nginx, and the export data API takes more than 120 seconds to respond, then the timeout issue will arise.

Steps to increase the Nginx timeout in Docker

To resolve this issue and ensure a smooth data export process, follow the steps outlined below:

1. Log in to your Docker container.
2. Use the command docker ps to get the Bold BI container name or ID.
3. Execute the command: docker exec -it <container_name_or_ID> bash.
4. Navigate to the Nginx configuration directory by running: cd /etc/nginx/sites-available.
5. Open the Nginx configuration file with the command: nano boldbi-nginx-config.
6. Modify the proxy_read_timeout value to 300 seconds.

7. Save the changes and restart the Docker container.

By following these steps, you should be able to resolve the “503 Gateway Timeout” issue while exporting large data to a CSV file in Bold BI.

Additional References

• Bold BI Docker Installation
• Nginx Configuration Guide
• Docker Documentation