Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

jerryhnc
New Contributor III

Reload failure on server

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

2 Replies
vikasmahajan
Honored Contributor III

Re: Reload failure on server

Try to comment on section access used in QVW and try to reload again and check.

This is will help to identify whether there is problem in excel file used for section access.

Regards

Vikas

vikasmahajan
Honored Contributor III

Re: Reload failure on server

Try to comment on section access used in QVW and try to reload again and check.

This is will help to identify whether there is problem in excel file used for section access.

Regards

Vikas

Community Browser