英文:
Getting a 500 Internal Server Error during CSV download in Oracle APEX and need to extend the timeout (Oracle APEX 21.1.0)
问题
I am currently 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.
英文:
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.
答案1
得分: 0
在总结中，Oracle REST数据服务中SQL查询完成的超时默认值为15分钟。在我的环境中，我没有设置该值（jdbc.statementTimeout），这导致了超时问题。可以在default.xml中指定该值，我通过执行以下命令解决了该问题：
java -jar ords.war set-property jdbc.statementTimeout 1800
我想向用户user207421表示我的感激之情，他帮助我解决了这个问题。
英文:
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.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论