Hi All,
I'm hoping that Mr Matt V, previously of PSC(UK) can answer this:-
I'm having a problem with a cgi timeout when running a complex query. Basically my .p runs a procedure in my service which populates a temp-table, dumps the temp-table contents to a file in a directory on the database server filesystem (AIX), ftps the file to our webserver (NT) and then adds the file as a hyperlink on the resultant html page which allows the user to download the file to their PC. It works really well except when the query that generates the temp-table takes too long and this happens - 'The specified CGI application exceeded the allowed time for processing. The server has deleted the process.'
Our development environment is set up like this:
Win 2000 server (IIS) and the Webspeed messenger
AIX Webspeed broker / agents & progress database (9.1E)
Is there any way I can overcome this and increase the timeout? Can I set the webobject that runs the query as state-aware? Do I even want to do that?
Hope you or anybody else can help and hope your racing frog is still alive!
Regards,
Neil.
I'm hoping that Mr Matt V, previously of PSC(UK) can answer this:-
I'm having a problem with a cgi timeout when running a complex query. Basically my .p runs a procedure in my service which populates a temp-table, dumps the temp-table contents to a file in a directory on the database server filesystem (AIX), ftps the file to our webserver (NT) and then adds the file as a hyperlink on the resultant html page which allows the user to download the file to their PC. It works really well except when the query that generates the temp-table takes too long and this happens - 'The specified CGI application exceeded the allowed time for processing. The server has deleted the process.'
Our development environment is set up like this:
Win 2000 server (IIS) and the Webspeed messenger
AIX Webspeed broker / agents & progress database (9.1E)
Is there any way I can overcome this and increase the timeout? Can I set the webobject that runs the query as state-aware? Do I even want to do that?
Hope you or anybody else can help and hope your racing frog is still alive!
Regards,
Neil.