topic Re: Out of object memory issue in QlikView

Out of object memory issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

Need your help in this issue, we are trying to join 3 tables through left join and after joining 3 table, we are getting "Out of object memory" error.

Below is the attached file for your reference.

Kindly let us know, if we are missing out any step.

Re: Out of object memory issue

Anil_Babu_Samineni — Fri, 25 May 2018 11:10:42 GMT

Seems, I can't open application. Can you share your script?

Re: Out of object memory issue

Chanty4u — Fri, 25 May 2018 11:47:44 GMT

try with left keep and reload once

Re: Out of object memory issue

Anonymous — Fri, 25 May 2018 15:15:01 GMT

Hi Chanty,

Thanks for your reply, its solved the error, but we need all the fields in one single table and dont want to keep them separated.

Regards

Abhijit

Re: Out of object memory issue

olivierrobin — Fri, 25 May 2018 15:31:17 GMT

hello

how many rows do yo have in each table ?

is each value of key unique ?

if not, your load will multiply each row on the left by the number of times the same value of key is present in the right

-> this may generate a huge number of rows

Re: Out of object memory issue

Anil_Babu_Samineni — Mon, 28 May 2018 03:40:28 GMT

Simply load normally without any joins and see how data model looks?

Re: Out of object memory issue

jyothish8807 — Mon, 28 May 2018 04:47:03 GMT

Hi Abhijit,

Normally keeping to many fiuelds in a table is not a good practice as per my suggestion. Table starts hanging/crashing and cause out of memory sometimes.

Why don't to try to implement "Customized tables" ? It will give flexibility to user to select only the required fields as per the scenarios.

Customizable Straight Table

Br,

Re: Out of object memory issue

Anonymous — Mon, 28 May 2018 06:13:39 GMT

Hi All,

Thanks for your suggestions.

We have resolved this issue by following a different method.

Thanks & Regards

Abhijit Mishra