2 Replies Latest reply: Apr 30, 2013 1:34 AM by vikas mahajan RSS

    Reload failure on server

    Jerry Helms

      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