topic limited load in debug mode is ignored in QlikView

limited load in debug mode is ignored

tabletuner — Sun, 24 Apr 2011 23:37:21 GMT

Hi Forum,

Last week i installed qv 10 sr2. Its working fine. However, when i limit the amount of rows to be loaded (to for example 10) in debug mode, the limitation is ignored. The script loads all data, ignoring my limitation [:S]. It happens to all connections e.g. SAP, xlsx, sql...

Havent found a related post yet. Anyone a clue?

Regards,

Tjeerd

limited load in debug mode is ignored

deepakk — Mon, 25 Apr 2011 06:59:37 GMT

hi,

It might be a bug. Send a mail to Support.

limited load in debug mode is ignored

tabletuner — Mon, 02 May 2011 14:08:14 GMT

You were right. Support confirmed it this morning to me.

limited load in debug mode is ignored

tabletuner — Thu, 26 May 2011 20:31:01 GMT

I found the reason. QlikView 10 SR2 isnt fully compatible with files created in 8.x.

Files created in 8.x cannot be limited loaded in 10 sr2.

Files in created in 10 SR2 can be limited loaded without a problem.

I also had the same compatibility problem with changing the background colour for files created in 8.x.

limited load in debug mode is ignored

deepakk — Mon, 30 May 2011 14:29:09 GMT

cool. Best of Luck..

limited load in debug mode is ignored

mschroff — Fri, 10 Jun 2011 20:25:49 GMT

what about QVD's created using QV10 SR2? The limitation was initially acknowledged and after a few crashes, the limitation is now being ignored.

limited load in debug mode is ignored

Mon, 13 Jun 2011 09:22:47 GMT

I'm afraid this isn't anything to do with loading files from 8.x we have never had it installed and are still having the same issue from 10 SR2. Files created fresh in 10 SR2 still have the same problem. It only manifests itself when running on the server though, when using the client for 10 SR2 the limited load seems to work fine.

limited load in debug mode is ignored

Mon, 13 Jun 2011 09:27:46 GMT

Having just done a bit of investigating both of the systems I'm working on have 10 SR 2 10.00

8935.7 installed, however one version is X64 and the other X86, the X64 version is installed on our sever, perhaps the X64 version has this issue?

limited load in debug mode is ignored

mschroff — Mon, 13 Jun 2011 22:49:14 GMT

Very possible because I'm working off x64 on a laptop.

limited load in debug mode is ignored

munirche — Mon, 20 Jun 2011 20:07:34 GMT

There has to be some other reason. I just tried a new script completely created in version 10.00.8935.7 SR2 64 bit, and the script completely ignores the limited load option.

Any ideas?

Thanks.

Re: limited load in debug mode is ignored

Tue, 21 Jun 2011 08:03:23 GMT

This is actually a confirmed issue with Qlikview 10 SR2 X64 8935, there is a patch available for 8940 from Qliktech if you contact support that fixes the issue. You just have to replace the Qlikview.exe file. Contact support to resolve it!