Solved: load script is getting stuck after loading all tab... - Qlik Community

Report Inappropriate Content · ‎2014-06-02

Hi All,

I'm having a problem in load script. While loading everything is going fine. All the lines are getting fetched. But its getting stuck after that so I have to kill the process and then start again.

Can anybody please tell me why is it getting stuck ?

Thanks in advance!!!

Jason_Michaelides · ‎2014-06-02

That is because two tables with the same column names are automatically CONCATENATED (i.e. stacked on top of each other). By changing one of the column names you are causing them to be separate tables and therefore a large synthetic key is being generated at the end of the load script which is killing the machine.

When you load the second table, precede the LOAD statement with CONCATENATE (<1st table name>).

This will force the concatenation and you will have a single table with all columns aligned except the one you changed the name of.

Hope this helps,

Jason

View solution in original post

Report Inappropriate Content · ‎2014-06-02

Any info in log?

ThornOfCrowns · ‎2014-06-02

Do you get any errors or messages?

How much data?

How much memory on the machine?

How long does the process hang for?
Is there a lot of script in the LOAD that happens after you pull data?

What happens if you load with a smaller data set?

etc., etc.

its_anandrjs · ‎2014-06-02

Check the application log file for more details like how much table loaded and fields and loaded. Also you can use error modes available for the load script like

set ErrorMode=0; //Check help for more details for error modes

Load * from location;

Following are the error Modes

0	No error
1	General error
2	Syntax error
3	General ODBC error
4	General OLE DB error
5	General custom database error
6	General XML error
7	General HTML error
8	File not found
9	Database not found
10	Table not found
11	Field not found
12	File has wrong format
13	BIFF error
14	BIFF error encrypted
15	BIFF error unsupported version
16	Semantic error

Report Inappropriate Content · ‎2014-06-02

Hi Anand,

I'm new to qlikview. Could you please tell me how to check application log for errors?

amit_saini · ‎2014-06-02

Kavita,

Please check log file and share the error which you are getting.

Thanks,
AS

Report Inappropriate Content · ‎2014-06-02

Hi All,

I'm having 2 tables both are having same number of columns with same name. I have added an additional column named flag to differentiate both the table data.

Script works fine when both the table column names are kept as it is. But i wanted date column name to be changed. So I changed it and then the script started getting stuck.

Report Inappropriate Content · ‎2014-06-02

Hi Amit,

Where do I find the log file?

eduardo_sommer · ‎2014-06-02

Maybe it is creating synthetic keys for a large number of record. Do you have many common fields between the tables?

Eduardo

Report Inappropriate Content · ‎2014-06-02

Yes there are 10+ columns. But it works fine when all the column names are kept same. Problem comes only when I change one of those column name.

load script is getting stuck after loading all table rows