Reporting Services Error on SharePoint Home Page

Question

Hi Ruiz,

Thank you for the help.  I am able to browse the Project Portal after followed your instructions.  However, on the home page, there is an error.

Reporting Services Error
-------------------------------------------------------------------------------- 
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'IterationParam'. (rsErrorExecutingCommand) Get Online Help
For more information about this error navigate to the report server on the local server machine, or enable remote errors
--------------------------------------------------------------------------------
SQL Server Reporting Services  

When I click on "Get Online Help", it does not give me useful information.

We're sorry

There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere.

Is there anything wrong in my Portal or its setting?  I appreciate your help.

Thank you and best regards,
Pob

Answer 1

Hi Pob,

Could you open http://servername/Reports/Pages/Folder.aspx?ItemPath=%2f<projectname> and view reports there?

It seems that the report servies setting is not correct, mostly related to the datasource(TfsOlapReportDS, and TfsReportDS) Credentials.

Best Regards,
Ruiz

---

Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Sincerely, Ruiz Yi

Answer 2

Hi Ruiz,

This is what I get when I open any reports under the site portal.

http://TFSServer/Reports/Pages/Report.aspx?ItemPath=%2fWEB-AP%2fBug+Rates
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'IterationParam'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

I have re-entered the password in the Data Source TfsOlapReportDS and TfsReportDS.  But it did not fix the issue.  What else shall I check on the TFS, please?

Pob

Answer 3

Hi Pob,

This issue seems due to Sql Server Analysis Service. 

Check whether SSAS works.
   Connect to SSAS with Sql Server Manage Studio,  expand Databases, Right click TfsWarehouse->Process->OK

 
If there is   error in processing, maybe is the cause.  If not, you can try to rebuild TfsWareHouse  http://msdn.microsoft.com/en-us/library/cc668753.aspx
 

Best Regards,
Ruiz

---

Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Sincerely, Ruiz Yi

Answer 4

Hi Ruiz,

I have run "SetupWarehouse.exe -o -s DATATIER -d TFSWarehouse -c warehouseschema.xml -ra MYDOMAIN\TFSREPORT -a MYDOMAIN\TFSSERVICE -mturl http://TFSSERVER:8080 -l d:\TFSLog.txt" to rebuild the TFS Cube, and it was completed with no error.  However I still encounter the issue

I am unable to Check whether SSAS works because my login ID cannot see "Process" menu.

Connect to SSAS with Sql Server Manage Studio,  expand Databases, Right click TfsWarehouse->Process->OK

I need to contact the DBA team to verify the SSAS for me on Monday.  I will update you as soon as I have the results.

Thank you and best regards,
Pob

Answer 5

Ruiz - do you have data in your Team Project yet?  We have a known issue that when there is no data in the warehouse (work items) you'll receive this type of an error.

---

Thanks, Aaron Bjork http://blogs.msdn.com/aaronbjork

Answer 6

Hi Ruiz & Aaron,

Sorry for the long delay.  The DBA said "SSAS service accounts did not have access to the warehouse database and that’s granted to fix the issue.".  Aaron was also right.  I got this message when I viewed some of the reports, "No data matches the parameters specified.".

Let me work on this for couple more days, if there is no issue found, I will make this post as Answer.  Is that alright?

Thank you so much for your great support.
Pob

Answer 7

Hi Pob,

If you are getting this error when there is no data in the database then you should upgrade your sql server 2008 by applying the recent patches. This is caused by some bugs which have been fixed in the patches.
If there is data in database , then also you are getting this error then you should check the roles you have made in Cube.

I hope this solves your problem.

regards
Anivesh Shandilya

Answer 8

Hi
I have been trying to install Sharepoint 2010 and SQL SERVER reporting services , so that I can see a report in the Share point site that I create .

So what I did is like I installed both SQL Server and  Share point and I granted acess to the database in the Sharepoint configuration .


but now When I set the reporting server to be in the SharePoint Integration mode and grant access to the database in the central administration.

I get the following error:

Report Server has encountered a SharePoint error. (rsSharePointError) Get Online Help
Method not found: 'System.String Microsoft.SharePoint.SPPrincipal.get_LoginName()'.

I use SQL SERVER 2008 CPT and  SharePoint Foundation 2010 . I have already installed the Add-ins for the reporting services Integration.

Any Help on this is appreciated.

Thanks