Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
waszcma1
Partner - Creator II
Partner - Creator II

No connection via AP but via QV desktop works fine

HI,

I couldn't find exactly the same behavior what I have now.

Server is up and running.

I can open Access point via IE or Chrome but that is all. I can't open any application via access point and have message "No connection"

What is more interesting when I use QV desktop version I can open any application from the same server without any problem?

 

Could you confirm my suspicions: it is happening due to high pick of usage and server RAM capacity is not enough? 

my current server version is 12.3  and it seems that this problem starts after server was upgraded from 12.2 to 12.3 version 

1 Solution

Accepted Solutions
Sonja_Bauernfeind
Digital Support
Digital Support

High RAM usage can be a common cause of this, leading to "Lost Connection" messages when trying to open a document, since the document itself either takes too long to load into memory (since the QlikView server will still try to do so, clearing out cached data, and Windows will begin swapping memory to disk), or because the QlikView server is simply too busy to handle any more requests.

Monitoring memory usage and seeing a pattern in high memory allocation when you experience the problem should be fairly simple to do by setting up Windows performance monitoring.

You could also check to see if you can find the QlikView Server Event log logging Working Set Limit alerts.  You'd look for something like this (kb 000048671).

Though in a situation like this I would also expect the Desktop Client (open in server..) to be reasonably slow, so maybe we are looking at connection problems between the WebServer and the QlikView server. Since, if you use the Desktop, you bypass that.

Here's (kb 000042484) a common adjustment that can be made in case we are looking at a timeout. It's basically a way to adjust how long the webserver component (and in extension AJAX, our full browser client) waits for the QVS to respond.

Another possibility could be a corrupted TicketData.pgo file (kb 000003857). 

 

Don't forget to Like posts and use the "Accept as Solution" button on content that answered your question! Thanks 🙂

View solution in original post

5 Replies
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

You might be guessing correctly. This behavior might be due to RAM and CPU consumption.

In your case I would restart the QV services and after that just check how Access point reacted to this action.

waszcma1
Partner - Creator II
Partner - Creator II
Author

I will add that there are many application (QVW) with size like 1-2 GB itself 

I have to check how many users/sessions happens due to "no connection" error. 

 

2 GB qvw how much can consumed from Server if we talking about 10-50 users?

Sonja_Bauernfeind
Digital Support
Digital Support

High RAM usage can be a common cause of this, leading to "Lost Connection" messages when trying to open a document, since the document itself either takes too long to load into memory (since the QlikView server will still try to do so, clearing out cached data, and Windows will begin swapping memory to disk), or because the QlikView server is simply too busy to handle any more requests.

Monitoring memory usage and seeing a pattern in high memory allocation when you experience the problem should be fairly simple to do by setting up Windows performance monitoring.

You could also check to see if you can find the QlikView Server Event log logging Working Set Limit alerts.  You'd look for something like this (kb 000048671).

Though in a situation like this I would also expect the Desktop Client (open in server..) to be reasonably slow, so maybe we are looking at connection problems between the WebServer and the QlikView server. Since, if you use the Desktop, you bypass that.

Here's (kb 000042484) a common adjustment that can be made in case we are looking at a timeout. It's basically a way to adjust how long the webserver component (and in extension AJAX, our full browser client) waits for the QVS to respond.

Another possibility could be a corrupted TicketData.pgo file (kb 000003857). 

 

Don't forget to Like posts and use the "Accept as Solution" button on content that answered your question! Thanks 🙂
waszcma1
Partner - Creator II
Partner - Creator II
Author

Extremely helpful !!!

Haven't solved yet the problem but working on that now.

Will let you know about the result.

 

Big thanks to all of you!!!

waszcma1
Partner - Creator II
Partner - Creator II
Author

It didn't take long to confirm the issue.

 

The end of year is close so there is high peak of usage on the application (report contains finance data) which size is really have 2 GB,  the server capacity is too low to handle that.  

It looks that this is not setting problem but resources,

Application has quite simple data model (one fact table ~40 mln records) and some smaller tables connected (star scheme)

 

the only work around is that I have reset QVS in the morning and keep monitoring usage if no connections happen again another restart is needed.

 

11-12-18 8:16

Warning

WorkingSet: Virtual Memory is growing CRITICALLY beyond parameters - 117.928(89.598) GB

11-12-18 8:22

Warning

WorkingSet: Virtual Memory is growing CRITICALLY beyond parameters - 121.323(89.598) GB