topic Re: Error while opening straight table. in QlikView

Error while opening straight table.

Thu, 21 Nov 2013 09:16:22 GMT

Hi,

I have one qvw in live folder with size 213MB when I am opening straight table it is showing below error.

Cpuld anyone ket me know what it means and how can I solve this please help me.

Thanks.

Re: Error while opening straight table.

bbi_mba_76 — Thu, 21 Nov 2013 09:18:24 GMT

Hi,

you could try to minimize the table, make same selections and then maximize the table.

Re: Error while opening straight table.

Thu, 21 Nov 2013 09:19:25 GMT

Thanks and how to do that one please any screen shot and if I make this qvw in access point will it show again same problem?

Re: Error while opening straight table.

datanibbler — Thu, 21 Nov 2013 09:20:45 GMT

Hi Amelia,

you're out of memory, meaning your table uses up way too much resources.

Do you have that same problem with any other objects or only with this table?

=> I had a similar problem and I solved it by reducing the nr. of dimensions for that table:

- Before, I had entered every field I wanted to see as a dimension

=> I tested out how many dimensions I needed to uniquely identify an item (3 or 4) and used just those and entered
the remainder of fields as formulas. That greatly reduces resource_usage as QlikView doesn't perform all that
unnecessary searching for differences...

HTH

Best regards,

DataNibbler

Re: Error while opening straight table.

Thu, 21 Nov 2013 09:22:40 GMT

Hi,

while opening other sheets it is showing same any solution please.

I have one sheet with 3 huge staright tables and two huge table boxes. can I split the straight tables in one sheet and table boxes in another sheet.will this solve my problem?

Re: Error while opening straight table.

datanibbler — Thu, 21 Nov 2013 09:24:07 GMT

Well, then it seems like you have a more general problem - is your PC powerful enough to deal with QlikView?

Re: Error while opening straight table.

bbi_mba_76 — Thu, 21 Nov 2013 09:27:58 GMT

In the straight tables you have calculated dimensions?

Re: Error while opening straight table.

Thu, 21 Nov 2013 09:29:33 GMT

Hi Amelia,

This error comes when there is not enough RAM to process input. This can be solved by reducing the number of input records. So try loading script with less input data.

Re: Error while opening straight table.

Thu, 21 Nov 2013 09:32:07 GMT

Yes there are some calculated dimensions

Re: Error while opening straight table.

Thu, 21 Nov 2013 09:32:47 GMT

Thanks and I need to make all the columns and at the starting itself I make less input data. any solution please?

Re: Error while opening straight table.

datanibbler — Thu, 21 Nov 2013 09:46:39 GMT

Hi kavitakadli,

reducing input data is easy to say - usually when you build a QlikView_app, you are supposed to show all of the data.

Still, you have a point - there are often fields which are not needed (in which case there is a "document_analyzer" that will tell about fields not used on the UI - and you might be able to filter for only a certain timerange - the latter possibility depends on the users' wishes...

Another point you could try: You say there are calculated dimensions - those are resource-heavy. Try to think of a way you can calculate these dimensions in the script so that on the UI you can access them as regular fields.

Re: Error while opening straight table.

Thu, 21 Nov 2013 10:19:42 GMT

Hi DataNibbler,

Reducing data size--> was a suggestion to test whether the error goes off after doing that. So that we can be sure that its memory problem. Then we can request for upgrading machine hardware to process huge data.

Everybody in the world knows that we need to use all input data according to user requirement in the application.

Re: Error while opening straight table.

datanibbler — Thu, 21 Nov 2013 10:26:24 GMT

Hi kavitakadli,

I wouldn't be so sure about everybody knowing that - but I didn't mean to cross you. Sorry!

Of course it is a good way to test whether the code in itself works.

(Amelia, just in case, just prefix your LOAD statement with a FIRST XX statement (where XX is a number))

Re: Error while opening straight table.

Anonymous — Thu, 21 Nov 2013 10:27:21 GMT

Amelia

Have you tried running Rob Wunderlich 's Document Analyzer V1.15 against your qvw ?

It is a great way of identifying what in your qvw is consuming what RAM. Then when you know the cause of the issue defining the solution is a lot easier.

Best Regards, Bill