locked
Getting Error on one node of cluster: Object reference not set to an instance of an object. RRS feed

  • Question

  • We have a SQL 2005 SP1 cluster that is also hosting Reporting Services.  On one of the nodes when accessing reporting services we get a "Object reference not set to an instance of an object." error when running a report, the Export and Search tool bar options also show.

    We get this entry in the ReportServerWebApp log:

       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!b!12/11/2006-10:46:18:: Unhandled exception: System.NullReferenceException: Object reference not set to an instance of an object.
       at Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInformationNode(XmlNode moreInfo, XmlNamespaceManager namespaces)

     

    And this entry in the Application event log:

    Event Type: Warning
    Event Source: ASP.NET 2.0.50727.0
    Event Category: Web Event
    Event ID: 1309
    Date:  12/11/2006
    Time:  10:54:53 AM
    User:  N/A
    Computer: FISCMMKLCS1WIN
    Description:
    Event code: 3005
    Event message: An unhandled exception has occurred.
    Event time: 12/11/2006 10:54:53 AM
    Event time (UTC): 12/11/2006 3:54:53 PM
    Event ID: 13122b2f20054a3c94c3f473beb2f5df
    Event sequence: 233
    Event occurrence: 14
    Event detail code: 0
     
    Application information:
        Application domain: /LM/W3SVC/1/root/Reports-1-128103247933638626
        Trust level: RosettaMgr
        Application Virtual Path: /Reports
        Application Path: E:\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager\
        Machine name: FISCMMKLCS1WIN
     
    Process information:
        Process ID: 1560
        Process name: w3wp.exe
        Account name: NT AUTHORITY\NETWORK SERVICE
     
    Exception information:
        Exception type: NullReferenceException
        Exception message: Object reference not set to an instance of an object.
     
    Request information:
        Request URL: http://fiscmmklcs1win/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.2047.00
        Request path: /Reports/Reserved.ReportViewerWebControl.axd
        User host address: 10.33.81.105
        User: DMN1\a120882
        Is authenticated: True
        Authentication Type: Negotiate
        Thread account name: NT AUTHORITY\NETWORK SERVICE
     
    Thread information:
        Thread ID: 14
        Thread account name: NT AUTHORITY\NETWORK SERVICE
        Is impersonating: True
        Stack trace:    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)
     
     
    Custom event details:

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

     

     

    Monday, December 11, 2006 4:16 PM