Qlikview hangs while executing script

[#1]

Hi All,

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

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

Please advise

Thanks

[Colin-Albert]

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.

• Check if you have any synthetic key tables in your data model.

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

• Have you enabled a logfile in your document settings?

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