Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

Failing reload tasks, no information from logfiles

Hello Qlik Community,

One of our customers has run into an issue where three specific reload tasks from the QMC fail repeatedly. Manual reloading through the QMC also leads to failed reloads, but manual reloading from the app itself works fine. The script error logs of the failed apps only give Execution Failed and Execution Finished without any additional errors or warnings, but the reload stops at the same point in the script each time.

Reloads of other apps that are scheduled around the same time are also reloading properly, so server/engine issues seem unlikely.

I'm personally suspecting some rights or connection issues but the user that is starting the reload (sa_scheduler) has full access to the applications in question.

Does anyone have an idea what could cause this issue?

 

Labels (2)
1 Solution

Accepted Solutions
jepeerik
New Contributor III

Re: Failing reload tasks, no information from logfiles

I had the same issue, after upgrading from QS April 2018 to November 2018. Reloads containing Section access were failing when reloaded by a task in QMC, and succeeded when reloading manually in Hub.

Logging was only showing 'Reload failed' at the end of the logging.

Solution: add the 'INTERNAL\SA_SCHEDULER' user to Section Access and the tasks are reloading successful again.

Sharing knowledge increases your knowledge
7 Replies
MVP & Luminary
MVP & Luminary

Re: Failing reload tasks, no information from logfiles

Do those documents have Section Access? If so is the INTERNAL\SA_SCHEDULER user included in the section access table?


talk is cheap, supply exceeds demand
Digvijay_Singh
Honored Contributor III

Re: Failing reload tasks, no information from logfiles

We have similar issue with one specific load, yet couldn't figure out the real issue but I am hearing around that it could be that source data is being written at the same time when Qlik is trying to reload from the same source. But in our case manual reload from QMC works fine, we normally do the QMC manual reload after 2-3 hours so not sure if it would have failed if reloaded manually just after it failed. Its just with singe reload so we haven't spent much time to understand it further.
Partner
Partner

Re: Failing reload tasks, no information from logfiles

Thanks for the quick reply. Yes sa_scheduler is included in the section access table.

UPDATE: The customer got a part of the script to work, differences in the log show that the working one is succeeding in creating search indexes on the fact table. The failing script errors out right before this indexing.

jepeerik
New Contributor III

Re: Failing reload tasks, no information from logfiles

I had the same issue, after upgrading from QS April 2018 to November 2018. Reloads containing Section access were failing when reloaded by a task in QMC, and succeeded when reloading manually in Hub.

Logging was only showing 'Reload failed' at the end of the logging.

Solution: add the 'INTERNAL\SA_SCHEDULER' user to Section Access and the tasks are reloading successful again.

Sharing knowledge increases your knowledge
Partner
Partner

Re: Failing reload tasks, no information from logfiles

Heya,

This is indeed the solution, also given earlier in this thread. The customer didn't use all caps for the section access table so it didn't work before.

Also important to give SA_SCHEDULER admin rights in section access.

Thanks for the replies!

Partner
Partner

Re: Failing reload tasks, no information from logfiles

Hello,

Thank you, that's exactly what I was looking for 🙂

Partner
Partner

Re: Failing reload tasks, no information from logfiles

Exactly what I was looking for, thank you!