Qlik Community

Ask a Question

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

QlikView Server excessive RAM Usage Abril 2019 SR3

I have a model in which there are users who created their own objects, when a user opens the model via QVP the entire server is hanging due to excessive consumption of RAM.

This did not happen in QV Server November 2017 but it does happen in QV Server April 2019 SR3.

Needed:

- How can I determine which object is generating the problem considering that there are many user objects?
- Can you limit QV Server so that if a model is consuming a lot of RAM only that model is offline? Any idea to make the entire server not crash is welcome.
- Is there a way to observe the RAM consumption by model?

1 Reply
Digital Support
Digital Support

The easy test is to remove the .shared/.tshared file for the application in a test environment and see if you can still see the issue, that will prove your theory.  The next thing I would recommend is running the cleaning tool on the shared/tshared file:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Server/Content/QV_Server/QlikView-Server/Q...

If any objects are identified as bad, you will need to stop the QVS service and replace the file and restart things in order for things to be swapped correctly, you cannot hot-swap things in this case as if the app is in memory, then the shared contents are as well, so what is in memory will be written back to the cleaned file when you hot-swap it and you are right back where you started.  

As far as trying to find the object, the best bet would be to turn on QVS Audit Logging, so you can see who was doing what right before the issue occurs:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/QMC/Content/QV_QMC/QMC_System_Setup_QlikVi...

May be easier to load things up into the Governance Dashboard as well to try to help identify things too:

https://help.qlik.com/en-US/governance-dashboard/Content/QV_GovDashboard/What.htm

About the best I can offer.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.