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.
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.
Thanks every one.
If you read my comment and related problem. I have narrowed down the
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
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