ps:escript timeouts - help required, are you there Matt?

[neil]

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.

 

[Casper]

Maybe to increase speed you could also skip the ftp part and write something which links directly to your AIX server.

For instance change web-disp so extentsion like .pdf .rtf etc are filtered out and the corresponding files streamed back to the webserver....

But I don't know how that affects e-Script....

Another way of doing this is to start a normal progress batch job at the server so your agents is freed and can resume normal request handling (what the agent is made for). As soon as the batch process has finished, the link can be provided in the web application.

Regards,

Casper.

 

[escript]

Hi Neil,

How you doing? Sorry for not responding sooner, I keep forgetting to check ProgressTalk...

Are you still having problems?

Regards,

Matt - formerly PSC(UK) now Proaxima, but still eScripting