topic Re: Sudden increase reload time in QlikView

Sudden increase reload time

tyagishaila — Thu, 13 Aug 2015 10:44:52 GMT

Hi Community members,

Till yesterday which qvw files were taking 20 -30 sec to relaod at QMC,

suddenly those files are taking 4 to 5 hours to relaod.

What can be the reason and solution of this?

Re: Sudden increase reload time

tyagishaila — Thu, 13 Aug 2015 10:47:15 GMT

log file is showing

8/13/2015 15:54:02.9710912	Information	Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20150813\155401 - QVDGenerator_BTF_Displayall_HighImpact.qvw\DocumentLog.txt
8/13/2015 15:54:03.8759492	Information	Reloading.
8/13/2015 15:54:04.8900142	Information	Reloading..
8/13/2015 15:54:05.9065794	Information	Reloading...
8/13/2015 15:54:06.9319458	Information	Reloading....
8/13/2015 15:54:07.9460108	Information	Reloading.....
8/13/2015 15:54:08.9600758	Information	Reloading......
8/13/2015 15:54:09.9741408	Information	Reloading.......
8/13/2015 15:54:10.9882058	Information	Reloading........
8/13/2015 15:54:12.0010712	Information	Reloading.........
8/13/2015 15:54:13.0151362	Information	Reloading..........
8/13/2015 15:54:14.0292012	Information	Slow down logging. Log every <2> seconds.
8/13/2015 15:54:14.0292012	Information	Reloading
8/13/2015 15:54:16.0561316	Information	Reloading.
8/13/2015 15:54:18.0842616	Information	Reloading..
8/13/2015 15:54:20.1123916	Information	Reloading...
8/13/2015 15:54:22.1275218	Information	Reloading....
8/13/2015 15:54:24.1556518	Information	Reloading.....
8/13/2015 15:54:26.1706810	Information	Reloading......
8/13/2015 15:54:28.1920112	Information	Reloading.......
8/13/2015 15:54:30.2201412	Information	Reloading........
8/13/2015 15:54:32.2395710	Information	Reloading.........
8/13/2015 15:54:34.2677010	Information	Reloading..........
8/13/2015 15:54:36.2958310	Information	Slow down logging. Log every <10> seconds.
8/13/2015 15:54:36.2958310	Information	Reloading
8/13/2015 15:54:46.4226825	Information	Reloading.
8/13/2015 15:54:56.5540325	Information	Reloading..
8/13/2015 15:55:06.6728815	Information	Reloading...
8/13/2015 15:55:16.8017313	Information	Reloading....
8/13/2015 15:55:26.9330813	Information	Reloading.....
8/13/2015 15:55:37.0682321	Information	Reloading......
8/13/2015 15:55:47.1906829	Information	Reloading.......
8/13/2015 15:55:57.3170325	Information	Reloading........
8/13/2015 15:56:07.4171805	Information	Reloading.........
8/13/2015 15:56:17.5716321	Information	Reloading..........
8/13/2015 15:56:27.7160829	Information	Slow down logging. Log every <60> seconds.
8/13/2015 15:56:27.7160829	Information	Reloading
8/13/2015 15:57:28.4316812	Information	Reloading.
8/13/2015 15:58:29.2192839	Information	Reloading..
8/13/2015 15:59:29.9653835	Information	Reloading...
8/13/2015 16:00:30.6835819	Information	Reloading....
8/13/2015 16:01:31.4602836	Information	Reloading.....
8/13/2015 16:02:32.2304853	Information	Reloading......
8/13/2015 16:03:32.9545832	Information	Reloading.......
8/13/2015 16:04:33.7585865	Information	Reloading........
8/13/2015 16:05:34.4798836	Information	Reloading.........
8/13/2015 16:06:35.2339838	Information	Reloading..........
8/13/2015 16:07:36.0215852	Information	Slow down logging. Log every <300> seconds.
8/13/2015 16:07:36.0215852	Information	Reloading
8/13/2015 16:12:39.7041796	Information	Reloading.

Re: Sudden increase reload time

avinashelite — Thu, 13 Aug 2015 10:47:41 GMT

check whether your service are up and running and check the server RAM usage ...if some other qvw are consuming the RAM it will effect the other reloads also... check the data size too

