Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

asgardd2
Contributor III

Distribution service(task in managment console) can't load document.

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.

28 Replies

Re: Distribution service(task in managment console) can't load document.

What says the script-log for this application?

- Marcus

stabben23
Honored Contributor

Re: Distribution service(task in managment console) can't load document.

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.

asgardd2
Contributor III

Re: Distribution service(task in managment console) can't load document.

     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)


asgardd2
Contributor III

Re: Distribution service(task in managment console) can't load document.

Yes, this option has been enabled, and the script execution log was created

stabben23
Honored Contributor

Re: Distribution service(task in managment console) can't load document.

Can you share it here?

asgardd2
Contributor III

Re: Distribution service(task in managment console) can't load document.

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.......

Re: Distribution service(task in managment console) can't load document.

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

Re: Distribution service(task in managment console) can't load document.

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 ?

stabben23
Honored Contributor

Re: Distribution service(task in managment console) can't load document.

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).

Community Browser