Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Load hangs when loading multiple qvd. files

Hi All, is anyone else having this issue?  When I try to load more that 1 qvd file my load script hangs.  This issue just cropped up several weeks ago and I can't seem to figure out why. 

It seems to load all lines from both qvd files but then hangs.  The elapsed time counter doesn't move and I end up having to abort the load.

12-1-2015 2-30-12 PM.jpg

1 Solution

Accepted Solutions
b_garside
Partner - Specialist
Partner - Specialist

Typically Concatenate goes between Load statements;

If you provide a sample script myself or Bill  may be able to help more.

Synthetic keys are autogenerated as you said as a result of fields named the same.

So if QV doesn't know to concentrate, so it tried to create "Keys" in this case maybe too many then it freezes.

I had a colleague loading 3 QVD it froze each time. Only worked when he loaded one.

To load three he had to use Concatenate to tell the engine to to not create separate table but one large one.

Status1:

LOAD @1 as mbyte,

@2 as typ,

@3 as menge

FROM

$(vfrom1)

(txt, codepage is 1252, no labels, delimiter is ';');

Concatenate (Status1)

LOAD @1 as mybte,

@2 as typ,

@3 as menge,

'$(vfrom2) As Quelle

FROM

$(vfrom2)

(txt, codepage is 1252, no labels, delimiter is ';');

View solution in original post

7 Replies
Anonymous
Not applicable
Author

You may well be creating a huge synthetic key somehow.

Try running in debug mode and only load say 10 rows, then look at the resultant data model.

b_garside
Partner - Specialist
Partner - Specialist

It may be trying to create Synthetic keys in which case it can easily hang. Seen this happen all the time.

Another time I saw some code where they were loading 1+ qvds to be "Auto' concatenated it froze every time.

So we added the command Concatenate between each load and all was well.

Each case is different, but hopefully that will get some ideas flowing.

Anonymous
Not applicable
Author

Thanks Bill - I tried that, it loads 10 rosw and promplty hangs, which makes it hard to look a the results.

Anonymous
Not applicable
Author

Brian - thanks for this.  I'm not sure what a synthetic key is (assume it is some kind of key that is automatically created by Qlikview?).  Would you be so kind as to provide an example of your Concatenate command.  I have tried it the script fails completely.

Thanks

Simon

b_garside
Partner - Specialist
Partner - Specialist

See if you can post some of the script or the general structure of it. That may help the community narrow it down to the root cause.

b_garside
Partner - Specialist
Partner - Specialist

Typically Concatenate goes between Load statements;

If you provide a sample script myself or Bill  may be able to help more.

Synthetic keys are autogenerated as you said as a result of fields named the same.

So if QV doesn't know to concentrate, so it tried to create "Keys" in this case maybe too many then it freezes.

I had a colleague loading 3 QVD it froze each time. Only worked when he loaded one.

To load three he had to use Concatenate to tell the engine to to not create separate table but one large one.

Status1:

LOAD @1 as mbyte,

@2 as typ,

@3 as menge

FROM

$(vfrom1)

(txt, codepage is 1252, no labels, delimiter is ';');

Concatenate (Status1)

LOAD @1 as mybte,

@2 as typ,

@3 as menge,

'$(vfrom2) As Quelle

FROM

$(vfrom2)

(txt, codepage is 1252, no labels, delimiter is ';');

Anonymous
Not applicable
Author

Brian - thanks very much for the insite and help.  I've the Concatenate command to solve the issue!

Thanks again,

Simon