HTTP://BLOG.ITPUB.NET/26687597/VIEWSPACE-1207571/based on Oracle EBS R12, a webservice is developed to return a master data, When the amount of data requested is very large (more than 6000 rows of data), the Oracle Application server always returns a $ Internal server Error. When the requested data volume is small, the webservice runs without problems and can return the request data normally. Client received an error: <! DOCTYPE HTML PUBLIC "-//ietf//dtd HTML 2.0//en" >
<HTML><HEAD>
<title>500 Internal Server error</title>
</HEAD><BODY>
The server encountered an internal error or
Misconfiguration and was unable to complete
Your request.<p>
Please contact the server administrator,
[email protected]and inform them of the time the error occurred,
And anything you might has done
caused the error.<p>
More information on this error could be available
In the server error log.<p>
</BODY></HTML>
WorkaroundThis problem is due to the large amount of data, Application server processing time-out, try to increase the Apache timeout, you can solve the problem. NOTE: The Apache configuration parameters for Oracle EBS are httpd.conf under $inst_top/ora/10.1.3/apache/apache/conf (not the usual meaning of the Apache configuration directory: $ORACLE _home/ apache/apache/conf/httpd.conf) Modify the Apache configuration file httpd.conf, properly increase the timeout parameter (timeout default is 300 seconds) # # timeout:the number of seconds Before receives and sends time out.
#
TimeoutAfter modifying the parameters, you need to restart the Oracle EBS HTTP Server or the OC4J service to take effect. Restart OPMN
$ADMIN _scripts_home/adopmnctl.sh StopAll
$ADMIN _scripts_home/adopmnctl.sh startallorrestart oc4j service$admin_scripts_home/adoacorectl.sh stop$ADMIN_ scripts_home/adoacorectl.sh start In addition, the timeout parameter needs to be modified to how much, need some testing to find the boundary, timeout configuration is security and do not modify too high, to prevent DOS Attachs.the TimeOut directive should is lowered on sites that is subject to DoS attacks. Setting this to as low as a few seconds is appropriate. As TimeOut is currently used for several different operations, setting it to a low value introduces problems with long run Ning CGI scripts. (Refer:link)
ReferenceInternal Server Error causes performance issues (document ID 1389111.1) avoiding Worksheet Timeout in Oracle Demand planning (Document ID 779590.1) Timeout errors-how to Extend timeout for Long Updates in APC/PIM/PLM Pages? (Document ID 1165573.1) Increase Timeout Setting for apachehttp://docs.oracle.com/cd/e18727_01/doc.121/e12893/t174296t174298.htmhttp:// docs.oracle.com/cd/e10415_01/doc/bi.1013/e10404/bi_pub_rns.htmhttps://forums.oracle.com/message/10186007
EBS Webservice timeout,http Server Return "Internal server Error"