topic Re: Memory error in QlikView

Memory error

carlos13 — Tue, 11 Sep 2012 15:16:15 GMT

i am getting following error.

OUT OF VIRTUAL AND/OR LOGICAL MEMORY, allocating 2 mb

I'm working with these files, I could help find a solution.

thanks

Re: Memory error

srchagas — Tue, 11 Sep 2012 15:51:46 GMT

U using a S.o Whith 32 or 64 bits?

probably the load in B.D you giving is too large and they can't allocate in memory correctly, advise you partition your load, for example, making 30 in 30 days ... something like that.

Re: Memory error

carlos13 — Tue, 11 Sep 2012 16:02:03 GMT

Charging is not anything big is 599K, what happens is that I do a table scan to create a temporary, as shown in the Test file and arrange the columns.

Re: Memory error

carlos13 — Tue, 11 Sep 2012 16:47:49 GMT

Any help!

Thanks

Re: Memory error

srchagas — Tue, 11 Sep 2012 17:33:21 GMT

U try read That qvd u attach?

because in my server don't have that problem, ur System is 32 or 64 bits?

Re: Memory error

carlos13 — Tue, 11 Sep 2012 18:01:43 GMT

Works in 64-bit, maybe it's something in the script that are performing poorly or can be done in a more optimal.

Re: Memory error

srchagas — Tue, 11 Sep 2012 19:11:33 GMT

U using Load * ? or something like that?

Re: Memory error

Tue, 11 Sep 2012 19:28:24 GMT

try with some less column if it will works then try to load partition table(i.e, load table by part)

Re: Memory error

carlos13 — Tue, 11 Sep 2012 19:32:48 GMT

No, in the archive "test" your can see the load

Re: Memory error

carlos13 — Tue, 11 Sep 2012 19:39:42 GMT

As I can carry the load of the partition table?

Re: Memory error

srchagas — Tue, 11 Sep 2012 20:25:02 GMT

I think se say something like u do more qvd's files for this date and in load use: from [File_*.qvd](qvd)

Re: Memory error

carlos13 — Tue, 11 Sep 2012 20:36:20 GMT

Is the table "Riesgos_tmp" I do not have any date

Re: Memory error

carlos13 — Wed, 12 Sep 2012 22:12:39 GMT

What happens is that the problem occurs in the load, have been found in the part of:

FOR i = 1 to FieldValueCount('Tablename')
LET vTable = FieldValue('Tablename', $(i));
LEFT JOIN (Riesgos_tmp) LOAD * RESIDENT $(vTable);
DROP TABLE $(vTable);
NEXT i

In the end it not ends and the message