Troubleshooting
Problem
The following error message is displayed when exporting a query to CSV. This error happens approximately five minutes after starting the export: Server Error This server has encountered an internal error which prevents it from fulfilling your request. The most likely cause is a misconfiguration. Please ask the administrator to look for messages in the server's error log. or HTTP 500 - Internal server error Internet Explorer
Resolving The Problem
This usually occurs when there is a long running query on the database side or doing an export to CSV with a huge query. There is a setting in the iPlanet webserver that specifies how long a CGI process will remain active with no processing being done to to it. By default this is set to five minutes.
If the database is processing the SQL and the CGI process is idle, the webserver will kill the
process after five minutes of inactivity while it is waiting for the request to be returned from the database.
Perform the following procedure to increase the amount of time the web server will wait before killing an idle CGI process:
1. On the Solaris machine, browse to the web server directory and open the web server instance that is being used (starts with an https-).
2. In the config directory there is a file called magnus.conf. Make a copy of this file and open the original file in an editor.
3. Add this line to the bottom of the file:
Init fn=init-cgi timeout=1800
[the number is in seconds so 1800 would equal 30 minutes]
4. Stop and restart the web server.
This entry increases the time which the CQCGI process can remain idle while processing is done on the database.
Historical Number
114506
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21337301