topic Re: Reload Task Stuck in Starting in Management & Governance

Reload Task Stuck in Starting

itadmin_isa — Fri, 15 Nov 2024 22:30:59 GMT

Hi All

I have a couple of reload tasks that hang. By this I mean that the reload task stays in status "Starting" until manually aborted. This impacts the other reload tasks that I have in place

I would like your advise on the below:

1. Is this a Qlik sense issue ?

2. What might be causing the reload to remain in the "Starting" status for hours until manually aborted ? Ideally, shouldn't it move to "Failed" ?

3. Is there a way I can counter this i.e. if the task remains in "Starting" for over 30 minutes, I want the task to be aborted automatically

4. Any advise on how to tackle the situation

Re: Reload Task Stuck in Starting

David_Friend — Thu, 29 Sep 2022 19:42:29 GMT

@itadmin_isa this is the forum for QlikView, so ask your question in the QlikSense forum, and be sure to indicate your version.

Re: Reload Task Stuck in Starting

itadmin_isa — Fri, 30 Sep 2022 06:27:27 GMT

@David_Friend Could you help with the navigation to the right forum please

Re: Reload Task Stuck in Starting

Albert_Candelario — Fri, 30 Sep 2022 20:16:13 GMT

Hello @itadmin_isa ,

Is the status starting or started?

Is any task log generated for such tasks? The default timeout for tasks is 24h, if not killed manually are failing after 24h?

How you concluded the task is just hang?

Cheers,

Albert

Re: Reload Task Stuck in Starting

itadmin_isa — Sat, 01 Oct 2022 10:04:37 GMT

Hi @Albert_Candelario

Thanks for getting back to me. Please find below screenshot. The status of the job does not change for hours

Re: Reload Task Stuck in Starting

Albert_Candelario — Sat, 01 Oct 2022 12:36:03 GMT

Hello @itadmin_isa ,

Thanks for the picture.

Can you edit the timeout of an specific task for example to 60min and see if the task fails afterwards?

Also is the task script created?

This might help to narrow down the issue.

Cheers,

Albert

Re: Reload Task Stuck in Starting

RafaelBarrios — Sat, 01 Oct 2022 18:33:11 GMT

Hi @itadmin_isa

¿how this reload behaves when you execute it manually from the hub?

also, from the image you pasted, i can see is "started" and not "starting" or "triggered.

so, it should be executing something, maybe some heavy load or complex Join with more than 1 field.

also, you can see what is happening if you go to script log folder and look for the APP ID while executing.

C:\ProgramData\Qlik\Sense\Log\Script

Best,

Re: Reload Task Stuck in Starting

itadmin_isa — Mon, 03 Oct 2022 05:46:23 GMT

Hi @RafaelBarrios

When I load the data from the app, data is loaded successfully 8 out of 10 times. This is exactly what is bothering me., why does load data from the app work but the scheduled reload tasks remain in "Started" state

Also, could you explain the difference between Started and Starting. I assume Started implies the data source has been successfully connected to whereas Starting would imply that attempt to connect to the data source is in-progress

Please advise

Re: Reload Task Stuck in Starting

RafaelBarrios — Mon, 03 Oct 2022 07:07:45 GMT

Hi @itadmin_isa

Started means that is executing loading data, no matter if datasource is connected or not, its just as working doing something.

Starting im not sure if even exists, maybe in old version, but whould be something similar as "Triggered" that means that it was launched

here you have all the possible status for current version

https://help.qlik.com/en-US/sense-admin/August2022/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Administer_QSEoW/Managing_QSEoW/tasks-overview.htm

i think 8 out 10 its not good also, you need to idenfity where its getting stuck and for that you have the task log or you can use "Trace" in the script to see messages while executing manually.

my first guess would be a complex join (joining tables using multiple fields) or some connection whose timeout was increased.

Best,

Re: Reload Task Stuck in Starting

Albert_Candelario — Tue, 04 Oct 2022 05:00:28 GMT

Hello @itadmin_isa ,

Do you have any update on the points previously asked by @RafaelBarrios and me?

This might help to narrow down the possible issue here.

Cheers,

Albert

Re: Reload Task Stuck in Starting

itadmin_isa — Tue, 04 Oct 2022 14:19:43 GMT

Hi @RafaelBarrios @Albert_Candelario

I looked at the logs from the folder path C:\ProgramData\Qlik\Sense\Log\Script

To me, it doesn't seem like there is any new information in the logs. The only difference from the logs of a successful job are the last 3 lines

All fields specified in the query were found - User aborted (I did manually from QMC) - Execution failed

20220926T010044.506+0400 53 fields found: .......
20220926T121608.134+0400 User abort
20220926T121608.144+0400 Execution Failed

Re: Reload Task Stuck in Starting

Albert_Candelario — Wed, 05 Oct 2022 06:35:19 GMT

Hello @itadmin_isa ,

As per the row:
20220926T010044.506+0400 53 fields found: .......

It seems the task was executing normally, could you let the task run and see if it hits the Task Timeout or not, instead of aborting it manually.

If doing so, we might have a better picture of what is going on.

Cheers,

Albert

Re: Reload Task Stuck in Starting

itadmin_isa — Tue, 11 Oct 2022 11:55:41 GMT

Hi @Albert_Candelario

I have tried that too, but the task status does not change. Unless the job is aborted, the status will remain as "Started"

Re: Reload Task Stuck in Starting

Albert_Candelario — Tue, 11 Oct 2022 14:13:26 GMT

@itadmin_isa for how long did you left the task on started? Is the task timeout 24h. I would suggest changing the task timeout to 4h for example and see if it times out or not. If it does, then move back to 24h and leave it there for 24h+ hours and see the outcome.

Cheers,

Albert