locked
Error when calling LoadReport2 method RRS feed

  • Question

  • I get a 500 error when trying to consume the service.  Here is the soap msg I send:


    <?xml version="1.0" encoding="utf-8"?>
    <SOAP-ENV:Envelope xmlns:SOAP-ENV="xttp://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="xttp://www.w3.org/2001/XMLSchema" xmlns:SOAP-ENC="xttp://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="xttp://www.w3.org/2001/XMLSchema-instance">
     <SOAP-ENV:Body>
      <LoadReport2 xmlns="xttp://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices">
       <Report xmlns="xttp://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices">/Galactic Delivery Services/Chapter 05/QuoteReport</Report>
       <HistoryID xmlns="xttp://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices">0001-01-01T00:00:00</HistoryID>
      </LoadReport2>
     </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>


    And here is the response I get:


    <?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="xttp://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="xttp://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="xttp://www.w3.org/2001/XMLSchema"><soap:Body><soap:Fault><faultcode>soap:Server</faultcode><faultstring>System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---&gt; Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---&gt; System.NullReferenceException: Object reference not set to an instance of an object.
       at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo2&amp; executionInfo)
       at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport2(String Report, String HistoryID, ExecutionInfo2&amp; executionInfo)</faultstring><faultactor>xttp://servername:8080/reportserver/ReportExecution2005.asmx</faultactor><detail><ErrorCode xmlns="xttp://www.microsoft.com/sql/reportingservices">rsInternalError</ErrorCode><xttpStatus xmlns="xttp://www.microsoft.com/sql/reportingservices">400</xttpStatus><Message xmlns="xttp://www.microsoft.com/sql/reportingservices">An internal error occurred on the report server. See the error log for more details.</Message><HelpLink xmlns="xttp://www.microsoft.com/sql/reportingservices">xttp://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsInternalError&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=10.0.5512.0</HelpLink><ProductName xmlns="xttp://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="xttp://www.microsoft.com/sql/reportingservices">10.0.5512.0</ProductVersion><ProductLocaleId xmlns="xttp://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="xttp://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="xttp://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="xttp://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source><Message msrs:ErrorCode="rsInternalError" msrs:HelpLink="xttp://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsInternalError&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=10.0.5512.0" xmlns:msrs="xttp://www.microsoft.com/sql/reportingservices">An internal error occurred on the report server. See the error log for more details.</Message><MoreInformation><Source>ReportingServicesLibrary</Source><Message>Object reference not set to an instance of an object.</Message></MoreInformation></MoreInformation><Warnings xmlns="xttp://www.microsoft.com/sql/reportingservices" /></detail></soap:Fault></soap:Body></soap:Envelope>


    This also creates a mini dump in the logfiles directory with the error being:


    library!WindowsService_0!b28!11/02/2012-10:23:12:: i INFO: Call to CleanBatch()
    library!WindowsService_0!b28!11/02/2012-10:23:12:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings.
    library!WindowsService_0!b28!11/02/2012-10:23:12:: i INFO: Call to CleanBatch() ends
    library!ReportServer_0-2!1188!11/02/2012-10:23:32:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
     Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.NullReferenceException: Object reference not set to an instance of an object.
       at Microsoft.ReportingServices.Library.DefinitionLoader.GetParameterDefinition(CatalogItemContext itemContext, String historyId, Boolean forRendering, SecurityRequirements requirements)
       at Microsoft.ReportingServices.Library.BaseReportCatalogItem.LoadParametersForExecution(String historyId, Boolean forRendering)
       at Microsoft.ReportingServices.Library.GetDataForExecutionAction._GetDataForExecution(CatalogItemContext reportContext, ClientRequest session, String historyID, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& snapshotExecutionDate, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings, PaginationMode& paginationMode)
       at Microsoft.ReportingServices.Library.GetDataForExecutionAction.ExecuteStep(CatalogItemContext reportContext, ClientRequest session, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& executionDateTime, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings, PaginationMode& paginationMode)
       --- End of inner exception stack trace ---
    library!ReportServer_0-2!1188!11/02/2012-10:23:32:: i INFO: Exception InternalCatalogException dumped to: C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\Logfiles flags= ReferencedMemory, AllThreads, SendToWatson


    Does anyone know what this means?  Thanks so much for any help

    Friday, November 2, 2012 2:32 PM

Answers

  • Hi,

    According to your description, Reporting Services is generating dumps randomly regarding this exception:
    ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server

    Based on my research, it may be a known issue in SSRS 2005 and occasionally happens with SSRS 2008. At this time, I suggest that you update the SSRS with SQL Server updates. We can get the SQL Server versions information and updates download links from:
    Microsoft SQL Server 2008 R2 Builds

    It is always recommended that you install an update in test environment first before applying it to the production environment.

    Regards,
    Mike Yin


    Your Name

    TechNet Community Support

    • Proposed as answer by Mike Yin Thursday, November 8, 2012 6:12 PM
    • Marked as answer by Mike Yin Sunday, November 11, 2012 5:41 PM
    Monday, November 5, 2012 12:51 PM