topic Re: Two-Field Table Box - Object Out of Memory!? in QlikView

Two-Field Table Box - Object Out of Memory!?

Fri, 13 Jun 2014 17:35:53 GMT

Hi guys -

I'm trying to make a table box with two fields from the same .qvd and I cannot get it to load. I can get one of them to load, but when I try and add another field (doesn't seem to matter which), it fails to load and tells me "Out of object memory." I've tried this with up to 36gb of RAM and it always fails. Really stumped right now... Thanks for the help!

Re: Two-Field Table Box - Object Out of Memory!?

venkatg6759 — Fri, 13 Jun 2014 17:40:16 GMT

Any synthetic keys in your data model? Have you tried using straight table

Re: Two-Field Table Box - Object Out of Memory!?

Gysbert_Wassenaar — Fri, 13 Jun 2014 17:40:27 GMT

How many records are in the table? Are you using the 32-bit of 64-bit version of Qlikview Desktop? The 32-bit version can only use 2GB ram max.

Re: Two-Field Table Box - Object Out of Memory!?

Fri, 13 Jun 2014 17:42:53 GMT

No synthetic keys and no, I haven't tried a straight table yet.

Re: Two-Field Table Box - Object Out of Memory!?

Fri, 13 Jun 2014 17:43:33 GMT

We're using the 64bit version. There are around 4 million records.

Re: Two-Field Table Box - Object Out of Memory!?

Gysbert_Wassenaar — Fri, 13 Jun 2014 17:45:48 GMT

Look at the table viewer. How many tables are there? Are they all associated or do you have data islands (unconnected tables)? Unconnected tables mean a cartesian product if you use two fields from different tables in one table box. That can be really bad for performance.

And showing 4 million records in a table box doesn't make much sense either. Try making some selections first. Nobody is capable of analysing 4 million records individually in reasonable time.

Re: Two-Field Table Box - Object Out of Memory!?

Fri, 13 Jun 2014 17:54:09 GMT

Agreed that showing 4 million records doesn't make sense, but we're trying to build a dashboard so that other controls get you narrowed down to a point where the table box shows a smaller, meaningful number of records.

Six tables - all connected. The table that I am pulling from has four connections, but they are all dashed lines with arrows going to it, and not the solid lines that the other tables have between them. Not sure what that difference means or if it's important.

Re: Two-Field Table Box - Object Out of Memory!?

swuehl — Fri, 13 Jun 2014 18:02:03 GMT

Do you have a circular loop in your model?

Re: Two-Field Table Box - Object Out of Memory!?

jaimeaguilar — Fri, 13 Jun 2014 18:06:10 GMT

Try using a calculation condition, so you can narrow the data displayed and avoiding the out of memory issue,

regards

Re: Two-Field Table Box - Object Out of Memory!?

Fri, 13 Jun 2014 18:11:01 GMT

Yes, I do get a notice for a loop when I reload the data. It's saying that one or more tables will be loosely coupled (which, I assume, is what the dashed lines mean?)

Re: Two-Field Table Box - Object Out of Memory!?

swuehl — Fri, 13 Jun 2014 18:14:48 GMT

Avoid the circular loop, e.g. by breaking one of the links actively by aliasing field names.

This should solve also the table issue.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references

Re: Two-Field Table Box - Object Out of Memory!?

Fri, 13 Jun 2014 18:30:59 GMT

Thanks swuelhl - I'll try this and get back to you.