Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
asgardd2
Creator III
Creator 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
asgardd2
Creator III
Creator III
Author

0.22 MB - because this is a little extractor of data.

It happens to all files qvw, through QliKView desktop  it reload and save correctly.

There are not create Documentlog.txt file then i start task in managment console,because i do not have a string about this in taskLog, like this:


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



I think, that i have a debuf logging in settings:

Peter_Cammaert
Partner - Champion III
Partner - Champion III

There won't be a document log because the document log is only generated when the script starts executing. Your documents never reach that phase because they fail to load in RAM.

If you have a Publisher, look in the Distribution Service->General->Settings area. If you do not have a Publisher, edit C:\ProgramData\QlikTech\DistributionService\Configuration.xml andd set all LogItem attributes to true for LogLevel=Debug and check the EventLog after the next reload.

Peter

Peter_Cammaert
Partner - Champion III
Partner - Champion III

If your reload generates an exception, you may find additional details in the Windows events logs.

asgardd2
Creator III
Creator III
Author

Do you mean event log files in "C:\ProgramData\QlikTech\QlikViewServer" folder ?

I switch to enable option Debug loging. (my server with Publisher)

Peter_Cammaert
Partner - Champion III
Partner - Champion III

No, if you have a Publisher, then the standard logs will do as messages will be streamed to log files as well. IF you don't have a Publisher license, the configuration is different.

If you start the reload task for the small extraction document, do you get more details in the TaskLog?.

asgardd2
Creator III
Creator III
Author

No, i don't have more details.

26.04.2016 14:18:44.0826080    Information    Starting task 'Reload of Sales.qvw'. Id:843affdd-50ac-4da5-81c0-df6b18dbb793. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

26.04.2016 14:18:44.0826080    Information    Entering Task Execution.

26.04.2016 14:18:44.0826080    Information    ClusterID=1

26.04.2016 14:18:44.0826080    Information    QDSID=aed83b64-e5c9-39c0-3c69-c7dd998446ea

26.04.2016 14:18:44.0826080    Information    TaskID=843affdd-50ac-4da5-81c0-df6b18dbb793

26.04.2016 14:18:44.0826080    Information    MaxRunTime=02:00:00

26.04.2016 14:18:44.0826080    Information    MachineName=QV2

26.04.2016 14:18:44.0826080    Information    Max attempts:2

26.04.2016 14:18:44.0826080    Information    Current Attempt=0

26.04.2016 14:18:44.0826080    Information    Task Dependencies are OK

26.04.2016 14:18:44.0982325    Information    Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

26.04.2016 14:18:44.0982325    Information    Opening "C:\QVProject\QVApps\Sales.qvw"

26.04.2016 14:18:44.0982325    Information    Allocating new QlikView Engine. Current usage count=2 of 4 (of type non-reader).

26.04.2016 14:18:44.0982325    Information    Max retries:5

26.04.2016 14:18:44.0982325    Information    Attempt:01

26.04.2016 14:18:44.5826432    Information    Opened the QlikView Engine successfully. ProcessID=1352

26.04.2016 14:18:44.5826432    Information    Allocated QlikView Engine successfully. Current usage count=3 of 4 (of type non-reader). Ticket number=7.

26.04.2016 14:18:44.5826432    Information    Loading document "C:\QVProject\QVApps\Sales.qvw" (2289.52 Mb)

26.04.2016 14:18:45.5827186    Information    Loading. LoadTime=00:00:01.0000754

26.04.2016 14:18:47.5828660    Information    Loading. LoadTime=00:00:03.0002228

26.04.2016 14:18:51.5831609    Information    Loading. LoadTime=00:00:07.0005177

26.04.2016 14:18:59.5837508    Information    Loading. LoadTime=00:00:15.0011076

26.04.2016 14:19:15.5879414    Information    Loading. LoadTime=00:00:31.0052982

...

26.04.2016 15:13:52.9786032    Information    Loading. LoadTime=00:55:08.3959600

26.04.2016 15:14:53.0469122    Information    Loading. LoadTime=00:56:08.4642690

26.04.2016 15:15:53.1953706    Information    Loading. LoadTime=00:57:08.6127274

26.04.2016 15:16:53.4511880    Information    Loading. LoadTime=00:58:08.8685448

Also, I find Error in log file named Cluster_250160426:

26.04.2016 14:18:44.0669818    Error    Failed to read from C:\ProgramData\QlikTech\DistributionService\TaskResults\TaskResult_843affdd-50ac-4da5-81c0-df6b18dbb793.xml. Exception=System.FormatException: String was not recognized as a valid DateTime.

  at System.DateTime.Parse(String s)

  at QDSMain.TaskResult.ReadXml(XmlReader reader)

  at QDSMain.Clustering.ClusterFileHandler.Read(Action`1 readXML)

Peter_Cammaert
Partner - Champion III
Partner - Champion III

How much free space does your C:-drive have?

asgardd2
Creator III
Creator III
Author

More then 20 GB

asgardd2
Creator III
Creator III
Author

I rebooted the server, and it solved the problem. Now everything is reloaded correctly.

Thanks to all!