Connection Failure Error

Harry_959

Hello,

I'm using long running query which produce more than 60 pages of PDF report.

Exactly after two minutes of working the pop-up appears with the connection failure error. The clients browser freezes and you need to relogin again.

Is it the way how to extend this time period, to let say 5 minutes?

Thanks

nlarson

2 minutes is a browser timeout, not the server. I would bet the querry is not the issue, rather t's creating that big .pdf which is causing the delay. I do not know if there is a keep alive on the .pfd creation widget; but my guess is no.

This is likely more work than you want but: perhaps you could set up an an asynchronous process for this report. It would eliminate this issues and also be nicer for users too since they don't have to sit around waiting.

rocketman

Every year we run a mail merge to all our members which takes 15 minutes to produce and have not run into this issue, So I'm wondering what the internal difference is between a PDF report and a word document.

..... Just curious - I have no answer

nlarson

I can think of a few possible scenarios on why, but would need to better understand your Mailmerge workflow to hazard a guess.

ACDC

You could be running out of memory on the server or maybe your databse settings need to be looked at e.g. on Mysql increase "max_allowed_packet"