Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
aguirre
Creator
Creator

Error - 129 =

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?

 

 

 

Labels (1)
1 Solution

Accepted Solutions
theoat
Partner - Creator III
Partner - Creator III

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.

View solution in original post

7 Replies
theoat
Partner - Creator III
Partner - Creator III

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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. 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
aguirre
Creator
Creator
Author

Hello actually yhere is.

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

 

THanks

 

aguirre
Creator
Creator
Author

The problem doesn't happen if I put 

LOAD 
Distinct [Key Document], 
UPPER([Code ]) AS [Code]
FROM [$(myqvd2)] (qvd);
 
 
aguirre
Creator
Creator
Author

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

theoat
Partner - Creator III
Partner - Creator III

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
Partner - Creator III
Partner - Creator III

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

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.