Reload task Operation Monitor fails

[Mayhan]

Hi,

After an update from a colleague of mine (Qlik Sense November 2018 Patch 1 now)

The reload task Operation Monitor fails

Error:

FROM ' ....'
            2018-11-22 12:55:22 0478       (txt, utf8, embedded labels, delimiter is '\t', msq)
            2018-11-22 12:55:22 0479       WHERE isnum(Sequence#)
            2018-11-22 12:55:22      Error: Field 'ProxySessionId' not found
            2018-11-22 12:55:22      Execution Failed
            2018-11-22 12:55:22      Execution finished.

What i already tried:

- From the community i already tried this in the script (section: Run_logic):

( https://community.qlik.com/t5/New-to-Qlik-Sense/New-monitoring-apps-Qlik-Sense/td-p/106213 )

didn't solved the problem.

- Comment every 'ProxySessionId' out of the script, didn't help.

Does anybody else has any suggestion?

Kind Regards,

Mayhan

[rubenmarin]

Hi Mayhan, you can try to import the app again from %ProgramData%\Qlik\Sense\Repository\DefaultApps\

Also reset the password in data connections owned by sa_repository

This usually solves that kind of issues.

https://help.qlik.com/en-US/sense/November2018/Subsystems/Monitoring/Content/Sense_Monitoring/Troubl...

[Mayhan]

Hi Ruben,

I tried it but it still fails. Do you have any other suggestion?

Best regards,

Mayhan

[rubenmarin]

You can try looking on the reload log (in Qmc->Tasks) where it is getting an error. Also duplicating the app you can run a reload from script.
Maybe you need to add a security rule to hace access to the rest connectors while making the tests. Usually this data connections in hub are not available. An easy way is adding a temporary rule that gives your user access to everything in hub.

[Lauri]

Hi Mayhan, 

Did you resolve this? I upgraded to Nov 2018 last night and now have the same problem. Reload within an app works, but not from the QMC Tasks. Thanks for any tips.

[Mayhan]

Hi,

All files in the Engine, Printing, Proxy, Repository and Scheduler folders in that were created before 05-09-2018  put in zip files. These files are the cause of the failed reload task. You need to check in the script from which date the script is looking for data.

Best Regards,

[Lauri]

Thanks a lot for your reply, Mayhan. Can you explain more what you mean by "from which date the script is looking for data"?

[Mayhan]

in the log file there is a date from when data is retrieved. We ourselves had a lot of log files from before that date. What we have done is put all log files for that date in a zip file. We did this with folders from the Engine, Printing, Proxy, Repository and schedular.

In the script the date can also be a Variable

Best Regards,

[Lauri]

So you zipped up only files before 5/9/2018 in these folders?
C:\ProgramData\Qlik\Sense\Log\Engine
C:\ProgramData\Qlik\Sense\Log\Printing
C:\ProgramData\Qlik\Sense\Log\Proxy
C:\ProgramData\Qlik\Sense\Log\Repository
C:\ProgramData\Qlik\Sense\Log\Scheduler

Thanks

[Mayhan]

Yes and also for each file the audit, system and Trace folders

Regards,