N/APosted on - 09/01/2011
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:
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?
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.