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.
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:
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
If your reload generates an exception, you may find additional details in the Windows events logs.
Do you mean event log files in "C:\ProgramData\QlikTech\QlikViewServer" folder ?
I switch to enable option Debug loging. (my server with Publisher)
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?.
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)
How much free space does your C:-drive have?
More then 20 GB
I rebooted the server, and it solved the problem. Now everything is reloaded correctly.