Error - 129 =

[aguirre]

Hello what kind of error this could be?

The Load script gets interrupted with the attched error.

The problem happens here 

list_tmp0:

Load 

*,

    num([Anno],'0000') & num([Mese],'00') as [Anno Mese]

FROM [$(myqvd1)] (qvd);

tmp:

LOAD 

[Key Document], 

UPPER([Code ]) AS [Code]

FROM [$(myqvd2)] (qvd);

left JOIN (list_tmp0)

Load * Resident tmp;

Drop Table tmp;

when tmp << myqvd

What could cause this error? ANd what could "-129 =" mean?

[theoat]

Is there a field in common between the 2 tables (list_tmp0 and tmp)? The fields must have the same name. If not, it creates a Cartesian product, which can be the cause of the -129 error.

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

[Lech_Miszkiewicz]

Yes- agree with @theoat 

-129 error is basicly "out of memory" error. Your server does not have resources to process your query and the reason would be possibly the cartesian product due to lack of key field between tables. 

[aguirre]

Hello actually yhere is.

[Key Document] is the a column field name in common

THanks

[aguirre]

The problem doesn't happen if I put 

LOAD 

Distinct [Key Document], 

UPPER([Code ]) AS [Code]

FROM [$(myqvd2)] (qvd);

[aguirre]

So I guess it's as your wrote an "out of memory" error. 

[theoat · Accepted solution]

There seems to be a lot of duplicate line in your source file (QVD2). The server may not have the computational capacity of the server. Favor the distinct.

[theoat]

Feel free to put an answer in solution to close the topic.

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.