topic Re: Task got Stuck in QlikView

Task got Stuck

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am running a reload task where at at particular point task has stuck for a long time.It is not proceeding further.

Pfa the attach logs amd pls suggest something if you can

Re: Task got Stuck

trdandamudi — Mon, 11 Dec 2017 14:32:40 GMT

The log looks ok and it doesn't have any errors. When users a running tasks with millions of records it might take time or it will time out. Re run the task and it should be ok. This usually happens on our DEV.

Re: Task got Stuck

manu1512 — Mon, 11 Dec 2017 14:36:01 GMT

Hi thirumala,

Sometimes Task keeps run for 1 hour and still not gets complete>??? ANY Idea for this..

Re: Task got Stuck

stabben23 — Mon, 11 Dec 2017 15:01:29 GMT

As I can see you are using Binary Load, make sure that the binary loaded qvw is not reloaded at the same time. Or if you use qvd's inside , make sure that these not are reloading at the same time.

Re: Task got Stuck

manu1512 — Mon, 11 Dec 2017 15:07:35 GMT

hii stabben23‌,

Can you please what i can do to reactify this issue?

Re: Task got Stuck

stabben23 — Mon, 11 Dec 2017 15:13:49 GMT

Have a look in QMC when tasks is started and if these qvw's are reloaded at the same time.

It's only possible to load from a qvd With one qvw at a time. It can also be that you reload to many task simultaneously so you will have to wait until a free core (tread) is free until Next is started.

Re: Task got Stuck

darrell_tobin — Mon, 11 Dec 2017 15:22:09 GMT

Hi do you have the initial load editor script?

Re: Task got Stuck

manu1512 — Mon, 11 Dec 2017 15:36:44 GMT

yes

Re: Task got Stuck

manu1512 — Mon, 11 Dec 2017 16:02:31 GMT

Hi Darell,

I have attached logs and at one point it again got stuck .Can you please help me

Re: Task got Stuck

manu1512 — Mon, 11 Dec 2017 16:03:20 GMT

Hi Staffan

I have attached logs and at one point it again got stuck .Can you please help me

Re: Task got Stuck

manu1512 — Mon, 11 Dec 2017 16:04:54 GMT

loveisfail‌ any hlp pls

Re: Task got Stuck

darrell_tobin — Mon, 11 Dec 2017 16:06:51 GMT

Hi Manu,

Not the logs.

Go to the Qlik app.

Select 'Data load editor' then copy the script in here out then post it here.

Then say at which point the load script hangs.

Re: Task got Stuck

manu1512 — Mon, 11 Dec 2017 16:07:41 GMT

Its is very long script??

Re: Task got Stuck

darrell_tobin — Mon, 11 Dec 2017 16:10:51 GMT

OK so at which point is script hanging?

What is type of connection at hanging?

Is it hanging during indexing?

Send the part of the script that hangs?

How big is the data source in rows

Re: Task got Stuck

manu1512 — Mon, 11 Dec 2017 16:13:03 GMT

Hi Darell,

I have attached the full script .please have a look

Re: Task got Stuck

manu1512 — Mon, 11 Dec 2017 16:21:20 GMT

darrelltobin‌

Re: Task got Stuck

darrell_tobin — Mon, 11 Dec 2017 16:22:56 GMT

OK so at which point is script hanging?

How big is the data source in rows?

Re: Task got Stuck

manu1512 — Mon, 11 Dec 2017 16:27:55 GMT

from line 751...in the logs the data source has around 100000 rows

Re: Task got Stuck

Anil_Babu_Samineni — Mon, 11 Dec 2017 17:02:19 GMT

Tough to say

Re: Task got Stuck

darrell_tobin — Mon, 11 Dec 2017 17:08:00 GMT

Hi Manu,

If the source data only has 100000 rows it is not this that is causing the issue.

I can't see the data so can't test but looking at the script this look like issues with your joins.

So you have several joins (inner and left) in this script using the WCONHIST_tmp table. This I suspect is the reason for the hang.

If the join is not correct you can get the data joining to itself (Cartesian join) and multiplying the result rather than connecting the table 100,000* 100,000 =

10,000,000,000

I would strip the script back to the only go to just before it hangs.

Then load the data from the temp tables and view this in your Qlik sense app. Count rows? Look for duplication. I suspect this will be very big.

Hope this help please select correct and like if it helps you fix your issue.. 🙂

742	// * TXT_EXPORT.SPEICHER und TXT_EXPORT.BOHRUNG *
743
744	// Den Einträgen Count (0,1,2,3,5) müssen alle Speicher und Bohrungen zugeordnet werden.
745	// Die Felder "TXT_EXPORT.SPEICHER" und "TXT_EXPORT.BOHRUNG" werden später an der Oberfläche
746	// nicht visualisiert somit wird bei jeder möglichen Selektion der Speicher immer nur eine
747	// technische Zeile visualisiert.
748
749	Left Join(WCONHIST)
750	LOAD Distinct
751	WCONHIST_SPEICHER as tmp_SPEICHER,
752	WCONHIST_NAME_BOHRUNG as tmp_BOHRUNG
753	Resident WCONHIST_tmp;