waiting status in QMC

[tyagishaila]

I have published qvw file by saving it in Documents folder on qlikview server.

but when I relaod this file on server it hangs on waiting state.

Is there any problem in script or in QMC

Thanks in advance.

[tyagishaila]

okay Thanks P

It means reload is completed.

[tyagishaila]

I don't get Tasklog.txt

[tyagishaila]

when I pressed Run button, it simply start running and after some seconds come into waiting state.

How can I know file is reloaded or not

[simospa]

No,

It means that is waiting for next scheduled reload and previous (if already done) was ok.

S.

[tyagishaila]

Thanks P, You and all others helped me out.

One more thing I want to know that,

I have 2 qvw files and 1 qvd for dashboard,

there is only 1 which should be access by user but AccessPoint show both files,

Where should I save other file, so that user cant see that.

Thanks a lot for your precious time.

[Peter_Cammaert]

Open the folder for the current date. Next, open the folder that corresponds to your task name and run time. There you'll find a TaskLog.

[tyagishaila]

k,

these are the last lines of tasklog.txt

/12/2015 14:16:35.0509983	Information	Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).
2/12/2015 14:16:35.0509983	Information	Max retries:5
2/12/2015 14:16:35.0509983	Information	Attempt:01
2/12/2015 14:16:36.7290699	Information	Opened the QlikView Engine successfully. ProcessID=3396
2/12/2015 14:16:36.7290699	Information	Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=2.
2/12/2015 14:16:36.7290699	Information	Loading document "C:\ProgramData\QlikTech\Documents\StockAvailabilityCurrentWeekReport.qvw" (27.60 Mb)
2/12/2015 14:16:36.9310600	Information	Physical FileSize=27.60 Mb. Memory Allocation Delta for this file=5.06 Mb. Available Physical Memory Before Open=6191.86 Mb. Available Physical Memory After Open=6183.86 Mb. Total Physical Memory=8191.55 Mb.
2/12/2015 14:16:36.9310600	Information	Attempted to load the document without data.
2/12/2015 14:16:36.9310600	Information	The document was loaded successfully.
2/12/2015 14:16:36.9310600	Information	Document was opened successfully
2/12/2015 14:16:36.9310600	Information	Starting reload
2/12/2015 14:16:36.9776731	Information	QlikView->Settings->Document Peferences->Generate Logfile in document is not set.
2/12/2015 14:16:36.9776731	Information	The Source Document is being reloaded. DocumentPath=C:\ProgramData\QlikTech\Documents\StockAvailabilityCurrentWeekReport.qvw
2/12/2015 14:16:37.9254728	Information	Reloading.
2/12/2015 14:16:38.9198856	Information	Reloading..
2/12/2015 14:16:39.9220671	Information	Reloading...
2/12/2015 14:16:40.9242486	Information	Reloading....
2/12/2015 14:16:41.9186614	Information	Reloading.....
2/12/2015 14:16:42.7266218	Information	The Source Document reload complete. DocumentPath=C:\ProgramData\QlikTech\Documents\StockAvailabilityCurrentWeekReport.qvw
2/12/2015 14:16:42.7266218	Information	Memory Allocation Delta for this file=94.29 Mb. Available Physical Memory Before Reload=6183.86 Mb. Available Physical Memory After Reload=6095.23 Mb. Total Physical Memory=6095.23 Mb.
2/12/2015 14:16:42.9130742	Information	Reloading......
2/12/2015 14:16:42.9596873	Information	The Source Document was reloaded successfully.
2/12/2015 14:16:42.9752250	Information	Reload finished successfully
2/12/2015 14:16:42.9752250	Information	Start saving document
2/12/2015 14:16:46.9800670	Information	Check in document: C:\ProgramData\QlikTech\Documents\StockAvailabilityCurrentWeekReport.qvw
2/12/2015 14:16:47.0111424	Information	Closing the document.
2/12/2015 14:16:47.6481881	Information	Closed the QlikView Engine successfully. ProcessID=3396
2/12/2015 14:16:47.6481881	Information	No distribution required.
2/12/2015 14:16:47.6792635	Information	Task Execute Duration=00:00:12.6593406
2/12/2015 14:16:47.6792635	Information	The task "StockAvailabilityCurrentWeekReport.qvw" finished successfully
2/12/2015 14:16:47.6792635	Information	TaskResult.status=Finished
2/12/2015 14:16:47.6792635	Information	Notifying all triggers of new state:Finished
2/12/2015 14:16:47.6792635	Information	Notifying all triggers of new state:Finished - completed
2/12/2015 14:16:47.6948012	Information	Saving Task Result

[Peter_Cammaert · Accepted solution]

You can put the other (invisible) qvw anywhere you like, as long as it's not in the Document root or any subfolder. QVS will pick up documents in the Documentroot and in any subdirectory.

You have Publisher license:

Add the new path to the Source Folders list in the System->Settings->Distribution Service->General tab.

You don't have Publisher license:

Add the new path as a mounted folder, but uncheck Browsable option for that mounted folder. No documents in that directory will be visisble in the AccessPoint.

Make sure that paths for QVW's and QVD's are adjusted accordingly in your Load Scripts.

[Peter_Cammaert]

The job completed successfully.

Another way to check for task results is in the QMC. In Status->Tasks, select your task, and open the Task details panes by clicking "Show Task Details" (top right). Select the Task History tab. Every single task execution will be listed (going back a maximum of 30 days) with the end result and how long it took to reload.

Good luck,

Peter

[tyagishaila]

Your solutions are really very helpful for me.

Thanks for such imp knowledge.