Paras Hinduja Passport : How can I fix the “Out of memory” issue during data reloads?

[HindujaPassport]

Hi All,

I'm Paras Hinduja Passport expert . Can anyone suggest How can I fix the “Out of memory” issue during data reloads?

Thanks, Regards

Paras Hinduja Passport  

[hugo_andrade]

Hi @HindujaPassport ,

You will have to reduce the aggregated memory usage during the load.

If this is a Qlik Sense on Windows, then easy approach is to increase your server size to handle the load.

If this is a Qlik Cloud deployment, I would say you will need to apply Where clauses to only load the required data. If you can, remove the fields from the script that you are not using in the app. This will reduce the memory used.

If you use temporary tables within the script, make sure to Drop Tables when you no longer need them.

Please let us know the results.