June 24, 2008 at 8:51 am
Dear all
ive a problem with the reporting services, we are using sql 2005 (2 server)
1 mainserver (database)
2 backupserver (reporting services)
the problem is, if i try to extract an large report to excel then evertime it generates an timeout.
first i must insert again the credentials on the browser then i takes a will and the browser had a timeout..
w3wp!library!1!24.06.2008-16:17:35:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!24.06.2008-16:17:35:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!24.06.2008-16:17:35:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!24.06.2008-16:17:35:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!24.06.2008-16:17:35:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!24.06.2008-16:17:35:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!24.06.2008-16:17:35:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!24.06.2008-16:17:35:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!24.06.2008-16:17:35:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!24.06.2008-16:17:35:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!24.06.2008-16:17:35:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!24.06.2008-16:17:35:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!24.06.2008-16:17:35:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!24.06.2008-16:17:35:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!24.06.2008-16:17:35:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!24.06.2008-16:17:35:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!1!24.06.2008-16:17:57:: Unhandled exception: Microsoft.Reporting.WebForms.ReportServerException: Die Ausführung 'f2r2dr55ryvwsh55xukh2145' wurde nicht gefunden. (rsExecutionNotFound)
at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
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!6!24.06.2008-16:20:02:: Unhandled exception: Microsoft.Reporting.WebForms.ReportServerException: Die Ausführung 'f2r2dr55ryvwsh55xukh2145' wurde nicht gefunden. (rsExecutionNotFound)
at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
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!8!24.06.2008-16:22:19:: e ERROR: Ein erforderliches Argument fehlt in dem URL, der diese Seite öffnet: ItemPath.
w3wp!ui!8!24.06.2008-16:22:19:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.ReportingServices.UI.UIException: Ein erforderliches Argument fehlt in dem URL, der diese Seite öffnet: ItemPath.
at Microsoft.ReportingServices.UI.ReportWrapperPage.Page_Init(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!8!24.06.2008-16:22:19:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
w3wp!ui!9!24.06.2008-16:22:39:: e ERROR: Ein erforderliches Argument fehlt in dem URL, der diese Seite öffnet: ItemPath.
w3wp!ui!9!24.06.2008-16:22:39:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.ReportingServices.UI.UIException: Ein erforderliches Argument fehlt in dem URL, der diese Seite öffnet: ItemPath.
at Microsoft.ReportingServices.UI.ReportWrapperPage.Page_Init(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!9!24.06.2008-16:22:39:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
w3wp!ui!8!24.06.2008-16:22:48:: e ERROR: System.Web.Services.Protocols.SoapException: Der Pfad des 0-Elements ist ungültig. Der vollständige Pfad darf höchstens 260 Zeichen lang. Es gelten zudem weitere Einschränkungen. Falls sich der Berichtsserver im systemeigenen Modus befindet, muss der Pfad mit einem Schrägstrich beginnen. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: Der Pfad des 0-Elements ist ungültig. Der vollständige Pfad darf höchstens 260 Zeichen lang. Es gelten zudem weitere Einschränkungen. Falls sich der Berichtsserver im systemeigenen Modus befindet, muss der Pfad mit einem Schrägstrich beginnen.
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.GetPermissionsAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
at Microsoft.ReportingServices.WebServer.ReportingService2005.GetPermissions(String Item, String[]& Permissions)
w3wp!ui!8!24.06.2008-16:22:48:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Der Pfad des 0-Elements ist ungültig. Der vollständige Pfad darf höchstens 260 Zeichen lang. Es gelten zudem weitere Einschränkungen. Falls sich der Berichtsserver im systemeigenen Modus befindet, muss der Pfad mit einem Schrägstrich beginnen. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: Der Pfad des 0-Elements ist ungültig. Der vollständige Pfad darf höchstens 260 Zeichen lang. Es gelten zudem weitere Einschränkungen. Falls sich der Berichtsserver im systemeigenen Modus befindet, muss der Pfad mit einem Schrägstrich beginnen.
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.GetPermissionsAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
at Microsoft.ReportingServices.WebServer.ReportingService2005.GetPermissions(String Item, String[]& Permissions)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.GetPermissions(String Item)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetPermissions(String Item)
at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)
at Microsoft.ReportingServices.UI.ReportWrapperPage.Page_Init(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!8!24.06.2008-16:22:48:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
w3wp!ui!9!24.06.2008-16:23:04:: e ERROR: System.Web.Services.Protocols.SoapException: Der Pfad des 5-Elements ist ungültig. Der vollständige Pfad darf höchstens 260 Zeichen lang. Es gelten zudem weitere Einschränkungen. Falls sich der Berichtsserver im systemeigenen Modus befindet, muss der Pfad mit einem Schrägstrich beginnen. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: Der Pfad des 5-Elements ist ungültig. Der vollständige Pfad darf höchstens 260 Zeichen lang. Es gelten zudem weitere Einschränkungen. Falls sich der Berichtsserver im systemeigenen Modus befindet, muss der Pfad mit einem Schrägstrich beginnen.
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.GetPermissionsAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
at Microsoft.ReportingServices.WebServer.ReportingService2005.GetPermissions(String Item, String[]& Permissions)
w3wp!ui!9!24.06.2008-16:23:04:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Der Pfad des 5-Elements ist ungültig. Der vollständige Pfad darf höchstens 260 Zeichen lang. Es gelten zudem weitere Einschränkungen. Falls sich der Berichtsserver im systemeigenen Modus befindet, muss der Pfad mit einem Schrägstrich beginnen. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: Der Pfad des 5-Elements ist ungültig. Der vollständige Pfad darf höchstens 260 Zeichen lang. Es gelten zudem weitere Einschränkungen. Falls sich der Berichtsserver im systemeigenen Modus befindet, muss der Pfad mit einem Schrägstrich beginnen.
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.GetPermissionsAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
at Microsoft.ReportingServices.WebServer.ReportingService2005.GetPermissions(String Item, String[]& Permissions)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.GetPermissions(String Item)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetPermissions(String Item)
at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)
at Microsoft.ReportingServices.UI.ReportWrapperPage.Page_Init(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!9!24.06.2008-16:23:04:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
w3wp!ui!1!24.06.2008-16:28:14:: e ERROR: System.Web.Services.Protocols.SoapException: Der Pfad des 5-Elements ist ungültig. Der vollständige Pfad darf höchstens 260 Zeichen lang. Es gelten zudem weitere Einschränkungen. Falls sich der Berichtsserver im systemeigenen Modus befindet, muss der Pfad mit einem Schrägstrich beginnen. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: Der Pfad des 5-Elements ist ungültig. Der vollständige Pfad darf höchstens 260 Zeichen lang. Es gelten zudem weitere Einschränkungen. Falls sich der Berichtsserver im systemeigenen Modus befindet, muss der Pfad mit einem Schrägstrich beginnen.
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.GetPermissionsAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
at Microsoft.ReportingServices.WebServer.ReportingService2005.GetPermissions(String Item, String[]& Permissions)
w3wp!ui!1!24.06.2008-16:28:14:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Der Pfad des 5-Elements ist ungültig. Der vollständige Pfad darf höchstens 260 Zeichen lang. Es gelten zudem weitere Einschränkungen. Falls sich der Berichtsserver im systemeigenen Modus befindet, muss der Pfad mit einem Schrägstrich beginnen. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: Der Pfad des 5-Elements ist ungültig. Der vollständige Pfad darf höchstens 260 Zeichen lang. Es gelten zudem weitere Einschränkungen. Falls sich der Berichtsserver im systemeigenen Modus befindet, muss der Pfad mit einem Schrägstrich beginnen.
at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)
at Microsoft.ReportingServices.Library.GetPermissionsAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetPermissions(String Item, String[]& Permissions)
at Microsoft.ReportingServices.WebServer.ReportingService2005.GetPermissions(String Item, String[]& Permissions)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.GetPermissions(String Item)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetPermissions(String Item)
at Microsoft.ReportingServices.UI.Permissions.GetPermissions()
at Microsoft.ReportingServices.UI.Permissions.CurrentUser(String itemPath)
at Microsoft.ReportingServices.UI.ReportWrapperPage.Page_Init(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!24.06.2008-16:28:14:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
can some assist me ?
June 25, 2008 at 7:40 am
Hi Marino,
you can increase Connection TimeOut bu using below mentioned steps:
1. Open your Data Source by double clicking.
2. Click Edit button.
3. Click on Advance button to open Advance Properties dialogue box.
3. Now increase Connection Timeout value.
I hopw it will work.
June 26, 2008 at 3:15 am
ive set the timeout higher but i doesnt resolve my problem...
Logfile:
w3wp!webserver!6!26.06.2008-11:06:21:: i INFO: Reporting Web Server started
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!6!26.06.2008-11:06:21:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!6!26.06.2008-11:06:21:: i INFO: Reporting Services starting SKU: Standard
w3wp!resourceutilities!6!26.06.2008-11:06:21:: i INFO: Evaluation copy: 0 days left
w3wp!resourceutilities!6!26.06.2008-11:06:21:: i INFO: Running on 2 physical processors, 4 logical processors
w3wp!runningjobs!6!26.06.2008-11:06:21:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!6!26.06.2008-11:06:21:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!6!26.06.2008-11:06:21:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!6!26.06.2008-11:06:21:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!7!06/26/2008-11:06:22:: i INFO: Catalog SQL Server Edition = Standard
webpage:
You are not authorized to view this page
You do not have permission to view this directory or page using the credentials that you supplied.
--------------------------------------------------------------------------------
Please try the following:
Contact the Web site administrator if you believe you should be able to view this directory or page.
Click the Refresh button to try again with different credentials.
HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)
Comment:
ive i generate a small report and run an excel extract its no problem but
if i run a bigger report and try to export this report i doesnt work.
during the redering of the report i should insert 3 - 4 times the credentials then at least the error you are not authorized.
i entered the in the webcofig
on ReportServer and reportmanager directory .
but still the same error.. see log file
June 26, 2008 at 5:23 am
This is a known issue with SSRS 2005 and earlier; Reporting Services is memory dependent. On very large reports, you are consuming all available RAM and the server is restarting to correct the issue. The prompt for a login while a report generates is an indicator of being disconnected from the report server.
If you check your error logs, you will most likely find out of memory exceptions. The only way to get around this is to increase the RAM but there is still a limit to how large of a report you'd be able to run. Also, be aware the export method has an affect on system resources as well. Excel is the most costly while CSV is the least.
The good news is Microsoft has corrected this in SQL 2008 and the report server will now allow very large reports to execute.
Dave
June 27, 2008 at 1:21 am
Thanks for your info.
thats good to know, my first step i to check if this would be running with a sheduled job.
ive configured today an automatically job for the large extract.
ive only problems with 1 report, if the sheduled job will run successfully then i will use this option otherwise i check then exactly the configuration of the RAM.
cheers
September 4, 2008 at 5:45 am
David Klug (6/26/2008)
This is a known issue with SSRS 2005 and earlier; Reporting Services is memory dependent. On very large reports, you are consuming all available RAM and the server is restarting to correct the issue. The prompt for a login while a report generates is an indicator of being disconnected from the report server.If you check your error logs, you will most likely find out of memory exceptions. The only way to get around this is to increase the RAM but there is still a limit to how large of a report you'd be able to run.
Dave
I am having similar problems where both running reports and exporting reports will cause a prompt to login. Using Task Manager, I checked my servers memory and it shows 4G of 8G available. In my log, I am not getting any errors about low memory. I do not think it is a memory issue.
After a reboot, the reports will run better but the export to Excel still continues to fail. I have tried exporting to CSV and that works. However, the CSV export has problems because one field is a comment field and if the user typed commas, apostrophes or single quotes the Excel will not import the data correctly.
Below are the entries from my most recent attempt lot export a report. Any assistance would be greatly appreciated.
Rob
w3wp!library!6!09/04/2008-05:15:45:: Call to GetPermissionsAction(/).
w3wp!library!1!09/04/2008-05:15:45:: Call to GetPropertiesAction(/, PathBased).
w3wp!library!6!09/04/2008-05:15:45:: Call to GetSystemPermissionsAction().
w3wp!library!1!09/04/2008-05:15:45:: Call to ListChildrenAction(/, False).
w3wp!library!1!09/04/2008-05:15:45:: Call to GetSystemPropertiesAction().
w3wp!library!a!09/04/2008-05:15:45:: Call to GetSystemPropertiesAction().
w3wp!library!b!09/04/2008-05:16:23:: Call to GetPermissionsAction(/Region - NAR).
w3wp!library!1!09/04/2008-05:16:23:: Call to GetPropertiesAction(/Region - NAR, PathBased).
w3wp!library!1!09/04/2008-05:16:23:: Call to GetSystemPermissionsAction().
w3wp!library!1!09/04/2008-05:16:23:: Call to ListChildrenAction(/Region - NAR, False).
w3wp!library!6!09/04/2008-05:16:23:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/04/2008-05:16:23:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/04/2008-05:16:25:: Call to GetPermissionsAction(/Region - NAR/GSD).
w3wp!library!b!09/04/2008-05:16:25:: Call to GetPropertiesAction(/Region - NAR/GSD, PathBased).
w3wp!library!b!09/04/2008-05:16:25:: Call to GetSystemPermissionsAction().
w3wp!library!b!09/04/2008-05:16:25:: Call to ListChildrenAction(/Region - NAR/GSD, False).
w3wp!library!6!09/04/2008-05:16:25:: Call to GetSystemPropertiesAction().
w3wp!library!b!09/04/2008-05:16:25:: Call to GetSystemPropertiesAction().
w3wp!library!a!09/04/2008-05:16:28:: Call to GetPermissionsAction(/Region - NAR/GSD/Global Operations Report).
w3wp!library!6!09/04/2008-05:16:28:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report, PathBased).
w3wp!library!6!09/04/2008-05:16:28:: Call to GetSystemPermissionsAction().
w3wp!library!b!09/04/2008-05:16:28:: Call to ListChildrenAction(/Region - NAR/GSD/Global Operations Report, False).
w3wp!library!6!09/04/2008-05:16:28:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/04/2008-05:16:28:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/04/2008-05:16:30:: Call to GetPermissionsAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report).
w3wp!library!6!09/04/2008-05:16:30:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/04/2008-05:16:30:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report, PathBased).
w3wp!library!6!09/04/2008-05:16:30:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/04/2008-05:16:30:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report, PathBased).
w3wp!library!6!09/04/2008-05:16:30:: Call to ListEventsAction().
w3wp!library!1!09/04/2008-05:16:30:: Call to GetSystemPropertiesAction().
w3wp!library!b!09/04/2008-05:16:55:: Call to GetPermissionsAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report).
w3wp!library!1!09/04/2008-05:16:55:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/04/2008-05:16:55:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report, PathBased).
w3wp!library!b!09/04/2008-05:16:55:: Call to GetSystemPermissionsAction().
w3wp!library!a!09/04/2008-05:16:55:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report, PathBased).
w3wp!library!1!09/04/2008-05:16:55:: Call to GetSystemPropertiesAction().
w3wp!library!a!04/09/2008-05:17:36:: 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!b!09/04/2008-05:18:25:: Call to GetPermissionsAction(/).
w3wp!library!b!09/04/2008-05:18:25:: Call to GetPropertiesAction(/, PathBased).
w3wp!library!b!09/04/2008-05:18:25:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/04/2008-05:18:25:: Call to ListChildrenAction(/, False).
w3wp!library!6!09/04/2008-05:18:25:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/04/2008-05:18:28:: Call to GetPermissionsAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report).
w3wp!library!6!09/04/2008-05:18:28:: Call to GetSystemPropertiesAction().
w3wp!library!a!09/04/2008-05:18:28:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report, PathBased).
w3wp!library!a!09/04/2008-05:18:28:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/04/2008-05:18:28:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report, PathBased).
w3wp!library!1!09/04/2008-05:18:28:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/04/2008-05:18:29:: Call to GetPermissionsAction(/Region - NAR).
w3wp!library!1!09/04/2008-05:18:29:: Call to GetPropertiesAction(/Region - NAR, PathBased).
w3wp!library!1!09/04/2008-05:18:29:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/04/2008-05:18:29:: Call to ListChildrenAction(/Region - NAR, False).
w3wp!library!6!09/04/2008-05:18:29:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/04/2008-05:18:31:: Call to GetPermissionsAction(/Region - NAR/CSI).
w3wp!library!6!09/04/2008-05:18:31:: Call to GetPropertiesAction(/Region - NAR/CSI, PathBased).
w3wp!library!6!09/04/2008-05:18:31:: Call to GetSystemPermissionsAction().
w3wp!library!1!09/04/2008-05:18:31:: Call to ListChildrenAction(/Region - NAR/CSI, False).
w3wp!library!b!09/04/2008-05:18:31:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/04/2008-05:18:33:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report).
w3wp!library!1!09/04/2008-05:18:33:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report, PathBased).
w3wp!library!6!09/04/2008-05:18:33:: Call to GetSystemPermissionsAction().
w3wp!library!1!09/04/2008-05:18:33:: Call to ListChildrenAction(/Region - NAR/CSI/Global Operations Report, False).
w3wp!library!6!09/04/2008-05:18:33:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/04/2008-05:18:52:: Call to GetPermissionsAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report).
w3wp!library!b!09/04/2008-05:18:52:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/04/2008-05:18:52:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report, PathBased).
w3wp!library!1!09/04/2008-05:18:52:: Call to GetSystemPermissionsAction().
w3wp!library!1!09/04/2008-05:18:52:: Call to GetPropertiesAction(/Region - NAR/GSD/Global Operations Report/Order Summary Report, PathBased).
w3wp!library!1!09/04/2008-05:18:52:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/04/2008-05:18:58:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report).
w3wp!library!1!09/04/2008-05:18:58:: Call to GetSystemPropertiesAction().
w3wp!library!a!09/04/2008-05:18:58:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report, PathBased).
w3wp!library!a!09/04/2008-05:18:58:: Call to GetSystemPermissionsAction().
w3wp!library!a!09/04/2008-05:18:58:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/04/2008-05:18:59:: i INFO: Call to RenderFirst( '/Region - NAR/GSD/Global Operations Report/Order Summary Report' )
w3wp!library!b!09/04/2008-05:19:24:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report).
w3wp!library!b!09/04/2008-05:19:24:: Call to GetSystemPropertiesAction().
w3wp!library!b!09/04/2008-05:19:24:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report, PathBased).
w3wp!library!b!09/04/2008-05:19:24:: Call to GetSystemPermissionsAction().
w3wp!library!b!09/04/2008-05:19:24:: Call to GetSystemPropertiesAction().
w3wp!runningjobs!a!04/09/2008-05:19:36:: i INFO: Adding: 1 running jobs to the database
w3wp!library!a!09/04/2008-05:19:42:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report).
w3wp!library!b!09/04/2008-05:19:42:: Call to GetSystemPropertiesAction().
w3wp!library!b!09/04/2008-05:19:42:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report, PathBased).
w3wp!library!a!09/04/2008-05:19:42:: Call to GetSystemPermissionsAction().
w3wp!library!b!09/04/2008-05:19:42:: Call to GetSystemPropertiesAction().
w3wp!library!7!09/04/2008-05:19:59:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report).
w3wp!library!7!09/04/2008-05:19:59:: Call to GetSystemPropertiesAction().
w3wp!library!7!09/04/2008-05:19:59:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report, PathBased).
w3wp!library!a!09/04/2008-05:19:59:: Call to GetSystemPermissionsAction().
w3wp!library!a!09/04/2008-05:19:59:: Call to GetSystemPropertiesAction().
w3wp!library!7!09/04/2008-05:20:12:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report).
w3wp!library!7!09/04/2008-05:20:12:: Call to GetSystemPropertiesAction().
w3wp!library!b!09/04/2008-05:20:12:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Line Item Detail Report, PathBased).
w3wp!library!7!09/04/2008-05:20:12:: Call to GetSystemPermissionsAction().
w3wp!library!7!09/04/2008-05:20:12:: Call to GetSystemPropertiesAction().
w3wp!library!a!09/04/2008-05:20:17:: i INFO: Call to RenderFirst( '/Region - NAR/CSI/Global Operations Report/Line Item Detail Report' )
w3wp!webserver!a!09/04/2008-05:21:16:: i INFO: Processed report. Report='/Region - NAR/CSI/Global Operations Report/Line Item Detail Report', Stream=''
w3wp!webserver!1!09/04/2008-05:21:43:: i INFO: Processed report. Report='/Region - NAR/GSD/Global Operations Report/Order Summary Report', Stream=''
w3wp!library!6!09/04/2008-05:22:45:: i INFO: Call to RenderNext( '/Region - NAR/CSI/Global Operations Report/Line Item Detail Report' )
w3wp!library!7!09/04/2008-05:22:50:: i INFO: Call to RenderNext( '/Region - NAR/GSD/Global Operations Report/Order Summary Report' )
w3wp!runningjobs!b!04/09/2008-05:23:36:: i INFO: Adding: 2 running jobs to the database
w3wp!cache!6!09/04/2008-05:26:33:: i INFO: Session live: /Region - NAR/CSI/Global Operations Report/Line Item Detail Report
w3wp!webserver!6!09/04/2008-05:26:33:: i INFO: Processed report. Report='/Region - NAR/CSI/Global Operations Report/Line Item Detail Report', Stream=''
w3wp!library!6!04/09/2008-05:27:38:: 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!09/04/2008-05:28:21:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report).
w3wp!library!a!09/04/2008-05:28:21:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report, PathBased).
w3wp!library!a!09/04/2008-05:28:21:: Call to GetSystemPermissionsAction().
w3wp!library!a!09/04/2008-05:28:21:: Call to ListChildrenAction(/Region - NAR/CSI/Global Operations Report, False).
w3wp!library!a!09/04/2008-05:28:21:: Call to GetSystemPropertiesAction().
w3wp!library!a!09/04/2008-05:28:25:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report).
w3wp!library!b!09/04/2008-05:28:25:: Call to GetSystemPropertiesAction().
w3wp!library!b!09/04/2008-05:28:25:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report, PathBased).
w3wp!library!b!09/04/2008-05:28:25:: Call to GetSystemPermissionsAction().
w3wp!library!b!09/04/2008-05:28:25:: Call to GetSystemPropertiesAction().
w3wp!library!b!09/04/2008-05:28:39:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report).
w3wp!library!b!09/04/2008-05:28:39:: Call to GetSystemPropertiesAction().
w3wp!library!b!09/04/2008-05:28:39:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report, PathBased).
w3wp!library!b!09/04/2008-05:28:39:: Call to GetSystemPermissionsAction().
w3wp!library!a!09/04/2008-05:28:39:: Call to GetSystemPropertiesAction().
w3wp!library!b!09/04/2008-05:28:51:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report).
w3wp!library!b!09/04/2008-05:28:51:: Call to GetSystemPropertiesAction().
w3wp!library!b!09/04/2008-05:28:51:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report, PathBased).
w3wp!library!b!09/04/2008-05:28:51:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/04/2008-05:28:51:: Call to GetSystemPropertiesAction().
w3wp!library!a!09/04/2008-05:29:05:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report).
w3wp!library!a!09/04/2008-05:29:05:: Call to GetSystemPropertiesAction().
w3wp!library!a!09/04/2008-05:29:05:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report, PathBased).
w3wp!library!b!09/04/2008-05:29:05:: Call to GetSystemPermissionsAction().
w3wp!library!b!09/04/2008-05:29:05:: Call to GetSystemPropertiesAction().
w3wp!library!b!09/04/2008-05:29:13:: Call to GetPermissionsAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report).
w3wp!library!6!09/04/2008-05:29:13:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/04/2008-05:29:13:: Call to GetPropertiesAction(/Region - NAR/CSI/Global Operations Report/Order Summary Report, PathBased).
w3wp!library!6!09/04/2008-05:29:13:: Call to GetSystemPermissionsAction().
w3wp!library!b!09/04/2008-05:29:13:: Call to GetSystemPropertiesAction().
w3wp!library!b!09/04/2008-05:29:21:: i INFO: Call to RenderFirst( '/Region - NAR/CSI/Global Operations Report/Order Summary Report' )
w3wp!runningjobs!a!04/09/2008-05:30:36:: i INFO: Adding: 1 running jobs to the database
w3wp!webserver!b!09/04/2008-05:31:50:: i INFO: Processed report. Report='/Region - NAR/CSI/Global Operations Report/Order Summary Report', Stream=''
w3wp!library!a!09/04/2008-05:32:01:: i INFO: Call to RenderNext( '/Region - NAR/CSI/Global Operations Report/Order Summary Report' )
w3wp!runningjobs!6!04/09/2008-05:32:36:: i INFO: Adding: 1 running jobs to the database
w3wp!cache!7!09/04/2008-05:33:14:: i INFO: Session live: /Region - NAR/GSD/Global Operations Report/Order Summary Report
w3wp!webserver!7!09/04/2008-05:33:14:: i INFO: Processed report. Report='/Region - NAR/GSD/Global Operations Report/Order Summary Report', Stream=''
w3wp!library!7!09/04/2008-05:33:14:: i INFO: Call to RenderNext( '/Region - NAR/GSD/Global Operations Report/Order Summary Report' )
w3wp!cache!a!09/04/2008-05:33:26:: i INFO: Session live: /Region - NAR/CSI/Global Operations Report/Order Summary Report
w3wp!webserver!a!09/04/2008-05:33:26:: i INFO: Processed report. Report='/Region - NAR/CSI/Global Operations Report/Order Summary Report', Stream=''
w3wp!runningjobs!6!04/09/2008-05:34:36:: i INFO: Adding: 1 running jobs to the database
w3wp!library!6!04/09/2008-05:37:37:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 11 chunks, 0 running jobs, 0 persisted streams
September 4, 2008 at 6:54 am
Robert Hake (9/4/2008)
I am having similar problems where both running reports and exporting reports will cause a prompt to login. Using Task Manager, I checked my servers memory and it shows 4G of 8G available. In my log, I am not getting any errors about low memory. I do not think it is a memory issue.
OK. NOW the log is showing memory errors. However, Task Manager is still showing 5G free. While this error is occuring there is very little page file usage.
I'm at a loss.
Rob
w3wp!reportrendering!7!09/04/2008-06:44:17:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report., ;
Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at Microsoft.ReportingServices.Rendering.ExcelRenderer.IntList.ToString(Int32 index)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateReportItemReference(ReportItem parentDataRegion, Hashtable riReferenceTable, IntList indexPath, Int32 startIndex)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetPageCellReportItem(ReportItem parentItem, PageReportItemInfo pageReportItemInfo, Hashtable riReferenceTable)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean addHeaderRows, ReportItem parentItem, Hashtable riReferenceTable)
at Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32 minCol, Int32 maxCol)
at Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet(ExcelRenderer excelRenderer, Stream stream, Int32 offset)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout pageLayout, Int32& currentPageNumber, Stack& stack)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout& lastPageLayout)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension renderer, CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
--- End of inner exception stack trace ---
w3wp!webserver!7!09/04/2008-06:44:17:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
w3wp!library!7!09/04/2008-06:44:17:: e ERROR: Found System.OutOfMemoryException exception: Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
w3wp!library!7!09/04/2008-06:44:17:: e ERROR: Terminating worker process
September 4, 2008 at 7:02 am
Have you considered moving to SQL Server 20008 for the Report Server? It is no longer restricted by memory and on initial tests I've run, I've been able to generate 70,000+ page reports without issue.
September 4, 2008 at 8:37 am
David Klug (9/4/2008)
Have you considered moving to SQL Server 20008 for the Report Server? It is no longer restricted by memory and on initial tests I've run, I've been able to generate 70,000+ page reports without issue.
Upgrading to SQL Server 2008 is not a quick solution: costs, time, testing and so on.
Things were running OK last week. This week they are not.
Rob
February 17, 2010 at 6:02 am
I'm looking for this answer, too. Is it a limitation of reporting services? I'm watching memory usage and processor, but its nowhere near looking like a problem of used-up resources. If it is a limitation, is there a known threshold?
Thanks!
Randy
Randy
February 17, 2010 at 7:53 am
Now I know! And knowing is half the battle!
Check out: http://msdn.microsoft.com/en-us/library/ms159206(SQL.90).aspx and http://support.microsoft.com/kb/909678
Currently I'm going with the option of changing the memory settings in rsreportserver.config file.
Randy
February 19, 2010 at 11:28 am
Hi,
There may be the two reasons for this
1:Report session time out
2:Report data limitation
1:Go to the ReportserverDB and increase the timeout for the reportserver.
Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉
June 30, 2010 at 2:13 pm
Was there any resolution to this problem, we are experiencing the same thing in SSRS05 and upgrading right now is not an option.
September 4, 2013 at 2:34 am
Hie,
I am also looking for the answer. Anybody got solution ?
Thanks In Advance,
Vanitha
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply