topic Re: Performance issues and errors when opening apps in Management & Governance

Performance issues and errors when opening apps

Suzanne_van_der_Tang — Thu, 11 Apr 2024 08:38:24 GMT

During the last 2 weeks, our Qliksense production environment encounters a serious performance issue.

Symptoms:

- In mornings it takes quite a while to open an app. On screen the message "initializing" is displayed for a long time, and then, after a while, it shows "App is opened" for a while.

- The HUB screen shows an error message after a couple of minutes, stating something like "Error has occurred, connection timed out because of inactivity".

- Once the app finally opened, it works as expected (not very slow).

- Our test environment (other server) works fine (no errors, less users, but same amount of data).

- After the qlik services have been restarted, the system works fine again.

- Next morning, the system is slow again, and needs to be restarted all over again.

- Nprinting and Qlik tasks are running without issues.

Anyone has a clue as to where we should look to investigate/solve this issue?

Re: Performance issues and errors when opening apps

mpc — Fri, 12 Apr 2024 11:42:34 GMT

Hi,

First of all, is there any change on the server ? (Windows or NET framework update, Qlik Sense, or other) ?
Then, to troubleshoot the performance issue, you'll need to monitor CPU/RAM/Disk usage, and Qlik Sense activity. You need to check network related issue too, if the apps are store on a network location.
You can also check in the Qlik Sense logs something happend when you open the app. Check the Windows Event viewer too.

Regards

Re: Performance issues and errors when opening apps

Hazel_K — Mon, 08 Jul 2024 13:09:41 GMT

Hi Suzanne,

This sounds very similar to the issue we're experiencing at the moment. Did you discover the cause?

Kind regards

Hazel

Re: Performance issues and errors when opening apps

Hazel_K — Thu, 11 Jul 2024 13:48:26 GMT

Just to add - we found the cause of the issue to be the anti virus program on the server, and updating it following this document solved the problem:

https://help.qlik.com/en-US/sense-admin/May2024/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Troubleshooting-anti-virus-software-scanning-affects-performance-of-Qlik%20Sense.htm

Thanks

Hazel

Re: Performance issues and errors when opening apps

Suzanne_van_der_Tang — Fri, 12 Jul 2024 07:22:13 GMT

Unfortunately, this hasn't solved the issue on our system. 3 months already now, every day a restart...

Any other suggestions?

Re: Performance issues and errors when opening apps

Suzanne_van_der_Tang — Fri, 12 Jul 2024 07:23:47 GMT

Hi,

Thanks for your response! We've checked quite some things already, also our external Qlik advisor has been involved in finding the issue. We've raised a call at Qlik now, hopefully we'll get the answer quickly now, as this is getting quite annoying...

Re: Performance issues and errors when opening apps

Hazel_K — Fri, 12 Jul 2024 08:07:11 GMT

Hi Suzanne,

That does sound annoying. I just followed the video in this document, I've installed some of the extra monitoring apps to check, but to be honest the anti virus issue didn't show up anything in the logs/apps, it was more a case of trying it and hoping it would make a difference.

https://community.qlik.com/t5/Official-Support-Articles/How-to-start-investigating-Qlik-Sense-Performance-and-address/ta-p/1760292

Good luck.

Thanks

Hazel

Re: Performance issues and errors when opening apps

lvdbrink — Fri, 12 Jul 2024 11:18:35 GMT

The symptom of apps opening slower in the morning when they are first opened is natural behaviour for Qlik. When a user opens an app for the first time in a while, the data model of the app is loaded into the cache (your RAM memory). The larger the app is, the more time it takes to do so. When the app is opened the second time by a user shortly after, the app is still in the cache and thus loads faster.

A way to mitigate this is by enabling app preload for larger apps. You can learn how to do this here. More info on determining what apps to apply this to you can find here.

In general, it might be worth to investigate the RAM usage of your server. It might be that your server has too little of it, causing issues when more and more apps are loaded into the cache during the day.

Re: Performance issues and errors when opening apps

Suzanne_van_der_Tang — Fri, 12 Jul 2024 11:31:47 GMT

Hi,
Thanks for your response! Unfortunately, it's not "the usual first startup". For 2 minutes, an app says "initializing", and after that it start. If I open the same app again, the same thing happens. After the services have been restarted, the issue is solved. Until midnight, then it's back again...

Re: Performance issues and errors when opening apps

lvdbrink — Fri, 12 Jul 2024 12:47:36 GMT

Might still be related to RAM issues. I would start by investigating the engine and event logs and see if there is any warnings around the time you try to open these apps. See this support article for tips on how to start investigating this.

Additionally, you mentioned NPrinting tasks. Is the NPrinting server installed on a separate server or is it on the same server as Qlik Sense? If they are on the same server, there might be some conflicts occurring between the 2 (best practice is to have them on separate servers).

Re: Performance issues and errors when opening apps

Hazel_K — Mon, 21 Oct 2024 10:04:12 GMT

Hi Suzanne,

I think we're now experiencing the same issue as you - every few days it takes ages for all of the apps to open (regardless of size) and only a server restart resolves the issue.

The server RAM seems fine, it never reaches 100%.

Did you get anywhere with resolving your issue?

Thanks

Hazel

Re: Performance issues and errors when opening apps

Suzanne_van_der_Tang — Tue, 22 Oct 2024 05:44:49 GMT

Hi Hazel,

We've not resolved this issue yet. Has been like this for over half a year now. We've raised an issue at Qlik, they've requested all kinds of things now. Our partner is taking care of that. When we've found the solution, will let you know! Or maybe you can also raise an issue at Qlik? When multiple persons raise the same thing, maybe the prio can go up?

Grt,
Suzanne

Re: Performance issues and errors when opening apps

rafaelbessa79 — Tue, 17 Dec 2024 12:44:21 GMT

Não sei você, mas a lentidão começou a partir da atualização da maio 2022 para maio 2024 patch 1.

estou tendo reclamações praticamente todos os dias. Para ter ideia, minhas máquinas de engine tem 4TB de RAM (isso mesmo!), CPU 32 cores. Máquina dedicada apenas para o QLIK.

Ao tentar abrir um determinado app, olhamos para o servidor que não tem consumo de 20% de ram.

Scan de antivírus roda às 6h da manhã e leva 10min. Não queria acreditar, mas estou começando a desconfiar que essa versão está esquisita.

Re: Performance issues and errors when opening apps

David_Friend — Tue, 17 Dec 2024 15:27:28 GMT

Have you used the various monitoring apps to help?

Re: Performance issues and errors when opening apps

rafaelbessa79 — Tue, 17 Dec 2024 17:00:32 GMT

Yes