SharePoint server 2010 report processing error

Asked By beb_ema 0 points N/A Posted on - 09/01/2011

Hi everyone,

I am working in SharePoint Server 2010 environment for my daily administrative tasks but unfortunately I received this message by the SQL server reporting services:

Error:

An error occurred during local report processing. Query execution failed for dataset default. For more information about this error navigate to the report server on the local server machine, or enable remote errors

Can you please help me to navigate to the report server?

Where is it located and how can I avoid this error in the future?

Thanks.

• Status: Open
• Question Views: 2050
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SharePoint

Answered By Techyvexpert 0 points N/A #120428

SharePoint server 2010 report processing error

The problem here is that a metadata is not rebounded properly when you are viewing an error. You can go back to the folder and run it again. You can also enable remote errors by going to ReportsDB and selecting dbo.ConfigurationInfo.

Open this table and change the value of EnableRemoteErrors to True then execute SQL again.

This error could also be telling you that you do not have fresh data, and you need to refresh it.

Go to http://<servername>:8080/Warehouse/v1.0/warehousecontroller.asmx.

Look for GetWarehouseStatus and click then choose Invoke.

The result should be Idle. Now go to the ControllerServive page and the on Run. Choose Invoke in the next window.

The return should be True. Check on the GetWarehouse status every now-and-then until it returns to Idle.

The Report Manger will give a feedback when it is done.

You can go back to your work again.

About Techyvexpert

Questions
0

Answers
50

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 10/10/2011
• Question Category: MS SharePoint