Hi there qlikview community,
A specific file that i uploaded on the server gets an error and can automaticaly reload.
I attach above the log file if someonce can figure out something out of it.
(2013-01-29 11:03:09) Information: Starting task 'Holiday Plan.qvw'. Id:28fd5bd3-f935-487b-8bd1-309e102d9ce3. Triggered by 'ScheduleTrigger'. Id:42128c80-23c9-4bbc-996a-05f3a68a0891
(2013-01-29 11:03:09) Information: Entering Task Execution.
(2013-01-29 11:03:09) Information: ClusterID=1
(2013-01-29 11:03:09) Information: QDSID=a4fc5af3-2fbd-fce4-8e1c-ee1e945d362f
(2013-01-29 11:03:09) Information: TaskID=28fd5bd3-f935-487b-8bd1-309e102d9ce3
(2013-01-29 11:03:09) Information: MaxRunTime=06:00:00
(2013-01-29 11:03:09) Information: MachineName=UKMANREPORTS01
(2013-01-29 11:03:09) Information: Max attempts:1
(2013-01-29 11:03:09) Information: Current Attempt=0
(2013-01-29 11:03:09) Information: Task Dependencies are OK
(2013-01-29 11:03:09) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
(2013-01-29 11:03:09) Information: Opening "C:\ProgramData\QlikTech\Documents\Holiday Plan.qvw"
(2013-01-29 11:03:09) Information: Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).
(2013-01-29 11:03:09) Information: Max retries:5
(2013-01-29 11:03:09) Information: Attempt:01
(2013-01-29 11:03:10) Information: Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=1087.
(2013-01-29 11:03:10) Information: Loading document "C:\ProgramData\QlikTech\Documents\Holiday Plan.qvw" (0.41 Mb)
(2013-01-29 11:03:10) Information: Physical FileSize=0.41 Mb. Memory Allocation Delta for this file=5.83 Mb. Available Physical Memory Before Open=7099.68 Mb. Available Physical Memory After Open=7091.29 Mb. Total Physical Memory=12287.55 Mb.
(2013-01-29 11:03:10) Information: Attempted to load the document without data.
(2013-01-29 11:03:10) Information: The document was loaded successfully.
(2013-01-29 11:03:10) Information: Document was opened successfully
(2013-01-29 11:03:10) Information: Starting reload
(2013-01-29 11:03:10) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.
(2013-01-29 11:03:10) Information: The Source Document is being reloaded. DocumentPath=C:\ProgramData\QlikTech\Documents\Holiday Plan.qvw
(2013-01-29 11:03:10) Information: The Source Document reload complete. DocumentPath=C:\ProgramData\QlikTech\Documents\Holiday Plan.qvw
(2013-01-29 11:03:10) Information: Memory Allocation Delta for this file=1.03 Mb. Available Physical Memory Before Reload=7091.09 Mb. Available Physical Memory After Reload=7086.43 Mb. Total Physical Memory=7086.43 Mb.
(2013-01-29 11:03:10) Error: The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\Holiday Plan.qvw.
(2013-01-29 11:03:10) Information: Closing the document.
(2013-01-29 11:03:11) Information: Closed the QlikView Engine successfully. ProcessID=4676
(2013-01-29 11:03:11) Error: The task "Holiday Plan.qvw" failed. Exception:
(2013-01-29 11:03:11) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\Holiday Plan.qvw.
(2013-01-29 11:03:11) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)
(2013-01-29 11:03:11) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2013-01-29 11:03:11) Error: --- End of inner exception stack trace ---
(2013-01-29 11:03:11) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2013-01-29 11:03:11) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2013-01-29 11:03:11) Error: --- End of inner exception stack trace ---
(2013-01-29 11:03:11) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2013-01-29 11:03:11) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
(2013-01-29 11:03:11) Information: Task Execute Duration=00:00:01.6309220
(2013-01-29 11:03:11) Information: TaskResult.status=Finished
(2013-01-29 11:03:11) Information: Notifying all triggers of new state:FinishedWithErrors
(2013-01-29 11:03:11) Information: Notifying all triggers of new state:FinishedWithErrors - completed
(2013-01-29 11:03:11) Information: Saving Task Result
,,,,,,,,,,,,,,,,,
A recon that is has something to do with the excel file that i am loading i attach this part of the code here as well :
MonthsBoundMapping:
MAPPING LOAD AbsenceMonth,
Boundaries
FROM
[..\HolidaysBoundaries.xlsx]
(ooxml, embedded labels, table is Sheet1);
I dont have section access in the document and I can reload with QV Desktop App
Probably its the path but i tried many thing and can see to get it working.
Any ideas????
