Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Mayhan
Partner - Contributor
Partner - Contributor

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

Labels (2)
1 Solution

Accepted Solutions
Lauri
Specialist
Specialist

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

View solution in original post

11 Replies
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
Partner - Contributor
Partner - Contributor
Author

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

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

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

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

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

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

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

Regards,