Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Session lost for big app

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?

1 Solution

Accepted Solutions
Not applicable
Author

I've found it.

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

View solution in original post

4 Replies
Not applicable
Author

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?

Not applicable
Author

I've found it.

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

amien
Specialist
Specialist

Thanks .. this setting is not anywhere in QEMC?

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

Not applicable
Author

My own answer helped me with QV 10 SR2 too