topic Re: Connection to a remote DB: Load hanging in QlikView

Connection to a remote DB: Load hanging

Mon, 24 Sep 2012 10:11:38 GMT

hi all,

I am connecting to a Mysql Database from my local computer. I have already created an ODBC with is working (the connection test is successfull in QV).

Now in the QV script editor , i am loading some table from the database. QV loads all the tables but "close" button is not activated (see picture attached). It is like qlikview is hanging, and i don't know the reason .

Can someone help me to find out what could be the reason of this behaviour ?

Best Regards

Cherif

Re: Connection to a remote DB: Load hanging

hallquist_nate — Tue, 25 Sep 2012 20:11:01 GMT

QV could be creating all the joins and associations. If you have a lot of keys, it can take a long time to make all the joins. Can you post your script?

Nate

Re: Connection to a remote DB: Load hanging

adnan_rafiq — Thu, 05 Sep 2013 08:12:53 GMT

Hi Cherif,

I am not still sure that if you are hanging on to this problem. I guess Actual problem is due that there are still some table needs to be fetched. but your due to time lags in query, odbc is sending queries again and again which is causing a lot of load on database server. Its not only hanging your system but also database program you are using.

If you have found any solution to this I would appreciate if you can share.

Regards

Re: Connection to a remote DB: Load hanging

kaushiknsolanki — Thu, 05 Sep 2013 08:24:44 GMT

Hi,

If Unit table is the last table you are fetching then, Qlikview is linking the tables. So if you have more than 1 field common between two or more table, it will create the syn table and thus it is taking time.

If Unit table is not the last table in your script then, qlikview is waiting for your database to reply the data set.

Regards,

Kaushik Solanki

Re: Connection to a remote DB: Load hanging

adnan_rafiq — Thu, 05 Sep 2013 08:37:16 GMT

thanks a lot for prompt response.

Re: Connection to a remote DB: Load hanging

adnan_rafiq — Thu, 05 Sep 2013 08:39:10 GMT

but I guess I am fetching data and dropping all tables after storing them. There is no key being formed, synthetic key is too fat fetched here.

Re: Connection to a remote DB: Load hanging

rajeshvaswani77 — Thu, 05 Sep 2013 08:41:32 GMT

Hi,

You could in turns comment some sections and run.

You will be able to narrow down.

thanks,

Rajesh Vaswani

Re: Connection to a remote DB: Load hanging

Thu, 05 Sep 2013 08:42:26 GMT

Hello

You can also generate log file for qvw and as others mentioned, the joining and associations might be taking much time.

Limit the data and try loading it.

Thanks,

ASINGH

Re: Connection to a remote DB: Load hanging

kaushiknsolanki — Thu, 05 Sep 2013 08:44:31 GMT

Hi,

Make sure that after fetching one table you drop that table and then fetch another table.

Regards,

Kaushik Solanki

Re: Connection to a remote DB: Load hanging

rajeshvaswani77 — Thu, 05 Sep 2013 08:46:05 GMT

Hi,

You could in debug mode select limited load of 10 records and then finally see the schema.

thanks,

Rajesh Vaswani

Re: Connection to a remote DB: Load hanging

adnan_rafiq — Thu, 05 Sep 2013 08:57:40 GMT

Thanks every one.

If you read my comment and related problem. I have narrowed down the

issue,

Let me clarify issue again. When Qlikview sends sql query to database, for

large table it take a lot of time to execute, mean while qlikview keep on

sending same query again and again. this cause system load to increase and

hang database or database closes all connection forcefully to avoid

database downtime.

Can you help me to make sure Qlikview don't send any other command until

the first one is returned.

and Kaushik, I am droping them as soon as data is fetched so, I am clear

about issue, when I fetch relatively small table issue don't arise. and my

database admin still tells me that its creating multiple queries on same

table

Regards