topic Re: Log file error in QlikView

Log file error

Mahamed_Qlik — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I am unable to understand the log file error. I am able to run the qvw successfully on dev server but on prod it is getting failed. below is the failure line from log file.

2020-01-21 07:42:03 0817 Fact:
2020-01-21 07:42:03 0818 LOAD DISTINCT TempKey, key, FactKey, Attribute, [Attribute Value] Resident Products
2020-01-21 08:07:08 5 fields found: TempKey, key, FactKey, Attribute, Attribute Value,
2020-01-21 08:07:08 -129 =
2020-01-21 08:10:00 Execution Failed
2020-01-21 08:10:01 Execution finished.

Kindly help urgently.

Regards,

Mahamed

Re: Log file error

amonjaras — Wed, 22 Jan 2020 14:20:05 GMT

Are you using variables?

Can you post your entire load script?

Regards.

Re: Log file error

Brett_Bleess — Tue, 18 Feb 2020 22:34:19 GMT

See the following Articles:

https://support.qlik.com/articles/000051852

https://support.qlik.com/articles/000063182

It is most likely that you are experiencing a resource related issue, in particular lack of memory given this is a resident table, you should be able to utilize Windows Task Manager and the Processes tab to monitor the QV.exe or QVB.exe process to see how much memory it is taking to confirm if things are blowing up or not.

Regards,
Brett