topic Re: out of Object Memory in QlikView

out of Object Memory

Anonymous — Sat, 13 Jun 2015 09:46:25 GMT

I have an application of size around 3 MB which has around 12 tables.I made a straight table in the front end ,table is working fine unless I click on clear selections button and it shows the message "Out of Object Memory" when i take few selections table is working fine...

I have made few calculations in the table in the expressions and calculated dimensions.

How do I deal with this problem??

Re: out of Object Memory

Mon, 15 Jun 2015 10:09:04 GMT

I am not very sure this helps you or not but i have used this for improving performance.

You may try to restrict the number of rows returned by using say TOP N functionality.

Also you may reduce the data getting calculated one by using time periods.

Thanks

Re: out of Object Memory

rajeshvaswani77 — Mon, 15 Jun 2015 10:16:14 GMT

Hi Adheesh,

The Expressions you have created look heavy, can you consider moving them to the script?

thanks,

Rajesh Vaswani

Re: out of Object Memory

vcanale — Mon, 15 Jun 2015 10:17:48 GMT

Hi,

Too many data to show when no selection is applied.

Double check how did you link the 12 tables and try to reduce the amount of data to load in the script

Re: out of Object Memory

avinashelite — Mon, 15 Jun 2015 10:24:09 GMT

Hi Shrama,

I think you doing too much of calculation in the charts and all the columns are not coming the same table.

Try to push all the calculated dimension into the script and try to avoid referring to the Orphan column or tables in the in the charts

Re: out of Object Memory

Peter_Cammaert — Mon, 15 Jun 2015 10:25:38 GMT

Two possible solutions come to mind:

Simplify, simplify, simplify: check your table relations (for cartesian products or butterfly associations), the amount of data you need to calculate the objects, the expression complexity, whether you can recover expression results etc.
Intercept the error using some selection check. For example, you can check the number of selections in a field, and if this number is greater than 100000, display a message that suggests a selection in a particular field. See Object properties->General->Calculation condition

Peter

Re: out of Object Memory

Anonymous — Mon, 15 Jun 2015 11:36:38 GMT

Thank You guys for your suggestions, I tried this application also on 32 gb system still out of memory...I am performing like 3 calculated dimensions and one complex calculation in expression (not too complex but am using Total Qualifier)

How do I do it in script since it involves fields from various tables?It gives an error field not found...Am I missing something here?

Re: out of Object Memory

avinashelite — Mon, 15 Jun 2015 11:45:15 GMT

can you please post your app??

Re: out of Object Memory

Anonymous — Mon, 15 Jun 2015 11:49:06 GMT

Sorry Avinash I can not..I need help urgently..I wish I could post it here...

Re: out of Object Memory

avinashelite — Mon, 15 Jun 2015 11:52:00 GMT

OK, try to avoid reference for the table columns, try to combine the table using SQL and then try your calculation here.

Without the script it would to hard to judge the issue

Re: out of Object Memory

Anonymous — Mon, 15 Jun 2015 11:52:37 GMT

I have created a table with calculations in the frontend...is there a way I can store it in QVD and then just fetch this data into QVW so the calculations are performed just once and then the records are just read from that QVD into this QVW and the memory does not go out of range..I know the concept of binary load but if I could store it in a qvd is that possible??

Re: out of Object Memory

avinashelite — Mon, 15 Jun 2015 11:59:29 GMT

as per your problem statement, yours is a 3MB application so I don't think its the data size issue, its purely the way your writing the expression is resulting in the OUT OF MEMORY. May be your expression is ambiguous and Qlikview is not able to resolve it , try to break your expressions into parts then try to check which portion is causing the issue!! this way you will get to know the root cause . Then think whether we can push this to script level or we should handle it in the SQL etc.

Try to paste your script, data model and expression that is will help us to identify the problem .

Re: out of Object Memory

Anonymous — Mon, 15 Jun 2015 17:57:11 GMT

Guys I got the application and I am attaching it here...please let me know any possible wayout..what I am going to do soon is concatenate as many tables as possible and then perform calculation sin the scripting...thats the best I could think of ,for now..if you guys get any other suggestions after going through the application please let me know...Thanks..

Re: out of Object Memory

Anonymous — Mon, 15 Jun 2015 17:59:29 GMT

Re: out of Object Memory

jonas_rezende — Mon, 15 Jun 2015 20:56:30 GMT

Hi.

See in link below, documents that cover best practice in data model, there are several *.pdf until ppt.

https://community.qlik.com/thread/86988

Hope this help!

Re: out of Object Memory

Anonymous — Tue, 16 Jun 2015 07:55:21 GMT

Can Anybody help me with this?

I want to write a condition as follows-

If(Col A =Col B and Col C= Col D,F)

Col A ,B ,C,D are all from different tables.

How do I achieve this?

Re: out of Object Memory

vcanale — Tue, 16 Jun 2015 08:37:19 GMT

Hi Adheesh,

- Double check the data model and try to optimise it using joins, mapping load..

- You didn't set any variable. Try to store the expressions in variables, and use the same variables wherever you need them, to ensure that the calculations are not repeated. Same for the Calculated Dimensions.

- Use the Date field to filter the data at least by Year (..or Quarter or Month)

Also.. do you really need to show the rows reporting "Missing" for all the fields?

Re: out of Object Memory

Anonymous — Tue, 16 Jun 2015 08:46:22 GMT

Hi Vincenza

Thanks for your suggestion I'll try for variables and as for the date field there is only 2 month data in this report it is working on selections but once I clear the selections it goes out of memory...

Re: out of Object Memory

vcanale — Tue, 16 Jun 2015 08:56:28 GMT

If you remove the 3 Calculated Dimensions:
1) =if(trim(Capitalize([Dist_From City]))=trim(Capitalize([Dist_From City])) and trim(Capitalize([CFA_From City]))=Trim(Capitalize([Ship To Location1])),[Distance in KM])

2) =if(trim(Capitalize([CFA_From City]))=trim(Capitalize([Dist_From City2])) ,Distance2)

3) =round(if([tr_Invoice Date Original]>=[Effective Date] and [tr_Invoice Date Original]<=[Expired Date],[Unit Price]),0.01)

it works!

Add 3 different list box with these 3 formula and have a look at the result!

Re: out of Object Memory

Anonymous — Tue, 16 Jun 2015 09:12:06 GMT

I removed the last dimension yesterday...i Checked it too ..how do I write the first 2 in the script?can u please help me with this?