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?
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.