Reload failed with the below error message when executed a task from Publisher. The same QVW file reloaded successfully when executed manually from Desktop.
Example Error:
Error: The task "Reload of Database\SQL\QVW\TEST.qvw" failed. Exception:
(2013-09-27 19:33:24) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.SourceDocumentNotFoundException: Could not find SourceDocument (Distribution): H:\SalesDashboard\SQL\QVW\TEST.qvw
(2013-09-27 19:33:24) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2013-09-27 19:33:24) Error: --- End of inner exception stack trace ---(2013-09-27 19:33:24) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2013-09-27 19:33:24) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
If looked at the example error, you will noticed that Publisher was not able to access
Database folder.
"Reload of Database\SQL\QVW\TEST.qvw" failed. Exception:
(2013-09-27 19:33:24) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.SourceDocumentNotFoundException: Could not find SourceDocument (Distribution): H:\SalesDashboard\SQL\QVW\TEST.qvw"
Possible solutions:
- Verify that the services account has read\write access to the QVW document location.
- Rename the folder or change the QVW file path.