Task got Stuck

[manu1512]

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

[manu1512]

loveisfail‌ any hlp pls

[darrell_tobin]

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.

[manu1512]

Its is very long script??

[darrell_tobin]

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

[manu1512]

Hi Darell,

I have attached the full script .please have a look

[manu1512]

darrelltobin‌

[darrell_tobin]

OK so at which point is script hanging?

How big is the data source in rows?

[manu1512]

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

[Anil_Babu_Samineni]

Tough to say

[darrell_tobin]

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;