topic Re: Execution Finished but Task Failing in App Development

Execution Finished but Task Failing

m_perreault — Fri, 18 May 2018 12:51:45 GMT

Hi All,

I have two tasks scheduled in the QMC which have failed several days in a row and I am trying to understand why. They are not particularly intensive loads. When I click the i icon in the QMC on the task the message relating to the fail is 'Message from ReloadProvider: The sequence of events was not completed. Check engine or script logs.' When I check the script log script log the last line of the log is 'Execution Finished' and there is no reference as to why the load failed. Has anyone experienced this before?

Thanks,

Mark

Re: Execution Finished but Task Failing

m_perreault — Fri, 18 May 2018 13:30:28 GMT

I should also add that when I run these tasks manually they run succesfully

Re: Execution Finished but Task Failing

lanlizgu — Thu, 12 Jul 2018 12:34:28 GMT

Hi Mark, Did you find the solution for this issue?

I am also experiencing the same issue and Qlik is not giving any suppport...

Re: Execution Finished but Task Failing

Chanty4u — Thu, 12 Jul 2018 14:37:53 GMT

is that task event trigger ?

do you have multiple tasks on same app?

try to check for the same and delete all other tasks with same app,

and create only one task for this and test.

Re: Execution Finished but Task Failing

BalaBhaskar_Qlik — Thu, 12 Jul 2018 16:00:25 GMT

May be try like this:

Qlikview task in QMC seems running forever

Delete the Task file and re run the services again.

Re: Execution Finished but Task Failing

lanlizgu — Fri, 13 Jul 2018 06:49:10 GMT

Hi, the apps now have 1 GB of size and the first execution uses to fail. Yesterday I tried to upload the app manually and it was not until the 4 time that it was uploaded correctly. Therefore, I modified the max retries number, that was set to 0 and now is set to 5.

Re: Execution Finished but Task Failing

lanlizgu — Fri, 21 Sep 2018 11:31:22 GMT

This is what I got from Qlik:

The warning to which you are referring - QVGeneral: when AAALR(1.293973) is greater than 1.000000, we suggest using new row applicator to improve time and mem effeciency. AAALR" is a very low level concept deep in the QlikView engine. Generally speaking it means the average length of aggregation array. The longer this array is, the more RAM usage and CPU power are to be consumed by the engine to get aggregation result for every hypercube node and can thus effect performance.

When AAALR is greater than 1.0, normally the customer has a large data set and suffers slow responses and high memory usage in their app.

To mitigate this, you can add the below setting to the Settings.ini file located in the QlikTech\QlikViewServer:

DisableNewRowApplicator=0

By setting this parameter to “0”, QlikView will use an new algorithm which is optimized for large data set to do the aggregation, and will consume much less RAM and CPU power.

Re: Execution Finished but Task Failing

lanlizgu — Mon, 08 Oct 2018 15:19:30 GMT

I used the ProcMon over the folder where the .qvf are and notice that the antivirus real time protection was reading the files when the QMC was trying to save them, causing the error.

By adding the path to the antivirus real time protection exclusion folders it was fixed.

Re: Execution Finished but Task Failing

janethlh — Tue, 11 Aug 2020 09:02:56 GMT

Hi, is there any update/solution on this problem?

My client's environment also facing similar issue on the larger apps. We're now in Feb 2020 QS.

Re: Execution Finished but Task Failing

zm — Mon, 21 Sep 2020 10:17:08 GMT

Hi, did you find a solution to this problem? I am having the exact same problem on QS June2020 Patch 5. Just a quick info on in and how you fixed it would be great. Thank you in advance!

Re: Execution Finished but Task Failing

janethlh — Tue, 22 Sep 2020 04:42:47 GMT

Hi Zm, we had raised support case to Qlik support but still haven't get permanent solution yet.

Our problem is the reload task failed with FinishedFail when execution finished without error shown in script logs. The app size of our app is about 15GB. Previously never experience this problem in previous QS April2018 at Windows Server 2012 R2. But we're facing this issue now in QS February2020 Patch6 in Windows Server 2016 Standard although we had added SA_SCHEDULER as ADMIN rights in Section Access as per suggestion from Qlik community post.

Our temporary workaround solution is to create this app as a new app to load the QVDs. Weird thing is this new app reload task is finished successfully at the first run in QMC. But it will fail at the next scheduled run. As a result, we force to create it as a new app in every days (because our one is daily dashboard) in order to load the QVDs for our end users before this problem be solved.

What about your problem?

Re: Execution Finished but Task Failing

gustavgager — Tue, 20 Oct 2020 09:58:33 GMT

Im having the same issue on an older installation. Did anyone find a solution or a feasble workaround? Or did it get solved with a newer version?

Re: Execution Finished but Task Failing

kazutaka_yorozu — Wed, 28 Jul 2021 09:19:26 GMT

I'm having the same problem with the May 2021 version.

The slight difference is that the error does not occur every time, but is extremely rare. It's about 1% of the time.

If I rerun it, it succeeds, but I'm having trouble getting the subsequent task of the event trigger to work.

The execution environment is AWS EC2, and the QVF file is stored in EBS and attached to the Central Node.

Re: Execution Finished but Task Failing

Udo — Fri, 15 Oct 2021 07:28:48 GMT

Same problem here. Any updates on this? We are relying for alerting on the status of the tasks overview. It is frustrating to see, that the app basically reloaded correctly (in the task log) but the status in the Tasks section of the QMC says "Failed". Running Qlik Sense Feb 2021 (14.5.10)

Re: Execution Finished but Task Failing

kazutaka_yorozu — Fri, 15 Oct 2021 09:13:15 GMT

In my environment, it no longer occurs.

The problem was occurring in a multi-node environment where QVF files were placed on the Central node.

When I made the Central node not to do any task processing or computational processing and to use almost no resources, the problem stopped.

If your Central node is very busy, you may want to give it a try.

Re: Execution Finished but Task Failing

Tooor — Fri, 05 Nov 2021 13:36:18 GMT

We had this problem and we managed to solve it. It was a large app (20GB). Some nights it would load OK, some nights it would fail - but we when it failed, we would get "Execution finished" in the log.

We figured it was related to the saving of the app (or perhaps the reading/writing of QVDs), so we turned off virus scanning for all qlik related files on the windows server. (Search for System Center Endpoint Protection and just add paths to all Qlik and QVD related files in Settings-->Exclude files and locations.)

After that, all loads have been stable.