topic Re: Reloading through QV Server(QMC) took too much time!! in QlikView

Reloading through QV Server(QMC) took too much time!!

surendraj — Wed, 25 Nov 2020 16:16:04 GMT

Hello Guys,

When i am manually running a Application(.Qvw) on server its taking only 15 mins to complete, but i am reloading the task on the same qvw on QMC its taking 5 hours to run.

I tried multiple alternatives to resolve this..But no luck!!

Please help me on this..

By the way QVW is pointing to SQL SERVER to fetch the tables.

Thanks in Advance!!

--Surendra

hic‌

sunny‌

@Tresesco B

@swuehl

Re: Reloading through QV Server(QMC) took too much time!!

swuehl — Tue, 10 Oct 2017 12:50:06 GMT

Have you enabled and checked the document logs in both scenarios to see which script part takes the time?

Re: Reloading through QV Server(QMC) took too much time!!

surendraj — Tue, 10 Oct 2017 13:08:24 GMT

Thank you Stefan for quick response.

Yes..while fetching the data from Sql server it taking long time.

I have verified the dashboards for the long running issues and found a common error that all the dashboards are taking long time when trying to extract the data from the database.

Even when I checked with the Database team heard that the tables used in this dashboards is not getting inserted/updated during our job runs.so this might not be an issue.