Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have a problem with reload document through Managment Console.
I analyzed the log files, and realized that the document can not be loaded:
...
26.04.2016 05:00:01.1677710 Information Opened the QlikView Engine successfully. ProcessID=2156
26.04.2016 05:00:01.1677710 Information Allocated QlikView Engine successfully. Current usage count=2 of 4 (of type non-reader). Ticket number=3.
26.04.2016 05:00:01.1677710 Information Loading document "C:\QVProject\QVReload\reload.qvw" (0.22 Mb)
26.04.2016 05:00:02.1676968 Information Loading. LoadTime=00:00:00.9999258
26.04.2016 05:00:04.1675494 Information Loading. LoadTime=00:00:02.9997784
26.04.2016 05:00:08.1672545 Information Loading. LoadTime=00:00:06.9994835
...
26.04.2016 05:57:07.3248071 Information Loading. LoadTime=00:57:06.1570361
26.04.2016 05:58:07.3614774 Information Loading. LoadTime=00:58:06.1937064
26.04.2016 05:59:07.3662672 Information Loading. LoadTime=00:59:06.1984962
26.04.2016 06:00:11.1249927 Error Document open threw an exception. Exception=The currently executing operation was aborted.
26.04.2016 06:00:11.1249927 Information Load was aborted
26.04.2016 06:00:11.1249927 Information Closed the QlikView Engine successfully. ProcessID=2156
26.04.2016 06:00:11.1249927 Information Attempted to load the document without data.
26.04.2016 06:00:11.1249927 Error The document failed to open.
26.04.2016 06:00:11.1249927 Information Closed the QlikView Engine successfully. ProcessID=2156
26.04.2016 06:00:11.7500426 Information Closed the QlikView Engine successfully. ProcessID=2156
26.04.2016 06:00:11.7500426 Error The task "Reload of reload.qvw" failed.
...
Restart all QliKView services does not help. How can I fix this?
Full log file in attachment.
Thank you.
Best Regards,
Aleksandrov Anton.
What says the script-log for this application?
- Marcus
Hi,
can you also add a loggfile from Your Application, Settings-->Document Properties-->General-->tick Generate logfile. This will give us some more info about Your script inside the Application.
In this case, the problem does not reach the stage of restarting the document, the problem during loading application in managment console engine. Log file in this case does not have time to set up.
(Previously, it was created with a successful reboot)
Yes, this option has been enabled, and the script execution log was created
Can you share it here?
At this time, the log file is not created. (Because the task has stopped at the stage of the application loading)
...
26.04.2016 05:00:01.1677710 Information Opened the QlikView Engine successfully. ProcessID=2156
26.04.2016 05:00:01.1677710 Information Allocated QlikView Engine successfully. Current usage count=2 of 4 (of type non-reader). Ticket number=3.
26.04.2016 05:00:01.1677710 Information Loading document "C:\QVProject\QVReload\reload.qvw" (0.22 Mb)
26.04.2016 05:00:02.1676968 Information Loading. LoadTime=00:00:00.9999258
26.04.2016 05:00:04.1675494 Information Loading. LoadTime=00:00:02.9997784
26.04.2016 05:00:08.1672545 Information Loading. LoadTime=00:00:06.9994835
...
26.04.2016 05:57:07.3248071 Information Loading. LoadTime=00:57:06.1570361
26.04.2016 05:58:07.3614774 Information Loading. LoadTime=00:58:06.1937064
26.04.2016 05:59:07.3662672 Information Loading. LoadTime=00:59:06.1984962
26.04.2016 06:00:11.1249927 Error Document open threw an exception. Exception=The currently executing operation was aborted.
26.04.2016 06:00:11.1249927 Information Load was aborted
26.04.2016 06:00:11.1249927 Information Closed the QlikView Engine successfully. ProcessID=2156
26.04.2016 06:00:11.1249927 Information Attempted to load the document without data.
26.04.2016 06:00:11.1249927 Error The document failed to open.
26.04.2016 06:00:11.1249927 Information Closed the QlikView Engine successfully. ProcessID=2156
26.04.2016 06:00:11.7500426 Information Closed the QlikView Engine successfully. ProcessID=2156
26.04.2016 06:00:11.7500426 Error The task "Reload of reload.qvw" failed.
Previously in normal reload, after Loading statement should be reload statement,see example:
4/23/2016 05:00:01.2247466 Information Allocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=133.
4/23/2016 05:00:01.2247466 Information Loading document "C:\QVProject\QVReload\reload.qvw" (0.22 Mb)
4/23/2016 05:00:01.2872516 Information Physical FileSize=0.22 Mb. Memory Allocation Delta for this file=2.45 Mb. Available Physical Memory Before Open=60925.82 Mb. Available Physical Memory After Open=60922.31 Mb. Total Physical Memory=262109.27 Mb.
4/23/2016 05:00:01.2872516 Information Attempted to load the document without data.
4/23/2016 05:00:01.2872516 Information The document was loaded successfully.
4/23/2016 05:00:01.2872516 Information Document was opened successfully
4/23/2016 05:00:01.2872516 Information Starting reload
4/23/2016 05:00:01.2872516 Information QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.
4/23/2016 05:00:01.2872516 Information The Source Document is being reloaded. DocumentPath=C:\QVProject\QVReload\pharmstd загрузка данных.qvw
4/23/2016 05:00:01.2872516 Information Waiting for the document log "C:\QVProject\QVReload\reload.qvw" to become available.. Check until 4/23/2016 5:00:05 AM
4/23/2016 05:00:01.3653828 Information Found a document log. FileName=C:\QVProject\QVReload\reload.qvw.log
4/23/2016 05:00:01.3653828 Information Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20160423\050000 - Reload of reload.qvw\DocumentLog.txt
4/23/2016 05:00:02.2873306 Information Reloading.
4/23/2016 05:00:03.2874105 Information Reloading..
4/23/2016 05:00:04.2874899 Information Reloading...
4/23/2016 05:00:05.2875690 Information Reloading....
4/23/2016 05:00:06.2876485 Information Reloading.....
4/23/2016 05:00:07.2877283 Information Reloading......
4/23/2016 05:00:08.2878074 Information Reloading.......
This log wasn't meant else the log-file from the script-execution which also will be created (enabling within the document properties in tab general) if you run a manually reload . btw. what happens if run it manually?
- Marcus
What happens if you log into the server with the same AD User as the Distribution Service runs under then open and reload the qvw ?
Hi according to my knowledge, there will always be a logfile generated, even if the task is stopped or aborted.
These logfiles that we see here is generated from Publisher/server not from Application it self.
What I can see is that the task was aborted almost 1 hour from it started, problably because there was no threads free to reload the Application or some hick up in the network, very hard to say.There is a general setting that should abort if there is no free threads during a certain period (1 hour).