Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear users,
Since a couple of days I encountered errors while reloading. It is a reload task which needs to run every 5 minutes.
The reload task was working a couple of days ago, but when a colleague of mine replaced the dashboad, the reloading tasks fails.
I tried the following things:
This is th eerror i get:
(2013-07-09 15:28:36) Information: Starting task 'SMV/SMV Qlikview.qvw'. Id:2bc0988f-509b-4c53-b255-6e176bde710b. Triggered by 'ScheduleTrigger'. Id:5e22fc51-4c7c-4cc3-8679-8a517c611ab3
(2013-07-09 15:28:36) Information: Entering Task Execution.
(2013-07-09 15:28:36) Information: ClusterID=1
(2013-07-09 15:28:36) Information: QDSID=f41df3ac-da9c-8ea2-1401-6b0f48c68800
(2013-07-09 15:28:36) Information: TaskID=2bc0988f-509b-4c53-b255-6e176bde710b
(2013-07-09 15:28:36) Information: MaxRunTime=06:00:00
(2013-07-09 15:28:36) Information: MachineName=QVS
(2013-07-09 15:28:36) Information: Max attempts:1
(2013-07-09 15:28:36) Information: Current Attempt=0
(2013-07-09 15:28:36) Information: Task Dependencies are OK
(2013-07-09 15:28:43) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
(2013-07-09 15:28:43) Information: Opening "C:\Qlikview Documents\SMV\SMV Qlikview.qvw"
(2013-07-09 15:28:43) Information: Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).
(2013-07-09 15:28:43) Information: Max retries:5
(2013-07-09 15:28:43) Information: Attempt:01
(2013-07-09 15:28:44) Information: Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=4.
(2013-07-09 15:28:44) Information: Loading document "C:\Qlikview Documents\SMV\SMV Qlikview.qvw" (16.58 Mb)
(2013-07-09 15:28:45) Information: Loading. LoadTime=00:00:01.0140017
(2013-07-09 15:28:45) Information: Physical FileSize=16.58 Mb. Memory Allocation Delta for this file=94.40 Mb. Available Physical Memory Before Open=60373.65 Mb. Available Physical Memory After Open=60263.31 Mb. Total Physical Memory=65526.21 Mb.
(2013-07-09 15:28:45) Information: Attempted to load the document without data.
(2013-07-09 15:28:45) Information: The document was loaded successfully.
(2013-07-09 15:28:45) Information: Document was opened successfully
(2013-07-09 15:28:45) Information: Starting reload
(2013-07-09 15:28:45) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.
(2013-07-09 15:28:45) Information: The Source Document is being reloaded. DocumentPath=C:\Qlikview Documents\SMV\SMV Qlikview.qvw
(2013-07-09 15:28:46) Information: Reloading.
(2013-07-09 15:28:47) Information: Reloading..
(2013-07-09 15:28:49) Information: Reloading...
(2013-07-09 15:28:50) Information: Reloading....
(2013-07-09 15:28:51) Information: Reloading.....
(2013-07-09 15:28:52) Information: Reloading......
(2013-07-09 15:28:53) Information: Reloading.......
(2013-07-09 15:28:54) Information: Reloading........
(2013-07-09 15:28:55) Information: Reloading.........
(2013-07-09 15:28:56) Information: Reloading..........
(2013-07-09 15:28:57) Information: Slow down logging. Log every <2> seconds.
(2013-07-09 15:28:57) Information: Reloading
(2013-07-09 15:28:59) Information: Reloading.
(2013-07-09 15:29:01) Information: Reloading..
(2013-07-09 15:29:03) Information: Reloading...
(2013-07-09 15:29:05) Information: Reloading....
(2013-07-09 15:29:07) Information: Reloading.....
(2013-07-09 15:29:09) Information: Reloading......
(2013-07-09 15:29:11) Information: Reloading.......
(2013-07-09 15:29:13) Information: Reloading........
(2013-07-09 15:29:15) Information: Reloading.........
(2013-07-09 15:29:17) Information: Reloading..........
(2013-07-09 15:29:19) Information: Slow down logging. Log every <10> seconds.
(2013-07-09 15:29:19) Information: Reloading
(2013-07-09 15:29:29) Information: Reloading.
(2013-07-09 15:29:39) Information: Reloading..
(2013-07-09 15:29:49) Information: Reloading...
(2013-07-09 15:29:59) Information: Reloading....
(2013-07-09 15:30:10) Information: Reloading.....
(2013-07-09 15:30:12) Information: The Source Document reload complete. DocumentPath=C:\Qlikview Documents\SMV\SMV Qlikview.qvw
(2013-07-09 15:30:12) Information: Memory Allocation Delta for this file=20.83 Mb. Available Physical Memory Before Reload=60263.27 Mb. Available Physical Memory After Reload=60261.13 Mb. Total Physical Memory=60261.13 Mb.
(2013-07-09 15:30:12) Error: The Source Document was NOT reloaded successfully. DocumentPath=C:\Qlikview Documents\SMV\SMV Qlikview.qvw.
(2013-07-09 15:30:12) Information: Closing the document.
(2013-07-09 15:30:13) Information: Closed the QlikView Engine successfully. ProcessID=3032
(2013-07-09 15:30:13) Error: The task "SMV/SMV Qlikview.qvw" failed. Exception:
(2013-07-09 15:30:13) 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:\Qlikview Documents\SMV\SMV Qlikview.qvw.
(2013-07-09 15:30:13) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)
(2013-07-09 15:30:13) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2013-07-09 15:30:13) Error: --- End of inner exception stack trace ---
(2013-07-09 15:30:13) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2013-07-09 15:30:13) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2013-07-09 15:30:13) Error: --- End of inner exception stack trace ---
(2013-07-09 15:30:13) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2013-07-09 15:30:13) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
(2013-07-09 15:30:13) Information: Task Execute Duration=00:01:37.1413693
(2013-07-09 15:30:13) Information: TaskResult.status=Finished
(2013-07-09 15:30:13) Information: Notifying all triggers of new state:FinishedWithErrors
(2013-07-09 15:30:13) Information: Notifying all triggers of new state:FinishedWithErrors - completed
(2013-07-09 15:30:13) Information: Saving Task Result
Qlikview server:
Product Information | |||
Product name | QMS Backend Core x64 | ||
Client Build Number | 11.20.11718.0 | ||
Target Platform | x64 | ||
Publisher License Key | No License | ||
Service authentication | AD groups | ||
Machine Information | |||
Computer Name | QVS | ||
Operating System Version | Win32_OperatingSystem=@ X64 (Microsoft Windows NT 6.1.7601 Service Pack 1) | ||
.NET Version | 4.0.30319.296 | ||
Physical Memory | 65526Mb | ||
Available Memory | 60257Mb |
Reload Engine:
Product Information | |||
Product name | QlikView Distribution Service x64 | ||
Client Build Number | 11.20.11718.0 | ||
Target Platform | x64 | ||
Machine Information | |||
Computer Name | QVS | ||
Operating System Version | Win32_OperatingSystem=@ X64 (Microsoft Windows NT 6.1.7601 Service Pack 1) | ||
.NET Version | 4.0.30319.296 | ||
Physical Memory | 65526Mb | ||
Available Memory | 60257Mb |
Hi,
What is showing in the document log? Can you post that here?
Did any of the file path change?
Did any ODBC connections properties change?
Bill
Hi,
Where can i find the document log?
The filepath did not change. it is in the same location. The only thing my colleague did, was the following:
in C:\Qlikview Documents\ (the root folder for the documents) the document SMV.qvw is replaced by a new SMV.qvw.
Also, no ODBC connections proprties changed.
The document log is in the same folder as the qvw. It is named the same as the qvw with a ".log" extension.
If the document log is not present, it needs to be set on in the Settings->Document Properties->General, Generate Logfile.
-Rob
I don't have the logfile.
I searched for the option you supplied, but the only thing I could find is displayed as in the screenshot below. An option "enable audit logging" is enabled.
Hi,
One of the reason could be that the user who reloads the application (May be the Admin) doesnt have the right to write the document.
Make sure that the user which is allowed to run the qlikview server services has the full access to the SMV.qvw
Regards,
Kaushik Solanki
Hi,
The user does not reload the document by itself. The Qlikview Server has a timer which reloads the document every 5 minutes. Every user is in the default qlikview user account group named "Qlikview Users".
In your application..click Settings->Document Properties->General > Generate Logfile
Hi Bika,
I am not able to post new messages in qlikcommunity it is showing "will need to be approved by a moderator before it will be viewable by others".please can you help me in this?
Thanks,
Amelia2000
Dear Nazeem,
I understand that the QlikView does the sceduling but the thing i wanted say about user is the user which is allowed to run the qlikview services should have the full access on the file.
The user which is passed when installing the server.
Regards,
Kaushik Solanki