Error Message:
504 Gateway Time-out error when performing a file load an update via Metadata Scans and Data Dictionary Uploads.
Symptoms:
The error appears when user tries to upload an Excel file through metadata scan/ Data Dictionary upload functionality when the instance is running on AWS application Elastic Load Balancer (ELB)
Resolution:
- This issue is arising due to the face that the default connection idle timeout for an AWS ELB is 60 seconds.
-
This pinpoints the problem to the AWS ELB idle timeout setting as the default value of 60 seconds is too short. Suggestion is to set the ELB connection idle timeout to at least 5 min / 300 sec
-
When using a Load Balancer it is important to ensure the connectionTimeout and keepAliveTimeout settings allow a longer timeout than what the load balancer's idle timeout is set to
Steps:
- In the server.xml file -->>(ApacheSoftwareFoundation\Tomcat8.5\conf), Connector's connectionTimeout value to "-1" (infinite). Attached snapshot for reference.
- By default, Elastic load Balancing sets the idle timeout value for your load balancer to 60 seconds. Use the following procedure to set a different idle timeout value
To update the idle timeout value using the console
- Open the Amazon EC2 console at https://console.aws.amazon.com/ec2/.
- On the navigation pane, under LOAD BALANCING, choose Load Balancers.
- Select the load balancer.
- On the Description tab, choose Edit attributes.
- On the Edit load balancer attributes page, enter a value for Idle timeout, in seconds. The valid range is 1-4000
- Choose Save.
To update the idle timeout value using the AWS CLI
Use the modify-load-balancer-attributes command with the idle_timeout.timeout_seconds attribute.
If there are any issues or questions feel free to open a ticket with support: https://support.erwin.com/hc/en-us/requests/new