Object Out of Memory Issue

[jyothish8807]

Hi All,

My straight chart is giving an Object Out of memory Error and taking a lot of time to load .Most of the time it becomes not responding and crash.It works if i keep the selection limited to few months but crashes once i take the complete selection.

How to solve this issue.Iam fetching a lot of data into this chart

Regards

KC

[alexandros17]

Prefilter with some selection or make expression easier to compute

[Gysbert_Wassenaar · Accepted solution]

Possible solutions:

• Redesign your straight table. Perhaps you can use expressions that require less resources. Or add fewer dimensions and/or expression to your chart.
• Load less data in the chart by forcing selections to limit the number of rows
• Redesign your data model. Perhaps your data model is not optimal and causes Cartesian products in your chart.
• Add more ram to your machine

[jyothish8807]

Hi Gysbert,

     Thanks alot for your reply.Iam fetching data from 200 different excel sheets and consollidating then using QV and pulling all the data into staright chart (Table).I have to capture all the informations in that.Cant optimise by using set analysis or any thing.I have a lot of data 2,50,000 rows and almost 20 fields in Expresion.

Regards

KC

[Gysbert_Wassenaar]

I assume you mean 2.5 million rows. Nobody, let me repeat, nobody can analyse that amount of data on a row-by-row basis in any same amount of time. I don't know how many dimensions your using in that chart, but 20 expressions is a high amount too if you intend to show them all at the same time. Why do you need all that information at the same time in only one chart?

[vardhancse]

Try to split data in the dashboard.

So that there will be no out of memory error in the dashboard

[#7]

I totally agree with Gysbert on this. Nobody can analyse the amount of data that you are including on that straight table.

One thing you could try is calculating the table only when certain conditions are made (for example, count(distinct [Month]) <= 3).

To do this go to the properties of the straight table and add this condition:

This way you won't get the out of memory error. Make sure that you inform the users of the conditions that need to be met before the data can be displayed on the table.

Also try calculating the expressions during the load script. This way you will use less memory while using the app.

If what you need is to export the data, remember you can do this also during the loading process with a store command.

[jyothish8807]

Got your point Gysbert, but i have to load all those data together, thats the requirement.I have to submitt those data on a weekly basis to higher management and they ask for old data also,because of that i was keeping all data together. Now,i will spilt those data into two or three charts as per year, hope it will works.

Thanks a lot 

Regards

KC