Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to automate the reload of a qvw on the server using SBS QV 11.
It was working initially, I introduced section access and since then it is failing with the below error:
(2012-04-16 14:27:13) Information: The Source Document reload complete. DocumentPath=E:\QlikviewDocuments\Productivity\Reports\Warehouse Productivity.qvw
(2012-04-16 14:27:13) Information: Memory Allocation Delta for this file=407.32 Mb. Available Physical Memory Before Reload=29907.41 Mb. Available Physical Memory After Reload=29550.09 Mb. Total Physical Memory=29550.09 Mb.
(2012-04-16 14:27:13) Error: The Source Document was NOT reloaded successfully. DocumentPath=E:\QlikviewDocuments\Productivity\Reports\Warehouse Productivity.qvw.
(2012-04-16 14:27:13) Information: Closing the document.
(2012-04-16 14:27:14) Information: Closed the QlikView Engine successfully. ProcessID=4352
(2012-04-16 14:27:14) Error: The task "Warehouse/Reports/Warehouse.qvw" failed. Exception:
(2012-04-16 14:27:14) 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=E:\QlikviewDocuments\Warehouse\Reports\Warehouse.qvw.
(2012-04-16 14:27:14) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)
(2012-04-16 14:27:14) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2012-04-16 14:27:14) Error: --- End of inner exception stack trace ---
(2012-04-16 14:27:14) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2012-04-16 14:27:14) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2012-04-16 14:27:14) Error: --- End of inner exception stack trace ---
(2012-04-16 14:27:14) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2012-04-16 14:27:14) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
(2012-04-16 14:27:14) Information: Task Execute Duration=00:01:24.0382774
(2012-04-16 14:27:14) Information: Sending Alert mail
(2012-04-16 14:27:14) Information: TaskResult.status=Finished
(2012-04-16 14:27:14) Information: Notifying all triggers of new state:FinishedWithErrors
(2012-04-16 14:27:14) Information: Notifying all triggers of new state:FinishedWithErrors - completed
(2012-04-16 14:27:14) Information: Saving Task Result
I have checked login details anfd they are ok - the engine is accessing the document ok.
Anybody know what I can check?
Regards,
Gregg
This should work if this account is part of section access. However, you really should put the service account as part of section access.
Bill
Hi Gregg, I have had a similar issue with Qlikview server 11.2 SR3, where I could reload the qlikview file through the desktop but not through the server schedulled task. I replaced the OLEDB provider SQLNCLI10.1 in the script with SQLOLEDB.1 and after that the qlikview file now reloads on both the desktop and server. I also has section access, but this was configured correctly.