topic Re: load script is getting stuck after loading all table rows in QlikView

load script is getting stuck after loading all table rows

Mon, 02 Jun 2014 11:50:29 GMT

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!!!

Re: load script is getting stuck after loading all table rows

Mon, 02 Jun 2014 11:54:14 GMT

Any info in log?

Re: load script is getting stuck after loading all table rows

ThornOfCrowns — Mon, 02 Jun 2014 11:54:34 GMT

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.

Re: load script is getting stuck after loading all table rows

its_anandrjs — Mon, 02 Jun 2014 11:57:26 GMT

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

Re: load script is getting stuck after loading all table rows

Mon, 02 Jun 2014 11:59:56 GMT

Hi Anand,

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

Re: load script is getting stuck after loading all table rows

amit_saini — Mon, 02 Jun 2014 12:02:46 GMT

Kavita,

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

Thanks,
AS

Re: load script is getting stuck after loading all table rows

Mon, 02 Jun 2014 12:04:39 GMT

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.

Re: load script is getting stuck after loading all table rows

Mon, 02 Jun 2014 12:05:20 GMT

Hi Amit,

Where do I find the log file?

Re: load script is getting stuck after loading all table rows

eduardo_sommer — Mon, 02 Jun 2014 12:06:59 GMT

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

Eduardo

Re: load script is getting stuck after loading all table rows

Mon, 02 Jun 2014 12:09:21 GMT

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.

Re: load script is getting stuck after loading all table rows

amit_saini — Mon, 02 Jun 2014 12:10:43 GMT

Kavitha,

Go to Document Properties -->General--> Enable "Generate Logfile" option and reload your application . This will create automatic log file for your application.

Thanks,
AS

Re: load script is getting stuck after loading all table rows

Jason_Michaelides — Mon, 02 Jun 2014 12:13:52 GMT

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

Re: load script is getting stuck after loading all table rows

daveamz — Mon, 02 Jun 2014 12:15:52 GMT

Hello,

Go to "Edit script" > Debug > Check "Limited Load" to 100 and hit Run.

After reloading limited data, see if any synthetic table is created.

In first scenario, where no changes are made to the columns name, the 2 tables are concatenated automatically, in the second scenario, if you have 2 different columns, QV tries to create a synthetic table and that's why is getting stuck.

Regards,

David

Re: load script is getting stuck after loading all table rows

its_anandrjs — Mon, 02 Jun 2014 12:18:08 GMT

You can find the log file creation flag it is active of not in the

Document Properties >> General >> generate log files

See snap:-

Check your data model may be there is synthetic keys are creation and due to that your application hags may be there are more field names are same.

And did you use error modes in the application.

Re: load script is getting stuck after loading all table rows

eduardo_sommer — Mon, 02 Jun 2014 12:28:08 GMT

Try using debug instead of simply reloading. Then, in the debug screen, check Limited Load. It will suggest 10 as the number of records per table. This will be fine. Then, click in Run.

After the script execution, go to the table viewer to see if it has created the synthetic keys. In case this is the reason, follow Jason's tips, using concatenate load.

Eduardo

Re: load script is getting stuck after loading all table rows

Mon, 02 Jun 2014 12:33:32 GMT

Hi Jason,

I tried using limited load option but I'm facing this problem in case of limited load as well.

Re: load script is getting stuck after loading all table rows

Jason_Michaelides — Mon, 02 Jun 2014 12:34:46 GMT

I didn't suggest a limited load...you need to use CONCATENATE

Re: load script is getting stuck after loading all table rows

Mon, 02 Jun 2014 12:35:08 GMT

Hi Amit,

Thanks for the reply. I have done the setting you suggested. Now could you please tell the location where I can find this log file.

Re: load script is getting stuck after loading all table rows

Mon, 02 Jun 2014 12:42:36 GMT

Thanks Jason. Its working with CONCATENATE option.