Qlikview server - File reload problem

Tue, 29 Jan 2013 11:41:29 GMT

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

Re: Qlikview server - File reload problem

Gysbert_Wassenaar — Tue, 29 Jan 2013 14:10:33 GMT

(2013-01-29 11:03:10) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

If you change the setting Generate Logfile in the document properties of the qvw document, you'll get a log file in the same directory the .qvw file lives in. That logfile should give you more information on where the reload broke down.

And make sure your excel file is also on the server and in the location the document expects it.

Re: Qlikview server - File reload problem

Fri, 01 Feb 2013 09:32:45 GMT

Thanks a ton for the help it was the a filepath issue. Solved it now

topic Re: Qlikview server - File reload problem in QlikView

Qlikview server - File reload problem

Re: Qlikview server - File reload problem

Re: Qlikview server - File reload problem