Log file error

[Mahamed_Qlik]

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

[amonjaras]

Are you using variables?

Can you post your entire load script?

Regards.

[Brett_Bleess]

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