Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Object reference not set to an instance of an object

Status
Not open for further replies.

JustinEzequiel

Programmer
Jul 30, 2001
1,192
PH
Yesterday when we came in, all reports on our server show the error.
Last week, everything was fine.

Have tried google and got hits re the web.config files.
But checking vs my local installation show no difference re these files.

What could we try besides reinstalling? Can we reinstall just SSRS?

In addition, the stylesheets on the server seem trashed too.
See screenshots in
Thanks in advance.

Code:
Server Error in '/Reports' Application.
--------------------------------------------------------------------------------

Object reference not set to an instance of an object. 
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.NullReferenceException: Object reference not set to an instance of an object.

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: 


[NullReferenceException: Object reference not set to an instance of an object.]
   Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces) +18
   Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e) +326
   Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +482
   Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +924
   Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +84
   Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +153
   Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +75
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

 


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

log follows

Code:
w3wp!ui!1!1/15/2008-12:46:39:: Unhandled exception: System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces)
   at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)
   at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
   at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
   at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
   at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
w3wp!ui!5!1/15/2008-15:18:29:: Unhandled exception: System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces)
   at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)
   at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
   at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
   at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
   at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
w3wp!ui!5!1/15/2008-15:21:10:: Unhandled exception: System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces)
   at Microsoft.Reporting.WebForms.WebRequestHelper.ExceptionFromWebResponse(Exception e)
   at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
   at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
   at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
   at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
 
Reinstalled SSRS at the server and all seems OK.
Just hoping somebody knows what could have happened at the server over the weekend so that this problem wont resurface.
Reinstallation was not straightforward.
Needed to
1. turn off IIS Admin,
2. Remove SSRS via Add-Remove Control Panel.
3. Delete databases and RSExecRole via Management Studio,
4. Delete RS log files
5. Install SSRS using SQL Server installer.
6. Re-configure SSRS.


 
I had a look at this when you 1st posted but unfortunately could not offer any help. The problem is that message "Object reference not set to an instance of an object" is a very generic error message that could mean all sorts of things - I have seen it before both in the VS designer and in the Web Based Report Manager.

In the instance of it occuring in the Report Manager, I re-deployed the report that was causing the error message which fixed the issue.
When it occured in the VS designer, I had to re-create the report from an earlier version. As far as I can tell, it seems to be caused by a generic "corruption" but there seems to be little rhyme or reason as to WHY it corrupts

I have never seen it cause the type of corruption displayed in your screen shots however which is why I didn't comment before



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Thanks for the reply.
Forgot to note that I had tried re-deploying (several times) to no avail.
From suggestions found via google,
I had also tried deleting the folder where the reports were located then re-deploying. Had even tried deleting then re-creating the Data Sources folder. All for naught.
I just hope it does not recur in an unfortunate time.
I can re-install SSRS and re-deploy my reports but I cannot re-deploy my colleagues' reports.
Thanks again for your time.
 
If it's any comfort, I have only had this happen 2 or 3 times in the 2 1/2 years I have been using RS and it has only ever been at individual report level. As I mentioned, the generic nature of the error message means that it is hard to track down any specific cause....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
> this happen 2 or 3 times in the 2 1/2 years

What's testing my confidence in SSRS is we've only had SQL Server+SSRS+others installed and running for about 6 weeks before the problem surfaced.

Anyway, I hope this wont recur anytime soon.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top