How does one debug server reload issues? Listed below are the log trace statements from the server (the desktop reload works fine). Perhaps it is an authorization issue. I read another post that the Windows Service user must be defined to access the SQL Server database. Can I specify a different user to access the SQL Server database to reload?
(2013-04-29 16:44:24) Information: The Source Document reload complete. DocumentPath=C:\ProgramData\QlikTech\Documents\MD Ratings v3.qvw(2013-04-29 16:44:24) Information: Memory Allocation Delta for this file=83.89 Mb. Available Physical Memory Before Reload=11694.21 Mb. Available Physical Memory After Reload=11615.14 Mb. Total Physical Memory=11615.14 Mb.
(2013-04-29 16:44:25) Error: The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\MD Ratings v3.qvw. (2013-04-29 16:44:25) Information: Closing the document.
(2013-04-29 16:44:25) Information: Closed the QlikView Engine successfully. ProcessID=5300
(2013-04-29 16:44:25) Error: The task "MD Ratings v3.qvw" failed. Exception:
(2013-04-29 16:44:25) 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:\ProgramData\QlikTech\Documents\MD Ratings v3.qvw.
(2013-04-29 16:44:25) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)
(2013-04-29 16:44:25) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2013-04-29 16:44:25) Error: --- End of inner exception stack trace ---
(2013-04-29 16:44:25) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)
(2013-04-29 16:44:25) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2013-04-29 16:44:25) Error: --- End of inner exception stack trace ---
(2013-04-29 16:44:25) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)
(2013-04-29 16:44:25) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
(2013-04-29 16:44:25) Information: Task Execute Duration=00:00:33.5866095
(2013-04-29 16:44:25) Information: TaskResult.status=Finished
(2013-04-29 16:44:25) Information: Notifying all triggers of new state:FinishedWithErrors
(2013-04-29 16:44:25) Information: Notifying all triggers of new state:FinishedWithErrors - completed
(2013-04-29 16:44:25) Information: Saving Task Result
