Reload Issue

[#1]

Hi Team,

Hope you all doing good. Can anyone please look into the below log file and suggest me the issue with the reload task failure. It will be a great help for me.

(2015-06-23 06:51:54) Information: Starting task 'xyz/xyz/xyz Target Book.qvw'. Id:852ebc46-9068-4198-a789-f30951e2db5b. Triggered by 'ScheduleTrigger'. Id:d407f68e-a90e-4b09-90d2-4dd9f7c94d9f

(2015-06-23 06:51:58) Information: Entering Task Execution.

(2015-06-23 06:51:58) Information: ClusterID=1

(2015-06-23 06:51:58) Information: QDSID=94a46226-f015-cd6f-3be2-82e7418da373

(2015-06-23 06:51:58) Information: TaskID=852ebc46-9068-4198-a789-f30951e2db5b

(2015-06-23 06:51:58) Information: MaxRunTime=06:00:00

(2015-06-23 06:51:58) Information: MachineName=QLIKVIEW10

(2015-06-23 06:51:58) Information: Max attempts:1

(2015-06-23 06:51:58) Information: Current Attempt=0

(2015-06-23 06:51:58) Information: Task Dependencies are OK

(2015-06-23 06:51:58) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2015-06-23 06:51:58) Information: Opening "D:\Qlikview\xyz\xyz\xyz Target Book.qvw"

(2015-06-23 06:51:58) Information: Allocating new QlikView Engine. Current usage count=1 of 8 (of type non-reader).

(2015-06-23 06:51:58) Information: Max retries:5

(2015-06-23 06:51:58) Information: Attempt:01

(2015-06-23 06:52:01) Information: Opened the QlikView Engine successfully. ProcessID=3952

(2015-06-23 06:53:46) Information: Allocated QlikView Engine successfully. Current usage count=2 of 8 (of type non-reader). Ticket number=148.

(2015-06-23 06:53:47) Information: Loading. LoadTime=00:00:01.0096500

(2015-06-23 06:53:49) Information: Loading. LoadTime=00:00:03.0640530

(2015-06-23 06:53:53) Information: Loading. LoadTime=00:00:07.0994594

(2015-06-23 06:54:00) Information: Loading document "D:\Qlikview\xyz\xyz\xyz Target Book.qvw" (4.30 Mb)

(2015-06-23 06:54:01) Information: Loading. LoadTime=00:00:15.3278400

(2015-06-23 06:54:17) Information: Loading. LoadTime=00:00:31.6579483

(2015-06-23 06:56:26) Information: Loading. LoadTime=00:02:40.6644123

(2015-06-23 06:57:28) Information: Loading. LoadTime=00:03:42.1738190

(2015-06-23 06:59:56) Information: Loading. LoadTime=00:06:09.8914997

(2015-06-23 07:01:51) Information: Loading. LoadTime=00:08:04.7603004

(2015-06-23 07:02:31) Information: Physical FileSize=4.30 Mb. Memory Allocation Delta for this file=14.62 Mb. Available Physical Memory Before Open=8358.46 Mb. Available Physical Memory After Open=8343.45 Mb. Total Physical Memory=17499.62 Mb.

(2015-06-23 07:02:31) Information: Attempted to load the document without data.

(2015-06-23 07:02:31) Information: The document was loaded successfully.

(2015-06-23 07:02:31) Information: Document was opened successfully

(2015-06-23 07:02:31) Information: Starting reload

(2015-06-23 07:02:44) Information: Reloading.

(2015-06-23 07:02:45) Information: Reloading..

(2015-06-23 07:02:45) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

(2015-06-23 07:02:45) Information: The Source Document is being reloaded. DocumentPath=D:\Qlikview\xyz\xyz\xyz Target Book.qvw

(2015-06-23 07:02:46) Information: Reloading...

(2015-06-23 07:02:47) Information: Reloading....

(2015-06-23 07:02:48) Information: Reloading.....

(2015-06-23 07:02:49) Information: Reloading......

(2015-06-23 07:02:50) Information: Reloading.......

(2015-06-23 07:02:51) Information: Reloading........

(2015-06-23 07:02:53) Information: Reloading.........

(2015-06-23 07:02:54) Information: Reloading..........

(2015-06-23 07:02:55) Information: Slow down logging. Log every <2> seconds.

(2015-06-23 07:02:55) Information: Reloading

(2015-06-23 07:02:57) Information: Reloading.

