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

Server crashes regularly

Hello guys,

I have a problem with our Qlik server and I really hope someone can give me some tips or hints.

Some Information to our Server and QlikView Apps:

Server: Memory 128 GB

QlikView: Version 12.10.20600.0 SR8

Number of apps: ~ 15 apps -> 3 of them between 3 and 6 GB (compression level: high)

Number Doc Cal: 265

Number of User Cal: 23

The problem is, the server crashes a lot. So hard that only a manual restart helps.

Our thought is, that the server is just too weak for all these big apps and the users on top. But is it normal, that the server crashes completely?

Sometimes a distribution of one app is enough to kill the server. Another time there is a job running and someone opens an app on the server and again the server crashes.

This happens regularly at the moment.

Our question is: Can this behavior occur? That the server always crashes completely? (Not only the services or the Server frozen for a short time)

or do we have to examine the server and/or the applications more closely?

Or is the server simply too weak for all these actions?

Thanks in advance!

6 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

What do you mean by "the server crashes a lot..." or "... the server always crashes completely..."? Does it lock up? Does it reboot (BSOD)? Do you have to press the reset button?

After a return to normal operation, start Task Manager->Performance in a server session, and watch what happens to memory/cpu load when "the server crashes". What do you see?

Miguel_Angel_Baeyens

Adding to Peter above, and in short, no, it's not normal that the server crashes or locks up but it can happen that the server is undersized and overloaded.

What it may be causing those locks or freezes are reloads which indeed, take more resources in QlikView 12 than they did in QlikView 11. This can be mitigated by reducing the number of concurrent tasks in the QMC, along with the measures in this post.

With regards to the possible undersizing of the current environment, that could also be the cause. What it is important here is not how big those apps are in disk but in memory, and what percentage each new user adds to that usage. Big apps with lots of distinct values can make every user add 1%, 2%, 3% or even more to the existing memory, if several of these applications are hosted in the same server, memory might need increase.

Compression level is irrelevant, it only affects to the use of the QVW in disk, not in memory. The difference between using high compression or none  regarding opening and saving times should be small (there is a little overhead while the app is compressed).

If the server is virtual, it might need some tweaking to make sure it does not share vCPUs or RAM with other VMs hosted in the same server.

Also, the applications themselves should be checked, in case there are complex expressions in the front end that can use flags or preaggregations in the script, use of numeric values, reducing the app size (and therefore memory footprint) by using loop and reduce, etc.

It could also be that there are a lot of apps and a lot of users and that hardware is simply not enough.

And finally, after checking all the above, it might be worth checking with Qlik Support for a newer release or in case this is a known issue with that version specifically.

EDIT: forgot to mention Qlik Consulting or a Partner who can check the environment, perform benchmarkings and assess whether a bigger hardware is required or which improvements can be made in the app/reload process.

Chip_Matejowsky
Support
Support

Ensure that you have the QlikView Server Event log configured for High Verbosity and split daily - QMC > System > Setup > QlikView Server > QVS@ > Logging tab. Then check this log for what errors/warnings are returned. Suggest you open a case with Qlik Support to assist in identifying contributing factors to these issues.

Principal Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!
mhc4qlik
Contributor II
Contributor II
Author

Thanks for the answer!

After the server has collapsed, it can only be restarted manually by pressing the button.

Yes, I observe the Task Manager almost continuously. If the server crashes, the memory load is very high. But not always at the limit, at least it doesn't show it then.

cwolf
Creator III
Creator III

I think you have too small main memory and your server swapped the memory. And when a QV server swapped, it "freezes" for a long time, maybe more then 10 minutes.

The limit of a QV server is determined by the parameter "Low Working Set" (QMC -> Server Setup -> Performance).

The default value of 70% means that your server should not use more than 90GB under normal conditions.

If the memory requirement of your QV server is often above the lower limit, then you have definitely too small main memory.

The additional 20% (up to "High Working Set") is mainly used by the server to reorganize the first 90GB of its main memory if it is necessary. This should happen on a server with enough memory only one or two times a week - but not every day.

What you can currently do to save memory especially during distributions:

Go to QMC -> Server Setup -> Documents and select "Allow Only One Copy of Document in Memory".

In each document got to Settings -> Document Properties -> Server. Select "Server performs refresh automatically without client action" as refresh mode and select "Enable push from Server".

Don't preload any document (except the 3 big ones).

Go to QMC -> Server Setup -> Performance and decrease the value for  "Possible Session Timeout", for example to 900s.

mhc4qlik
Contributor II
Contributor II
Author

Thank you, this helps us a lot!