Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Dear All,
Thanks for dropping me in.
The issue was related to server performance.
PS. My SQL and QV are on the same server.
Thanks,
Robin
Nice one, glad you figured it out!
Andy
Hi Andrew,
I figured it out from the following two information lines :
Information: Physical FileSize=4.30 Mb. Memory Allocation Delta for this file=14.62 Mb
Information: Memory Allocation Delta for this file=1.04 Mb
I could rectify that the delta memory allocation was differing. Thus ended up checking the server performance and got notified that max of the utilization is taken under MYSQL.
I'm a beginner in qlikview and getting to learn such issues, means a lot !
Best Regards,
Robin