topic Re: QlikView crashes after the reload completes in QlikView

QlikView crashes after the reload completes

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

Following the reload of data, be it in normal or debug mode, following the completion of the script I am experiencing a big jump in RAM usage and the program crashes.

I am getting the same behaviour whether it be 1 or 1,000,000 lines. What happens at the end of the script that could be causing this?

The log file is showing that the script finished with no errors, so that is not helping me at all.

Thanks for your assistance.

Lee

Re: QlikView crashes after the reload completes

Tue, 10 Jul 2012 16:14:52 GMT

Hi Lee,

I've come across several causes of this, most recently when trying to store data to a qvd using a path that doesn't exist. From memory in every case, it's been a simple syntax error. Please post your code and we can have a look.

Regards,

Ben

Re: QlikView crashes after the reload completes

Tue, 10 Jul 2012 16:20:50 GMT

Ah. I am using a relative path. Let me hard code it and see if the error disappears.

Re: QlikView crashes after the reload completes

Tue, 10 Jul 2012 16:31:40 GMT

Hmm. Relative and Hard Coded are working.

I have the below:

qualify *;

Table:

LOAD Fields

SQL SELECT *

FROM Table

WHERE LastModifiedDate >= '$(vLastExecTime)';

Concatenate

LOAD Field

FROM

SameTableName.qvd

(qvd)

WHERE NOT Exists(PrimaryKey);

Store * from Table into $(QVDPath)\TableName.qvd;

unqualify *;

Re: QlikView crashes after the reload completes

sri99999 — Wed, 11 Jul 2012 13:20:30 GMT

HI,

After store the Table into qvd, drop the table if not required.

If the table is to big, some time it crashes the qv.

Re: QlikView crashes after the reload completes

Wed, 11 Jul 2012 14:33:22 GMT

Thanks sri. I just did that yesterday but I am glad that it is going the right way to see suggest that as well.

What appears to be causing a lot of issues is the data being held in RAM despite the application being closed. Is there a Qlikview server setting that I have missed that would purge RAM do you know?

Re: QlikView crashes after the reload completes

Mon, 25 Mar 2013 10:07:03 GMT

Hi LeeAlderdice

my Qlickview crashes after finishing the Upload file input, and requires more GB of RAM pinning the PC.

To resolve I formatted the pc .. QV re-installed and the problem is solved.

but a few weeks ago has reappeared ...

I initially thought some keys or join in the document, but this problem also occurs when I do a file linked some light

if I load the same QV by a colleague, in a few seconds the charge and update it, if I do it is locked

how do you solve it?

Re: QlikView crashes after the reload completes

Wed, 01 Apr 2015 19:01:27 GMT

Hi raffael,

did you solve it meanwhile? Having exactly the same issues.

Re: QlikView crashes after the reload completes

Wed, 20 Jul 2016 12:10:19 GMT

Hello Lee, did you manage to solve this? I have the exact same issue.

Thank you

Re: QlikView crashes after the reload completes

philipp_ebner — Wed, 20 Jul 2016 13:27:05 GMT

Hi,

Check your Hard Drive first.

Is there still enough space to store your QVD?

Regards philipp

Re: QlikView crashes after the reload completes

Thu, 28 Jul 2016 09:50:36 GMT

Actually I found it was due to a count distinct calculation on a table box caption title.

Weirdly, it seems to be calculated even when the whole table box is hidden and the user is navigating in other tabs.. When activating and showing the table, we can see that the title immediately displays the already calculated value when the table box itself is still being calculated. Removing it solved the strange behaviour of the application.

Regards,

Ana

Re: QlikView crashes after the reload completes

Anonymous — Thu, 28 Jul 2016 09:54:45 GMT

Try putting a Sleep(9000) after the Store.