topic Re: Reload task Successful but data not updated in Connectivity & Data Prep

Reload task Successful but data not updated

LenCa — Mon, 28 Oct 2019 11:30:33 GMT

hello,

I have an app. If I run the database script and load script manually (I click the Load data button), data is updated from the database correctly.

For automatic update I set up a Task in Qlik Management Console. It's a reload task for that app. It runs once a day. Status is always Success.

The issue is that the data is never updated after the task runs. I always have to click the Load data button to get updated data.

Please, what could I check? What can be wrong?

Thank you

Re: Reload task Successful but data not updated

rubenmarin — Mon, 28 Oct 2019 11:47:53 GMT

Hi, it should update the data, double-check if the app you are realoading is the same, maybe the task is reloading an app with the same name in the local stream of another user.

Re: Reload task Successful but data not updated

LenCa — Mon, 28 Oct 2019 11:54:41 GMT

hi,

thank you.

I checked the other apps and there was one with the same name in a different stream but it wasn't updated either. And the task status for both of them is Success. I changed the names, just in case. But it doesn't seem to be the issue in this case.

Re: Reload task Successful but data not updated

rubenmarin — Mon, 28 Oct 2019 14:16:40 GMT

It's weird... in the app list of the qmc open the item of the published app. In associated items you can look for the related task to that app.

Also, in ProgramData\Qlik\Sense\Log\Script you can look the id of the app that has been reloaded, to confirm is the same as the expected app. In the upper right corner of the app list in qmc you can select the ID column to be shown.

Re: Reload task Successful but data not updated

Jacob_Poole — Mon, 28 Oct 2019 14:34:28 GMT

I'm not familiar with the sense QMC, but experienced a similar issue with view. In my case the task was enabled, but the reload option was not. Could this also be the culprit in Sense?

Re: Reload task Successful but data not updated

LenCa — Tue, 29 Oct 2019 06:38:08 GMT

I checked the item of the published app and there is the task and it is enabled and status Success. I checked both apps that had the same name. It looks like the tasks were done for the right apps.

I changed the names of the apps yesterday, they are unique now. I can't say if that helped yet, I need to wait until users add more data and check if the update works.

Re: Reload task Successful but data not updated

LenCa — Tue, 29 Oct 2019 06:41:18 GMT

Thank you. I created the tasks like "reload" tasks so I suppose this should be enough to enable the reload. But just in case I created new reload tasks for both apps after I changed their names to be unique (they were identical before).

Re: Reload task Successful but data not updated

LenCa — Wed, 30 Oct 2019 08:08:01 GMT

I checked the data today, not updated automatically.

When I go to QMC and the menu Tasks and I click Start for the tasks, they run successfully and the data is updated. It just doesn't happen automatically when the time is scheduled, I always have to click the Start button.

Task is Type=Reload, Enabled=Yes,Status=Success, date of last execution and date of next execution are correct.

The trigger setting screenshot is also attached.

Re: Reload task Successful but data not updated

rubenmarin — Wed, 30 Oct 2019 08:16:12 GMT

There is a log in ProgramData\Qlik\Sense\Log\Script for the time the task was executed automatically?

The ServiceAccount security rule should give access to the 'sa*' user to do all actions in both hub and qmc, is this rule active?

I don't have any more ideas

Re: Reload task Successful but data not updated

LenCa — Wed, 30 Oct 2019 08:39:47 GMT

Thanks.

ServiceAccount has all actions for both and it's enabled.

I can't find Script folder. My path ends here:

ProgramFiles\Qlik\Sense\Logging

Am I looking at wrong place?

Re: Reload task Successful but data not updated

rubenmarin — Wed, 30 Oct 2019 08:43:45 GMT

It's ProgramData, not ProgramFiles, ProgramData is a hidden folder usually in C:\

Re: Reload task Successful but data not updated

LenCa — Thu, 31 Oct 2019 07:35:03 GMT

I checked the logs today and there is no log file for the task for the app that was scheduled in the morning and that says run with Success.

What could I check now, please? Do you have any ideas? I'm new to Qlik.

Thank you.

Re: Reload task Successful but data not updated

rubenmarin — Thu, 31 Oct 2019 07:44:54 GMT

No much more. Trying to get some hints look if there is a log at the expected time but for another app, meaning that app it's reloaded at the time we expect to see your app.

Log is saved at the end of execution so it can be saved some minutes after or before the expected time.

You can also open a support case with Qlik, if not solved by message you can open a webex or similar so they can take a look at the server.

Re: Reload task Successful but data not updated

LenCa — Thu, 31 Oct 2019 08:18:46 GMT

I waited for 15 minutes and there was nothing, just one completely different task which was scheduled for later time than the one that I was watching.

Thank you for trying to help. I think I will have to open a support case. How can I do that, please?

Thank you.

Re: Reload task Successful but data not updated

rubenmarin — Thu, 31 Oct 2019 09:26:11 GMT

In https://qliksupport.force.com/

Re: Reload task Successful but data not updated

LenCa — Thu, 31 Oct 2019 11:44:20 GMT

I appreciate your help, thank you!

Re: Reload task Successful but data not updated

qliker2 — Wed, 28 Oct 2020 07:30:52 GMT

Hi LenCa,

any updates on this topic? We are facing a similar problem.

Re: Reload task Successful but data not updated

rubenmarin — Wed, 28 Oct 2020 07:38:52 GMT

Hi @qliker2, just to add that if this is a scheduled task the log can be found at shared folder, in the ArchivedLogs folder. Also review other answers given to this thread to check whats happening, usually 2 options: there was an error in the reload and the app was not update; the source files of the app where not updated, so the same data was loaded.

Re: Reload task Successful but data not updated

qliker2 — Wed, 28 Oct 2020 07:57:51 GMT

Hi @rubenmarin , thanks for your prompt answer! We are using reload tasks for many apps and the auto refresh of the screen works fine. But we have 2 apps, where the screen is not updated, even if the reload task is successful and the app-file is updated. They are only updated by manually refreshing the browser.

Re: Reload task Successful but data not updated

rubenmarin — Wed, 28 Oct 2020 08:11:35 GMT

Haven't found this isuue by myself. Can you double check that it is really the same app that has been updated? Maybe the app accessed by the user has another id, meaning it is in another stream than the one that has the scheduled reload.