none
Undefined Input string error RRS feed

  • Question

  • I am running a subreport tied to a report and both work fine seperatly. This is SQL Server 2005 SP1 installed.  I get the following error when I put the two together

    Input string was not in a correct format.

    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.FormatException: Input string was not in a correct format.

    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:

    [FormatException: Input string was not in a correct format.] System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +2725283 System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +102 Microsoft.Reporting.WebForms.ReportAreaPageOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +149 Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +75 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +303 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64 


    Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832 
     

    Below in the Debug Information
  • An internal error occurred on the report server. See the error log for more details.
  •  

  • Version=131072
    General_AppName=w3wp.exe
    UI LCID=1033
    EventType=SQL90Exception
    P1=w3wp.exe
    P2=6.0.3790.1830
    P3=42435BE1
    P4=ReportingServicesNativeClient.ni.dll
    P5=2005.90.1399.0
    P6=434F5CF3
    P7=0
    P8=00005253
    P9=00000000
    FilesToKeep=C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\SQLDmpr0238.mft|C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\SQLDmpr0238.mdmp|C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\SQLDmpr0238.log
    ReportingFlags=370
    UIFlags=1
    LoggingFlags=4
    EventLogSource=SQLDUMPER
  •  

    <) 


    w3wp!library!1!8/11/2008-13:00:53:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    w3wp!library!a!08/11/2008-13:08:55:: i INFO: Call to GetPermissions:/
    w3wp!library!a!08/11/2008-13:08:55:: i INFO: Call to GetSystemPermissions
    w3wp!library!a!08/11/2008-13:08:56:: i INFO: Call to GetPermissions:/CBizReports
    w3wp!library!a!08/11/2008-13:08:56:: i INFO: Call to GetSystemPermissions
    w3wp!library!a!08/11/2008-13:08:58:: i INFO: Call to GetPermissions:/CBizReports/rptRequirements Summary by Status  Sales
    w3wp!library!a!08/11/2008-13:08:58:: i INFO: Call to GetSystemPermissions
    w3wp!library!a!08/11/2008-13:08:59:: i INFO: Call to RenderFirst( '/CBizReports/rptRequirements Summary by Status  Sales' )
    w3wp!processing!a!08/11/2008-13:09:00:: a ASSERT: Assertion failed!   Call stack:
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteVariant(Object variant, Boolean convertDBNull) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteScopeTableValues(Object value) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteScopeTableValues(Object value) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteScopeTableValues(Object value) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteScopeTableValues(Object value) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteScopeLookupTable(ScopeLookupTable scopeTable) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteSubReport(SubReport subReport) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteReportItem(ReportItem reportItem) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteReportItemList(ReportItemList reportItems) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteReportItemCollection(ReportItemCollection reportItems) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteTableRow(TableRow tableRow) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteTableRowList(TableRowList rows) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteTableDetail(TableDetail tableDetail) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteTable(Table table) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteDataRegion(DataRegion dataRegion) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteReportItem(ReportItem reportItem) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteReportItemList(ReportItemList reportItems) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteReportItemCollection(ReportItemCollection reportItems) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteReport(Report report) 
     Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteReportSnapshot(ReportSnapshot reportSnapshot) 
     Microsoft.ReportingServices.ReportProcessing.ChunkManager+SnapshotChunkManager.SaveReportSnapshot(ReportSnapshot reportSnapshot) 
     Microsoft.ReportingServices.ReportProcessing.ProcessingResult.Save() 
     Microsoft.ReportingServices.Library.DatabaseSessionStorage.SetSessionData(SessionReportItem sessionReport, ConnectionManager connectionManager) 
     Microsoft.ReportingServices.Library.DatabaseSessionStorage.SetSessionData(SessionReportItem sessionReport) 
     Microsoft.ReportingServices.Library.DatabaseSessionStorage.SetSessionData(SessionReportItem sessReport, Boolean async) 
     Microsoft.ReportingServices.Library.SessionReportItem.Save(SaveAction saveFlags, Boolean forceSync) 
     Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile) 
     Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters) 
     Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) 
     Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute() 
     Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() 
     Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) 
     Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) 
     Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation) 
     Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType) 
     Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() 
     Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() 
     Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context) 
     System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 
     System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 
     System.Web.HttpApplication+ApplicationStepManager.ResumeSteps(Exception error) 
     System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) 
     System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) 
     System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) 
     System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) 

    w3wp!library!a!08/11/2008-13:09:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing;
     Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.

    w3wp!library!1!8/11/2008-13:00:53:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams

    w3wp!library!a!08/11/2008-13:08:55:: i INFO: Call to GetPermissions:/

    w3wp!library!a!08/11/2008-13:08:55:: i INFO: Call to GetSystemPermissions

    w3wp!library!a!08/11/2008-13:08:56:: i INFO: Call to GetPermissions:/CBizReports

    w3wp!library!a!08/11/2008-13:08:56:: i INFO: Call to GetSystemPermissions

    w3wp!library!a!08/11/2008-13:08:58:: i INFO: Call to GetPermissions:/CBizReports/rptRequirements Summary by Status  Sales

    w3wp!library!a!08/11/2008-13:08:58:: i INFO: Call to GetSystemPermissions

    w3wp!library!a!08/11/2008-13:08:59:: i INFO: Call to RenderFirst( '/CBizReports/rptRequirements Summary by Status  Sales' )

    w3wp!processing!a!08/11/2008-13:09:00:: a ASSERT: Assertion failed!   Call stack:

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteVariant(Object variant, Boolean convertDBNull) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteScopeTableValues(Object value) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteScopeTableValues(Object value) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteScopeTableValues(Object value) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteScopeTableValues(Object value) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteScopeLookupTable(ScopeLookupTable scopeTable) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteSubReport(SubReport subReport) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteReportItem(ReportItem reportItem) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteReportItemList(ReportItemList reportItems) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteReportItemCollection(ReportItemCollection reportItems) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteTableRow(TableRow tableRow) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteTableRowList(TableRowList rows) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteTableDetail(TableDetail tableDetail) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteTable(Table table) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteDataRegion(DataRegion dataRegion) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteReportItem(ReportItem reportItem) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteReportItemList(ReportItemList reportItems) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteReportItemCollection(ReportItemCollection reportItems) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteReport(Report report) 

                Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.WriteReportSnapshot(ReportSnapshot reportSnapshot) 

                Microsoft.ReportingServices.ReportProcessing.ChunkManager+SnapshotChunkManager.SaveReportSnapshot(ReportSnapshot reportSnapshot) 

                Microsoft.ReportingServices.ReportProcessing.ProcessingResult.Save() 

                Microsoft.ReportingServices.Library.DatabaseSessionStorage.SetSessionData(SessionReportItem sessionReport, ConnectionManager connectionManager) 

                Microsoft.ReportingServices.Library.DatabaseSessionStorage.SetSessionData(SessionReportItem sessionReport) 

                Microsoft.ReportingServices.Library.DatabaseSessionStorage.SetSessionData(SessionReportItem sessReport, Boolean async) 

                Microsoft.ReportingServices.Library.SessionReportItem.Save(SaveAction saveFlags, Boolean forceSync) 

                Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile) 

                Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters) 

                Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) 

                Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute() 

                Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() 

                Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) 

                Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory) 

                Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation) 

                Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType) 

                Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() 

                Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() 

                Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context) 

                System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 

                System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 

                System.Web.HttpApplication+ApplicationStepManager.ResumeSteps(Exception error) 

                System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) 

                System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) 

                System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) 

                System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) 

     

    w3wp!library!a!08/11/2008-13:09:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing;

     Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.

     

     

     

     

     

     



     


    Terry B
Monday, August 11, 2008 10:31 PM

All replies

  • Hi Terry,

    I do not have the solution to your problem, but I would suggest applying Service Pack 2 for Reporting Services. We made a tremendous number of bug fixes and improvements in the SP and may have solved your problem. If you do apply SP2, please make sure you back up your catalog and the RS encryption key.
    Brad Syputa, Microsoft Reporting Services This posting is provided "AS IS" with no warranties.
    Wednesday, August 13, 2008 4:44 PM