Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reload error - Qlikview Server

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

12 Replies
Not applicable
Author

sectionaccess.png

Bill_Britt
Former Employee
Former Employee

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

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Not applicable
Author

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.