[tfs] report issue: An error has occurred during report processing.

Issue:

An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'dsIteration'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors

How to fix:

1. This Error will pop up if the Dataset has the insufficient execute permission. Check that database your are using and give the execute permission if not.

Open Sql Server Mgmt Studio(SSMS) and log in through the user you are trying to access the report. Run the SQL Query in SSMS and make sure there is no error while running the script.

2. Update user password: Go to home page http://[servername]/Reports/Pages/Folder.aspx?ViewMode=List to change data source password to make sure it can connect to db.

Note: Report log file of report server. C:Program FilesMicrosoft SQL ServerMSRS10_50.MSSQLSERVERReporting ServicesLogFiles this location may change according to your installation. here you can get clear idea of the error.

最后

以上就是轻松手链为你收集整理的[tfs] report issue: An error has occurred during report processing.的全部内容，希望文章能够帮你解决[tfs] report issue: An error has occurred during report processing.所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。