2 Replies Latest reply: Feb 1, 2013 4:32 AM by Nikolaos Kavroulakis RSS

    Qlikview server - File reload problem

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