Symptom
Reporting Services Error
--------------------------------------------------------------------------------
Report Server has encountered a SharePoint error. (rsSharePointError) Get Online Help
Object reference not set to an instance of an object.
Resolution
- Launch the SQL Management Studio hosting the Sharepoint databases.
- View the mapped permissions for SSRS account configured in Reporting Services (i.e. DOMAIN\SYS-SSRS-ENV)
- Provide dbowner access for this account to the web application that the SSP and MySites is configured on. If you have created separate web applications for each SSP and MySites ensure dbowner is configured for both
Showing posts with label Sharepoint - Reporting Services. Show all posts
Showing posts with label Sharepoint - Reporting Services. Show all posts
Saturday, October 3, 2009
Monday, September 21, 2009
Server Error in '/' Application. [HttpException (0x80004005): Request timed out.]
Symptom
You receive the following when attempting to launch a large report within SQL Reporting Services in Sharepoint integrated mode + Project Server 2007:
Server Error in '/' Application.
Request timed out. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: Request timed out.
Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace: [HttpException (0x80004005): Request timed out.]
Resolution:
Extend the timeout value in the web.config file of the Sharepoint web application. Visit the web.config file located within the IIS website (e.g. c:\inetpub\www\website\80), edit the file and search (CTRL F) for "httpruntime". Modify the line from:
httpRuntime maxRequestLength="51200" /
To
httpRuntime maxRequestLength="51200" executionTimeout="9000" /
Adding the executionTimeout line will extend the default 2 minutes of generating the report to 10 minutes +
Close down your web browser and regenerate the Reporting Services Report (in my case, integrated with Project Server 2007 with Sharepoint) through the Sharepoint website/web application. The report should now be successful!
You receive the following when attempting to launch a large report within SQL Reporting Services in Sharepoint integrated mode + Project Server 2007:
Server Error in '/' Application.
Request timed out. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: Request timed out.
Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace: [HttpException (0x80004005): Request timed out.]
Resolution:
Extend the timeout value in the web.config file of the Sharepoint web application. Visit the web.config file located within the IIS website (e.g. c:\inetpub\www\website\80), edit the file and search (CTRL F) for "httpruntime". Modify the line from:
httpRuntime maxRequestLength="51200" /
To
httpRuntime maxRequestLength="51200" executionTimeout="9000" /
Adding the executionTimeout line will extend the default 2 minutes of generating the report to 10 minutes +
Close down your web browser and regenerate the Reporting Services Report (in my case, integrated with Project Server 2007 with Sharepoint) through the Sharepoint website/web application. The report should now be successful!
Subscribe to:
Posts (Atom)