Re: Sudden increase reload time

tyagishaila — Thu, 13 Aug 2015 10:50:46 GMT

Thanks for quick reply,

7 GB RAM is using and parallely no other qvw is running.

This problem is suddenly start since yesterday afternoon, and all documents are taking a lot time to relaod.

Please help me out

Re: Sudden increase reload time

Thu, 13 Aug 2015 10:54:11 GMT

It could be due to the database itself having some issue, or network problem. However, did you try reloading the application in the development environment? If it reloads fast then the problem lies with the infrastructure that links to the application. However if not, then if would be worth to check conditions like date ranges and volume of data loaded in.

Re: Sudden increase reload time

tyagishaila — Thu, 13 Aug 2015 11:03:04 GMT

Thanks Gayan,

Yes I did reloading in development environment also, it also took a lot time.

This problem is happening with all qlikview documents suddenly, what can be the reason of this?

Re: Sudden increase reload time

Thu, 13 Aug 2015 11:10:27 GMT

Can you try disabling all the QVWs and then running them one-by-one? Check if that helps the QVWs to run faster. It could be a resource conflict. I once faced it with the QMC and disabling and then enabling one-by-one helped to overcome the problem. Perhaps right now you must be having many QVWs trying to run in the QMC.

Re: Sudden increase reload time

nagarjuna_kotha — Thu, 13 Aug 2015 11:15:08 GMT

Hi,

Restart the all services and check. Your problem will solve.

Re: Sudden increase reload time

tyagishaila — Thu, 13 Aug 2015 11:20:54 GMT

I am reloading single qvw at a time, while earlier many qvws was relaoding simultaneously and relaod time was in seconds.

Thanks,

Re: Sudden increase reload time

tyagishaila — Thu, 13 Aug 2015 11:26:49 GMT

Hi nagarjuna,

many times i have restarted.

what does the mean of

Slow down logging. Log every <300> seconds.

all qvws have same log files

Slow down logging. Log every <10> seconds

Slow down logging. Log every <60> seconds

Slow down logging. Log every <300> seconds

Re: Sudden increase reload time

ajaykumar1 — Thu, 13 Aug 2015 11:32:53 GMT

Hi,

The above timing shows the your script trying to fetch the data(I guess) and this is seems not a problem.

Try one thing :

Please do the comparison of log files between the date which taken 20-30 mins and 4-5 Hrs. Then you will come to know that is there any data records has been increased or some thing else.

On the other hand, The memory allocated at the DB side is as usual every day But the No. of hits/usage of the tables(which are used in qlikview) also used by other applications or users.

Please check with DB team also is their any other activities done than the normal days.

One more thing please check if in case any jobs are in"aborting" state in QMC.

Thanks,

Ajay

Re: Sudden increase reload time

tyagishaila — Thu, 13 Aug 2015 11:42:22 GMT

Thanks Ajay,

Could you explain the meaning of following line,

Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).

Re: Sudden increase reload time

ajaykumar1 — Thu, 13 Aug 2015 11:44:59 GMT

Hi,

Am not sure about the error. Please check the thread if its similar.

https://community.qlik.com/thread/69710

THanks,

Ajay

Re: Sudden increase reload time

sasiparupudi1 — Thu, 13 Aug 2015 12:45:05 GMT

Please check if the folders have been renamed or moved

check if the virus scanner is running

try manually reloading the document

you can enable the file log: Settings > Document Properties > General > Generate log file. this log file will be saved in the same folder where the qvw is stored. This log is more detailed, because it will display line per line the script that is being executed.

hth

Sasi

Re: Sudden increase reload time

maxgro — Thu, 13 Aug 2015 12:53:44 GMT

post the document log file (same folder as .qvw)

or, if not enabled, enabled it (see Sasidhar answer) and reload

the log you posted is the task log and, sometimes, there is too little information in the task log to understand why

Re: Sudden increase reload time

tyagishaila — Thu, 13 Aug 2015 13:04:49 GMT

Thankyou so much for information reply.

Log file only clears error part, but there is no error. In Log file no information related why qvwfile is taking so much time to relaod.

Issue is relaod starts taking a lot time,both in QMC and in development environment also.