topic Re: Unresponsive Behavior in App When Accessing Specific Sheet in App Development

Unresponsive Behavior in App When Accessing Specific Sheet

yh2023 — Fri, 12 Jan 2024 13:04:30 GMT

I need assistance with an issue I am experiencing in the Qlik app.

I can successfully open an app; however, when I attempt to access a particular sheet, the application becomes unresponsive. I am unable to scroll or edit the sheet after few seconds, and it appears to be stuck.

Then I get the following screen:

I would appreciate your prompt attention to this matter and any guidance or solutions you can provide to resolve the issue.

Thank you for your assistance.

Re: Unresponsive Behavior in App When Accessing Specific Sheet

Anil_Babu_Samineni — Fri, 12 Jan 2024 13:51:29 GMT

@yh2023 Please try to close the session and retry. It says that you don't have enough memory and CPU capable to access the portal.

Re: Unresponsive Behavior in App When Accessing Specific Sheet

yh2023 — Tue, 16 Jan 2024 06:05:30 GMT

@Anil_Babu_Samineni thank you so much for the response. I closed the session, cleared the history, and cleaned the cache memory, but despite these actions, I am still encountering the same issue.

Re: Unresponsive Behavior in App When Accessing Specific Sheet

Anil_Babu_Samineni — Tue, 16 Jan 2024 07:31:17 GMT

@yh2023 Please show Task manager and Memory side by with CPU from the node where you open and also locally from your machine.

How you know from which node the app is open? You can drag KPI object and use this =ComputerName() to find out that.

Re: Unresponsive Behavior in App When Accessing Specific Sheet

yh2023 — Tue, 16 Jan 2024 08:53:32 GMT

@Anil_Babu_Samineni I'm using Qlik Sense SaaS, I am not sure examining the Task Manager might not provide relevant insights. However, upon opening the sheet, the Task Manager shows the following data:

Re: Unresponsive Behavior in App When Accessing Specific Sheet

Anil_Babu_Samineni — Tue, 16 Jan 2024 11:16:00 GMT

@yh2023 If it is SaaS, the model is same but now sure how you managed the sever allocation. If this is within your organization Infra, you can check logging in to server and find out.

If it is Qlik managed, please check with them.

But the way, Is this same for all apps?

Re: Unresponsive Behavior in App When Accessing Specific Sheet

yh2023 — Tue, 16 Jan 2024 11:50:28 GMT

@Anil_Babu_Samineni The server is managed by Qlik, and the problem is with just one app. When I open a specific sheet in that app, everything crashes, including other apps opened in other tabs. That specific sheet has four straight tables, each with about 10 columns and uses Rank function(for all the tables).

Re: Unresponsive Behavior in App When Accessing Specific Sheet

vincent_ardiet_ — Tue, 16 Jan 2024 13:05:44 GMT

Try to keep only one object, then 2... maybe you will be able to identify if one only is creating the issue.

Re: Unresponsive Behavior in App When Accessing Specific Sheet

Or — Tue, 16 Jan 2024 13:19:16 GMT

I'd suggest opening the app without data, or if that's not possible, open the app and heavily filter it (keeping only one row or something similar). If you are then able to open the sheet, then the issue is likely that one of the objects on the sheet is causing it to freeze. That would typically be a case of either an unusual expression, or more likely, some sort of Cartesian join being applied due to using fields from tables that are not connected by any keys.

Re: Unresponsive Behavior in App When Accessing Specific Sheet

Anil_Babu_Samineni — Tue, 16 Jan 2024 13:10:30 GMT

@yh2023 Please try to use any tools like QSDA (Qlik sense Document Analyzer) and see the performance?

Re: Unresponsive Behavior in App When Accessing Specific Sheet

Chip_Matejowsky — Tue, 16 Jan 2024 13:14:55 GMT

Hi @yh2023,

Since you're using Qlik Cloud, suggest that you utilize the App Analyzer app to determine memory footprint, if synthetic keys are present, etc. Refer to the Qlik Support article The App Analyzer for Qlik Cloud Customers.

If you are using the Qlik Sense Business Edition of Qlik Cloud, note that there is a 1.25GB size limit when the app is loaded.

Best Regards

Re: Unresponsive Behavior in App When Accessing Specific Sheet

yh2023 — Fri, 19 Jan 2024 07:12:58 GMT

Hi Everyone,

I appreciate all the responses. The problem lies with the Qlik Server, and I've submitted a ticket. The team has told me that they will be incorporating extra logs into the server.