Reporting Services Error - Team Foundation Server 2010

Posted on 2010-08-24
Last Modified: 2013-11-27

I am having an issue with Team Foundation Server 2010 and what appears to be the reporting services. I only know the bare minimum about TFS and how it works with Visual Studio so I really need some help here.

From what I understand, my client creates a new project via VS and once he completes everything and goes to browse the project portal he is presented with this error: (see attached file for actual screenshot)

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

Are you able to point me in the right direction?
Question by:kibatsu
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
  • +1
LVL 18

Expert Comment

by:Dennis Aries
ID: 33518634
According to Microsoft (Lukasz Pawlowski):
"This, unfortunately, is a known issue.  The problem is that if you are viewing the report and then you update it, there is some metadata which needs to be rebound when you press the View Report button.  This doesn't get rebound correctly.  

The solution is to navigate back to the folder containing the report and run it again."
A cause might be that the user has no access to the required reports:
*Right-Click on the report server and select properties.
*Under general select "Enable my reports folder for each user" option.
*Then select the appropriate role from the drop down list.(Remember the user you want is in this member role group)
Sometimes the problem solves itself somehow and the problem is gone in a day.


Author Comment

ID: 33518684
Hey thanks for getting back to me. Just a quick question, you say to "Right-Click on the report server and select properties."
Where would I find said "report server"?
LVL 18

Expert Comment

by:Dennis Aries
ID: 33518932
In your SQL Management Studio, connect to 'reporting services', then right-click on your server.
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

LVL 16

Expert Comment

ID: 33521725
Look at someone resolved the issue:
In our case the error turned out to be a missing permission on the reporting services user account. The reporting services account requires "Log On Locally" on the tier running reporting services. Adding the user to the administrators group also grants this permission, which could explain why that change also resolves the problem.
Also if it used to work and now it doesn't: did the user password change?
LVL 16

Expert Comment

ID: 33521966
I also found this as a workaround although it doesn't seem to work for everybody but it is worth the try. Make sure to restart the services (and if you can the server) after making this change:
Is the identity that you're using to access reports/view the project portal configured as a TFS Content Manager in Reporting Services?

Try this: go to the reporting services interface, mine is hosted here [http://<myreportserver>/Reports]

Click on the "Properties" tab.
Click on "New Role Assignment"

Add the identity you're using and assign it the TFS Content Manager role.  

Author Comment

ID: 33528878
Hey guys,

Thanks for your responses!

- I made the change and asked the user to test, but received the same error in the portal.

- Are you able to elaborate on the first answer?
- I went to that location, but there was no properties tab...
LVL 16

Expert Comment

ID: 33531564
Since you mention you couldn't find the tab I will assume that you are referring to my second post. This should help you (I extracted it from here: )  :

To grant permissions in Team Foundation Server
1.Open the Global Groups window by performing one of the following sets of steps:
If you are using Team Explorer:
1.In Team Explorer, connect to the server that is running Team Foundation Server and for which you are setting permissions.
2.Right-click the server, point to Team Foundation Server Settings, and then click Group Membership.
3.In the Global Groups window, click Server\Team Foundation Administrators, and then click Properties.
4.In Add member, click Windows User or Group, and then click Add.
5.Type the account name of the user whom you want to add to the Team Foundation Administrators group, and then click OK twice.
6.Click Close to close the Global Groups window.
If you are using the administration console for Team Foundation:
1.Open the administration console for Team Foundation.
For more information, see Open the Team Foundation Administration Console.
2.Expand the server, and then click Application Tier.
3.In the Administrative Console Users section, click Add.
4.In Add Team Foundation Server Administration Console User, type the user account that you want to add as a member of Team Foundation Administrators.
If you are not sure of the alias, click Search. You can also expand the Advanced Features section and modify the selections for Add required permissions to create collections and Add required permissions to change service accounts as best suits your operational needs and the security requirements for the user whom you are adding.
5.When you are satisfied with your selections, click OK.
6.Review the progress information in the Add Administration Console User window.
7.(Optional)When the process completes, click the link to open the log file.
8.Click Close to return to the administration console.

Author Comment

ID: 33554997
Thanks 13598,
This has already been filled out correctly, double checked to make sure.
Also just tested as Administrator and am getting the same error... maybe this isn't an authentication thing?
LVL 23

Expert Comment

ID: 33599393
If you are the TFS admin,try granting the user running the Task Burndown report , as well as the TFS service accounts the needed permissions on reporting services  and sharepoint using the TFS admin tool.

Accepted Solution

kibatsu earned 0 total points
ID: 33658583
Hey guys,
I had to get MS Support to actually investigate this for me, they managed to rectify the issue. Here is their summary.

Hi Daniel,

As we discussed in the live meeting, here is the summary of your problem and what I did in the live meeting,

1.      At the very beginning, we found the following error is reported when we accessing the reports,

processing!ReportServer_0-9!c1c!09/05/2010-20:46:33:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'dsProjectGuid'. ---> System.Data.SqlClient.SqlException: Invalid object name 'GetProjectNodeInfoFromReportFolder'.

2.      I checked the report UDL file you sent to me, and I found the report will retrieve data from SQL engine as parameters of the reports and the query for it to retrieve data is,

        SELECT TOP 1 p.ProjectNodeGUID, p.ProjectNodeName FROM
                SELECT ProjectNodeGUID, ProjectNodeName, 1 AS RowRank FROM GetProjectNodeInfoFromReportFolder(@ReportPath)
                SELECT '00000000-0000-0000-0000-000000000000' AS ProjectNodeGUID, 'missing' AS ProjectNodeName, 0 AS RowRank
) p ORDER BY p.RowRank DESC

However, when the report server tried to retrieve data from database, it found the function GetProjectNodeInfoFromReportFolder does not exist in the data source stored in report server. After checking, I found the report used shared data source TfsReportDS and TfsOlapReportDS. However, the connection string for both shared data source disappeared. I suspect that the encryption key for the reporting service was deleted and caused all encryption data lost.

3.      Then I involved TFS engineer in the case and checked the configuration of their existing environment which is similar as yours. In their environment, I found the initial catalog for data source TfsReportDS is Tfs_Warehouse and the initial catalog for data source TfsOlapReportDS is Tfs_Analysis. We re-configured the connection string and credential information. After that, the reports is back to normal and we could reports in MOSS site.

As we discussed, I will proceed to close this case, thanks for your kind assistance in this case. I hope you are overall satisfied with the service and support.

Best regards,
LVL 23

Expert Comment

ID: 33665792
Glad your problem is solved, and thanks for sharing the MS solution with us,this is why Microsoft advises to backup the Reporting services encryption key during Migration scenarios, I would consider this is a first time for me to see what could go wrong when this key is lost .
Best Of luck

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Want an individual results display div 8 41 Filesystem watcher not working 5 36
c#, case, if 4 17
Using datetime as triggers 2 18
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question