Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
loveisfail any hlp pls
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.
Its is very long script??
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
Hi Darell,
I have attached the full script .please have a look
OK so at which point is script hanging?
How big is the data source in rows?
from line 751...in the logs the data source has around 100000 rows
Tough to say
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; |