Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

Reload task Operation Monitor fails

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 )

Bhum4Sk.png

didn't solved the problem.

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

Does anybody else has any suggestion?

Kind Regards,

Mayhan

1 Solution

Accepted Solutions
laurischarf
Contributor III

Re: Reload task Operation Monitor fails

For us, the solution ended up being completely different. I just had to add INTERNAL\SA_SCHEDULER as an admin to our user list for section access. (The apps without section access loaded successfully.)

11 Replies

Re: Reload task Operation Monitor fails

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...

Partner
Partner

Re: Reload task Operation Monitor fails

Hi Ruben,

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

Best regards,

Mayhan

Re: Reload task Operation Monitor fails

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.
laurischarf
Contributor III

Re: Reload task Operation Monitor fails

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.

Partner
Partner

Re: Reload task Operation Monitor fails

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,

 

laurischarf
Contributor III

Re: Reload task Operation Monitor fails

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

Re: Reload task Operation Monitor fails

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,

laurischarf
Contributor III

Re: Reload task Operation Monitor fails

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
Partner
Partner

Re: Reload task Operation Monitor fails

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

Regards,