topic QlikView freezes when trying Binary Load in QlikView

QlikView freezes when trying Binary Load

Tue, 30 Aug 2011 04:09:27 GMT

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?

QlikView freezes when trying Binary Load

martinpohl — Tue, 30 Aug 2011 06:36:06 GMT

Hello,

it seems to that QlikView is still calculation.

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

QlikView freezes when trying Binary Load

Tue, 30 Aug 2011 07:12:48 GMT

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.

QlikView freezes when trying Binary Load

martinpohl — Tue, 30 Aug 2011 07:18:08 GMT

So load the binary file with 1 dataset,

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

Regards

QlikView freezes when trying Binary Load

Tue, 30 Aug 2011 07:23:43 GMT

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.

QlikView freezes when trying Binary Load

Tue, 30 Aug 2011 23:08:53 GMT

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