QlikView freezes when trying Binary Load

[#1]

I have a document that I am converting to a Binary Load.

I've taken a copy of it, and restricted its load to everything prior to the current year.  I then have a second copy with only this year onwards.

In the second file, I binary load in the first one.

The problem I encounter is that when I get to the end of the load sequence, qlikview just freezes.  It says load completed, but the load screen doesn't close.  If I click End Here, nothing happens, and Abort will cancel out, but locks up QlikView.

Has anybody encountered something like this before?

[martinpohl]

Hello,

it seems to that QlikView is still calculation.

Are you only do a binary or you load other fields after the binary statement?

[#3]

I load extra data.

Essentially it is a single QV document, however since the data from all previous financial years does not change much, I have segregated that into a seperate file.  It is the same file, however its SQL SELECT part has been restricted to only pull data from 30/06/2011 backwards, this file is my source file. 

The second file, which binary loads this source file, has the exact same script, however it also loads all data from 01/07/2011 onwards.  This is the final file.

When I reload the final file, it works fine, until it gets to the end of the reload process, at which point it hangs.

If I do a debug, it gets to the end, but doesn't let me close the box, similar to the standard reload process.  The debug does not show any errors.

[martinpohl]

So load the binary file with 1 dataset,

additional the second file with 1 dataset to analyze the data model.

Regards

[#5]

Hi,

I had a similar problem, I solved by using a fact table for the QVD and than concatenate it in mamory, more upload decode data tables.

Perhaps Qlik fails to make the implicit conactenate of all tables in a binary upload.

[#6]

If I remove the binary load, then both files load fine.. its when I add the binary load that it doesn't work.