Odata connectivity error with Qlik cloud

Siraj — Wed, 19 Mar 2025 23:08:30 GMT

Hi,

I'm connecting oData sets through Qlik cloud, most of data sets are loading good, but few throwing error like below.

it is connectivity problem or data in data set problem.

kindly help to fix this.

thanks in advance

Re: Odata connectivity error with Qlik cloud

Vinay_B — Sat, 09 Jul 2022 13:29:01 GMT

Hello @Siraj

This error indicated that you are trying to load the data which is consuming 5GB or more in-memory

Note: An app on disk is typically 4-6 times bigger in memory, although this is a rule of thumb and exceptions can and do occur, and an app within the "on-disk" size limit may balloon past the "in memory" limit.

Qlik sense SaaS capacity details: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/sense-capacity.htm

However, there is an exception if you have placed the app in a dedicated space.

If you want to know more about the memory consumption of the app and optimize them, please install App Analyzer while provides these details.

App Analyzer for SaaS: https://community.qlik.com/t5/Support-Updates-Blog/The-App-Analyzer-for-Qlik-SaaS-customers-is-available-NOW/ba-p/1734927

Alternate solution:

I'm not sure if this will work for everyone, but as a last resort, you could try to add some uses of the "sleep" function between API calls in the Data Load Script. This usually resolves OutOfMemory exception.

It's by no means a perfect solution as the total reload time will be increased quite a bit, but this will at least reload the app in some cases.

Between datasets you can add a 20-second delay:

Sleep 20000;

And for looping through pages of data, add a 2-second delay.

I hope this helps!

topic Odata connectivity error with Qlik cloud in Data Movement & Streaming

Odata connectivity error with Qlik cloud

Re: Odata connectivity error with Qlik cloud