Qlikview hangs while executing script

Wed, 14 May 2014 17:14:09 GMT

Hi All,

I have a large file, I cannot split, and have issues loading the data into Qlikview.

Qlikview Executing script loads and even though the time elapsed continues running, the number of rows counted stops at a minimal level (119,000)
The file size is large ~ 700,00KB
Qlikview does sometimes complete, but with insufficient data from the file
Running a 64bit version on a wind 7 computer.

Please advise

Thanks

Re: Qlikview hangs while executing script

Colin-Albert — Wed, 14 May 2014 18:28:04 GMT

Here are few points to start debugging your problem.

Try running the script in debug mode with a limited load set to 1000 or 100 or even just 10 rows.

This will prove that the logic within the script is correct.

Synthetic keys can cause delays in generating the key data after the script finishes but before control is returned to you.

The logfile will indicate what is happening during the load, and the timestamp of each event.