Odata connectivity error with Qlik cloud

[Siraj]

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

[Vinay_B · Accepted solution]

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-capac... 

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-avail... 

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!