All of a sudden, the e-mail subscriptions for a report quit being sent.
Running Sql 2000
Microsoft SQL Server Reporting Services Version 8.00.743.00
Here is the log error:
aspnet_wp!processing!e40!12/11/2006-08:34:29:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
aspnet_wp!processing!e40!12/11/2006-08:34:29:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing.
aspnet_wp!processing!e40!12/11/2006-08:34:29:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!library!e08!12/11/2006-08:39:10:: i INFO: Call to GetPermissions:/Maximo/PO with Received Date Details
aspnet_wp!chunks!e08!12/11/2006-08:39:10:: i INFO: ### GetReportChunk('CompiledDefinition', Main), chunk was not found! this=00000000-0000-0000-0000-000000000000
aspnet_wp!processing!e08!12/11/2006-08:39:10:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext reportContext, GetReportChunk getCompiledDefinitionCallback, SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection dataSources, Boolean checkIfUsable, Boolean isSurrogatePresent)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean checkIfUsable)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, Guid reportID, Boolean checkIfUsable)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(CatalogItemContext reportContext, Boolean checkIfUsable, ReportSnapshot& compiledDefinition)
Microsoft.ReportingServices.Library.RSService._GetProperties(ItemNamespaceEnum itemNamespace, String item, Property[] requestedProperties)
Microsoft.ReportingServices.Library.RSService.GetProperties(ItemNamespaceEnum itemNamespace, String item, Property[] properties)
Microsoft.ReportingServices.WebServer.ReportingService.GetProperties(String Item, Property[] Properties, Property[]& Values)
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean isBinderDefault, Assembly caller, Boolean verifyAccess)
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean verifyAccess)
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
System.Web.Services.Protocols.WebServiceHandler.Invoke()
System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.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.ProcessRequest(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
Any suggestions? Anyone see this before?
Are you sure that you wanted to attach this logfile extract? You mention subscription problem as an original one. But the logfile extract is taken from UI (Reportmanager) logfile, not from the server logfile: reported by aspnet_wp component and stack starts from System.Web.Hosting.ISAPIRuntime.ProcessRequest. If your problem is related to the subscription that suddenly discontinued to work, please attach the corresponding piece from the reportserver_<date>.logh file.
|||Ah, thanks for that help. Here is that log:
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!chunks!c80!12/12/2006-10:48:06:: i INFO: ### GetReportChunk('CompiledDefinition', Main), chunk was not found! this=00000000-0000-0000-0000-000000000000
aspnet_wp!processing!c80!12/12/2006-10:48:06:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext reportContext, GetReportChunk getCompiledDefinitionCallback, SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection dataSources, Boolean checkIfUsable, Boolean isSurrogatePresent)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean checkIfUsable)
Microsoft.ReportingServices.Library.RSService.ProcessReportParameters(CatalogItemContext reportContext, ReportSnapshot compiledDefintion, ReportSnapshot snapshotData, DataSourceInfoCollection dataSources, ParameterInfoCollection newParameters, DateTime executionTime, Boolean isSnapshot)
Microsoft.ReportingServices.Library.RSService.InternalGetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values)
Microsoft.ReportingServices.Library.ProcessReportParametersCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RSService.GetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values, JobTypeEnum jobType)
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
Microsoft.ReportingServices.Library.RSService.GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
Microsoft.ReportingServices.WebServer.HTMLViewerBase.GetMergedParametersCollection(NameValueCollection userSpecifiedParams)
Microsoft.ReportingServices.WebServer.HTMLViewerBase.GetMergedReportCollections(ParameterInfoCollection& mergedParams, DataSourcePromptCollection& mergedDataSources, Boolean countsOnly)
Microsoft.ReportingServices.WebServer.HTML40Viewer.GetMergedReportCollections(ParameterInfoCollection& mergedParams, DataSourcePromptCollection& mergedDataSources, Boolean countsOnly)
Microsoft.ReportingServices.WebServer.HTML40Viewer.RenderViewer(String reportName, ReportUrl location, NameValueCollection reportParameters, DatasourceCredentialsCollection dataSourceCredentials, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, CreateAndRegisterStream createAndRegisterStream)
Microsoft.ReportingServices.WebServer.HTMLViewerBase.PreRender(RSService service, CatalogItemContext itemContext, CreateAndRegisterStream createAndRegisterStream, Boolean isSnapshot)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem()
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.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.ProcessRequest(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!library!c80!12/12/2006-10:48:30:: i INFO: Call to RenderFirst( '/Maximo/PO Details' )
aspnet_wp!chunks!c80!12/12/2006-10:48:30:: i INFO: ### GetReportChunk('CompiledDefinition', Main), chunk was not found! this=00000000-0000-0000-0000-000000000000
aspnet_wp!processing!c80!12/12/2006-10:48:30:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext reportContext, GetReportChunk getCompiledDefinitionCallback, SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection dataSources, Boolean checkIfUsable, Boolean isSurrogatePresent)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean checkIfUsable)
Microsoft.ReportingServices.Library.RSService.ProcessReportParameters(CatalogItemContext reportContext, ReportSnapshot compiledDefintion, ReportSnapshot snapshotData, DataSourceInfoCollection dataSources, ParameterInfoCollection newParameters, DateTime executionTime, Boolean isSnapshot)
Microsoft.ReportingServices.Library.RSService.InternalGetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values)
Microsoft.ReportingServices.Library.RSService.GetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values, JobTypeEnum jobType)
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
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, JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem()
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.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.ProcessRequest(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
aspnet_wp!processing!c80!12/12/2006-10:48:30:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:30:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:30:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!library!c80!12/12/2006-10:48:31:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!c80!12/12/2006-10:48:31:: i INFO: Processed report. Report='/Maximo/PO Details', Stream=''
aspnet_wp!library!d4c!12/12/2006-10:49:06:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
aspnet_wp!session!c80!12/12/2006-10:49:38:: i INFO: LoadSnapshot: Item with session: cbm0l1yg4tjjvs55u2wxlp55, reportPath: /Maximo/PO By Material Received Date, userName: BNFLIDAHO\rosesi not found in the database
aspnet_wp!library!c80!12/12/2006-10:49:38:: i INFO: Call to RenderFirst( '/Maximo/PO By Material Received Date' )
aspnet_wp!library!c80!12/12/2006-10:49:39:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
James,
All attached errors are logged by the web service when you run report via the Report Manager. You can see that by the name of the process that is the first token in the every log entry: aspnet_wp; and by the initial call in the call stack: System.Web.Hosting.ISAPIRuntime.ProcessRequest. Attached errors may be valuable if they are related to the problem you have. They indicate that there is a problem with the retrieving data sources for a sub-report when you try to execute a report via the ReportManager.
For the subscription problem you reported originally you need to take a look on the logfile written by RS windows service. Something like ReportServerService__12_12_2006_13_05_41.log. Sorry , in my previous post I put a wrong name for it. Try to locate the logfile coresponding to the subscription using the timestamp in the logfile name, and then find the errors in the logfile corresponding to the subscription using timestamps within the file.
-Igor