(2015-06-23 07:02:59) Information: Reloading..

(2015-06-23 07:03:01) Information: Reloading...

(2015-06-23 07:03:03) Information: Reloading....

(2015-06-23 07:03:05) Information: Reloading.....

(2015-06-23 07:03:07) Information: Reloading......

(2015-06-23 07:03:09) Information: Reloading.......

(2015-06-23 07:03:11) Information: Reloading........

(2015-06-23 07:03:13) Information: Reloading.........

(2015-06-23 07:03:15) Information: Reloading..........

(2015-06-23 07:03:16) Information: The Source Document reload complete. DocumentPath=D:\Qlikview\xyz\xyz\xyz Target Book.qvw

(2015-06-23 07:03:16) Information: Memory Allocation Delta for this file=1.04 Mb. Available Physical Memory Before Reload=8344.51 Mb. Available Physical Memory After Reload=8341.79 Mb. Total Physical Memory=8341.79 Mb.

(2015-06-23 07:03:17) Information: Slow down logging. Log every <10> seconds.

(2015-06-23 07:03:17) Information: Reloading

(2015-06-23 07:05:08) Information: Reloading.

(2015-06-23 07:05:18) Information: Reloading..

(2015-06-23 07:05:29) Information: Reloading...

(2015-06-23 07:05:39) Information: Reloading....

(2015-06-23 07:05:49) Information: Reloading.....

(2015-06-23 07:05:57) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\Qlikview\xyz\xyz\xyz Target Book.qvw

(2015-06-23 07:06:03) Information: Closing the document.

(2015-06-23 07:08:10) Error: Could not close the SourceDocument. Exception=The currently executing operation was aborted.

(2015-06-23 07:08:10) Warning: The QlikView Engine isn't responding to close command, it will be killed (Please ignore logged errors about the kill).

(2015-06-23 07:08:10) Information: Killing the QlikView Engine. ProcessID=3952

(2015-06-23 07:08:43) Information: Closed the QlikView Engine successfully. ProcessID=3952

(2015-06-23 07:08:43) Error: The task "xyz/xyz/xyz Target Book.qvw" failed. Exception:

(2015-06-23 07:08:43) 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=D:\Qlikview\xyz\xyz\xyz Target Book.qvw.

(2015-06-23 07:08:43) Error:    at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2015-06-23 07:08:43) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-06-23 07:08:43) Error:    --- End of inner exception stack trace ---

(2015-06-23 07:08:43) Error:    at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2015-06-23 07:08:43) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-06-23 07:08:43) Error:    --- End of inner exception stack trace ---

(2015-06-23 07:08:43) Error:    at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2015-06-23 07:08:43) Error:    at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2015-06-23 07:08:43) Information: Task Execute Duration=00:16:44.5772273

(2015-06-23 07:08:43) Information: Sending Alert mail

(2015-06-23 07:08:46) Information: TaskResult.status=Finished

(2015-06-23 07:08:46) Information: Notifying all triggers of new state:FinishedWithErrors

(2015-06-23 07:08:46) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2015-06-23 07:08:46) Information: Saving Task Result

Thanks in advance.

[jonathandienst]

The document reload log will help to see why the document did not load successfully. To enable the reload log, go to Settings | Dcoument Properties and check the Generate LogFile check box. Then repeat the reload and review the log. It will be in the same folder as the qvw, with the same name with .log appended.

[#3]

Thanks for your guidance.

I have enacted as you suggested and I get the same log file. So my question is how do I find and fix the issue ?

Thanks again !

[jonathandienst]

From this you can see which line in the reload script caused the error, and some information about the error itself. Look at the last few lines of the file.

[#5]

Thanks for your input.

[awhitfield]

PS - once you have enable 'Generate Log File' in the QVW and reloaded, the new log file will be in the same folder as the QVW.

HTH - Andy

[#7]

The log at (2015-06-23 07:03:16) says the source document was realoaded successfully. However, the log at

(2015-06-23 07:05:57) says the same document couldn't be reloaded.  Did you try restarting the qds service and reattempt?

[vardhancse]

Hi,

As per the log there might be some issue with triggers, once please check the triggers

[buzzy996]

may be, u r trying to reload by opening some source document of the corresponding .qvw file,some times that will create problem.

make sure to close all the source docs and try?

[awhitfield]

Hi Robin,

post the Log file generated by the actual QVW

Andy