topic Session lost for big app in QlikView

Session lost for big app

Mon, 05 Apr 2010 19:43:44 GMT

I have QVS 9.0.7440.8 on x64 with 98Gb RAM and 24x2.40GHz CPU.

My big app has about 954 millions of record in main "fact" table. It's 10Gb in file and 24Gb in memory. I can open it in QV Desktop (about 2 mins). When I try to open in AJAX client, it tells me "Session lost" in 60 sec exactly. I have security data reduction there.

On the server I have (EMC->System->Setup->QVS->Performance):

Possible session timeout: 1800 sec
Maximum Inactive Session Time: 1800 sec
Maximum total session time: 0 (means no limit)
Object Calculation Time limit: 240 sec

When I load 1/4 of data (about 256 millions of records) all works just fine.

Does anybody have any idea how to deal with it?

Session lost for big app

Mon, 05 Apr 2010 21:07:09 GMT

In QVWS log I found this:

4/5/2010 13:48:27.1837482 Information Create client: Mode=Authenticate, Host=<My server host name>, ClientIP=<My client IP address>, MachineId={<my machint ID>}
4/5/2010 13:49:27.3947482 Warning Execute error: The operation has timed out.
4/5/2010 13:49:27.3947482 Warning Session lost

Where on QVWS can I change the operation timeout?

Session lost for big app

Mon, 05 Apr 2010 21:17:11 GMT

I've found it.

You need to change the timeout parameter "QvsTimeout" in C:\ProgramData\QlikTech\QvWebServer\config.xml file

Session lost for big app

amien — Mon, 31 Jan 2011 18:39:12 GMT

Thanks .. this setting is not anywhere in QEMC?

i was under the assumption that all settings can be changed in QVS 10 QEMC?

Session lost for big app

Wed, 15 Jun 2011 17:49:54 GMT

My own answer helped me with QV 10 SR2 too