topic Reload Error in QlikView

Reload Error

Mon, 04 Jun 2012 09:15:24 GMT

I have 6 million records in my table. When i am reloading this huge data into my QVW file it is not getting reloaded. It freezes at this stage shown in the image.

Is there any limitation of the size of data in QlikView or what is the alternate solution ??

Reload Error

Miguel_Angel_Baeyens — Mon, 04 Jun 2012 09:22:12 GMT

Hi,

According to that image, the script has not stopped yet, otherwise the Close button will be available and the progress dialog will disappear.

Generally speaking, 6M rows is quite a small amount of rows, and QlikView should handle them quite faster, but it depends on hardware, OS, how the data model is built, links between tables and so.

Try going to the script editor, then click on the Debug button, and do a limited load to 100 records each table, and see if that makes the script go further or it stops at the same line of code.

Hope that helps.

Miguel

Reload Error

Mon, 04 Jun 2012 09:30:40 GMT

Thanks for the answer Miguel. I tried with 100 records and still it is hanging. So what could be the reason. I have around 160 columns in four of the tables. Could that be the reason ??

Reload Error

kaushiknsolanki — Mon, 04 Jun 2012 09:36:41 GMT

Hi Sumit,

Will you please tell us one thing, The table which is loded as shown in the image is the last table in the script?

If yes then there are chances that QlikView is linking all loaded tables. And in this case the reason why QlikView taking long time is, there are many fields which are common in the table which you have loaded.

If possible pls send us the script.

Regards,

Kaushik Solanki

Re: Reload Error

thomas_skariah — Mon, 04 Jun 2012 09:41:44 GMT

Hi Sumit,

I guess its because of multiple loops that are generating.

Regards

Tom

Re: Reload Error

Mon, 04 Jun 2012 09:54:13 GMT

Hi Kaushik,

I have attached the Script. i understand that it is very big. But it will be great if u could help me out.

Thanks in advance.

Reload Error

Miguel_Angel_Baeyens — Mon, 04 Jun 2012 10:14:01 GMT

Hi,

Use before the first line of load the following:

QUALIFY *;

Then do the load. That will prepend the name of the table to each field, avoiding unwanted synthetic tables and links between tables.

Hope that helps to start with.

Miguel

Re: Reload Error

Mon, 04 Jun 2012 10:33:17 GMT

Hi Kaushik,

Solved the problem. It was because of the two tables having each and every field names common. I used alias and now its working fine.

Thanks

Re: Reload Error

Mon, 04 Jun 2012 10:34:17 GMT

Thanks for your help Miguel. I solved the problem

regards