Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Not applicable

QlikView crashes after the reload completes

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

11 Replies
Not applicable

Re: QlikView crashes after the reload completes

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

Not applicable

Re: QlikView crashes after the reload completes

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

Not applicable

Re: QlikView crashes after the reload completes

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 *;

sri99999
New Contributor

Re: QlikView crashes after the reload completes

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.

Not applicable

Re: QlikView crashes after the reload completes

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?

Not applicable

Re: QlikView crashes after the reload completes

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?


Not applicable

Re: QlikView crashes after the reload completes

Hi raffael,

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

Not applicable

Re: QlikView crashes after the reload completes

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

Thank you

philipp_kunz
Contributor

Re: QlikView crashes after the reload completes

Hi,

Check your Hard Drive first.

Is there still enough space to store your QVD?

Regards philipp

Community Browser