An error has occurred during report processing. (rsProcessingAborted)

Hello,
I created a team project (TFS beta 3 refresh) and all reports where correctly created. When I try to run them I get the following error message:

  • An error has occurred during report processing. (rsProcessingAborted)
    • Cannot impersonate user for data source 'TfsOlapReportDS'. (rsErrorImpersonatingUser)
      • Logon failed. (rsLogonFailed)
        • For more information about this error navigate to the report server on the local server machine, or enable remote errors

From datasource setting I am using domain\TFSREPORTS credentials which seems correctly defined into the DB.

What can I do

Thanks,
Pierre




Answer this question

An error has occurred during report processing. (rsProcessingAborted)

  • BukHix

    I've fixed it making the TFSREPORTS account Administrator of the Data Tier Server.
    It's an awfull resolution but it works, could you solved it using another nicer way


  • GDC2579

    hi, I also met the same problem, I had solved it by granting for account

    which currently report server used has Admin permission.

    please let me know you still not solved it.



  • Grandpa4075

    I also face the same problem .. could u tell me how do i go about to make the TFSREPORTS as the account administrator of Data tier server ..

    I'm new to this ..



  • Stahn

    hi alan ..

    the method u told is not working .. even thogh i made the changes as said .. i get the same error again .. what else could be the problem ...



  • guitarmanchu

    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. As a side note our install was on Windows 2003 Server RC2.
  • Aakash_AIT

    Same issue occured to me and did the same thing to get it to work.

  • posseke

    If after a day you're still seeing this, it seems likely that the warehouse processing has a problem. See this related thread.

    http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=124011&SiteID=1



  • AHADI

    By adding the TFS Reports user account to Content Managers it resolved my issue. I did not have to elevate the privileges for the TFS Reports user account on the local machine. Hope this helps....
  • PB Poonam

    The solution worked... but the wierd thing is I had everything working before I did the reinstall of TFS and only then I had this problem

  • Jerry Long

    in my case MOM DAS password changed, so i had to change it also from report web site => SCDW and from reporting service configration

  • Rudedog2

    I am seeing the same error but for projects that have been in existence for quite a while. I have been able to run reports in the past without any problems. What could have caused the problem
    I've tried re-starting the SQL reporting services on the Application tier (we have a 2 server installation of team system). I've tried granting administrator rights to the tfsreports account on the data tier.

    Any thoughts would be much appreciated.


  • MarkWHaroldson

    Has the user who is trying to access the reports been added to the "Content Managers" role on the Report Server

    You can add users to this role by doing the following:

    1. Navigate to http://<InsertReportServerHere>/Reports

    2. Click on the "properties" tab

    3. Click on "New Role Assignment"

    4. Add the appropriate group or user, and select "Content Manager"

    5. Click OK



  • Sthrudel

    I have solved it earlier .. but there was a problem in the machine and I had to do a reinstall .. everything. I reinstalled sql server 2005, sharepoint, tfs ... etc. I was able to connect and then create a Team project ... but alas .. the reports was not available. An error has occurred during report processing. (rsProcessingAborted) .. comes on the reports window ...

    I have tried all the possibilities that is mentioned above .. i could not solve it .. I couldnt figure it out .. what the problem is ...

    pls let me know on this .. i'm just going crazy on this ...

    thanx

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



  • An error has occurred during report processing. (rsProcessingAborted)