Currently, I'm experiencing a "500 Internal Server Error" while downloading a CSV file. The error page is displayed by Apache Tomcat.
The target data is a 45MB CSV file, which I confirmed by generating the file using SQL*Plus. I'm attempting to download the CSV file from the APEX interface using Interactive Reports' "Actions - Download" option.
The error occurs approximately 15 minutes after initiating the download.
In my investigation, I couldn't find the "Timeout" parameter in the etc/httpd/conf/httpd.conf file. Additionally, in the environment I'm working with, multiple Apache Tomcat instances are installed, and the above config file showed signs of being modified by someone else. It might take some time to confirm if I can add the timeout configuration without interfering with others.
Ideally, I would prefer to modify only the configuration related to the APEX instance I am running, to avoid affecting others.
Where can I find the configuration file specific to the APEX instance to make the necessary timeout modification? Please let me know if any additional information is needed.
Thank you in advance.
In conclusion, the default value for the timeout until the completion of SQL queries in Oracle REST Data Services was 15 minutes. In my environment, I had not set the value (jdbc.statementTimeout), which caused the timeout issue. This value can be specified in default.xml, and I resolved the problem by executing the following command: java -jar ords.war set-property jdbc.statementTimeout 1800 I would like to express my gratitude to user207421 for helping me resolve the issue.