Sheets don't load, restarting Qlik services helps

[ramzi-manoubi]

Hi,

Sometimes, with one of our customers, some sheets get stuck and don't load.

They get a turning circle:

When we look into the Taks Manager:

After restarting the Qlik, the sheets work again. Task Manager:

Any advice to tackle this problem is very welcome.

How do I approach this problem best?

They have 2 apps that are around 280MB and 2 that are around 15MB.

They use most of the time the small ones. And the problems were also reported for a small app.

There were not more than 3 concurrent users.

Thank you in advance,

Ramzi

[ramzi-manoubi]

When it occurs again, are there log files I can check? Where should I start?

[balabhaskarqlik · Accepted solution]

May be check below areas:

Qlik Sense reserves RAM for itself and it doesn't have to be a problem unless you need to run another application in the same server, which needs lots of RAM (which I think is not recommended).

Memory will be consumed by:

1. The data model itself,

2. Session (selection state) storage for each user.

3. Cached results as charts are recalculated when a user make selections. Each new filter will generate a new cache entry. This is the primary cause of memory growth as the day goes on. QS should manage the cache to not cause a fatal problem in the server.

4. Temporary (transient) memory required to calculate a given chart (see below).

Users developing visualizations can consume a lot of memory by creating wacky (that's a tech term) charts. Again, QS should manage this so it does not cause a failure in the server.

You looking at memory after closing your apps? if yes then no worries .The Qlik sense engine will not release the memory after closing of your app..If you try to open another app that memory automatically allocates to that app..Some time the Sync b/w Central and nodes will happen that time also memory is to high ...

[ramzi-manoubi]

Thank you Bala Bhaskar,

Your answer is very interesting and helpful.

So, the high memory usage before restarting the services, doesn't have to be necessarily a problem.Tough the CPU percentage is at 0% and the sheet didn't load. Is it possible to see at what instruction it was stuck?