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

最新推荐文章于 2023-11-23 13:19:53 发布

原创最新推荐文章于 2023-11-23 13:19:53 发布 · 3.6k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #tfs

本文解决在报告处理过程中出现的执行权限不足导致的错误，包括检查数据库执行权限、更新用户密码等解决方案。

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 Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles this location may change according to your installation. here you can get clear idea of the error.