Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Reporting Services problem with extract Excel Expand / Collapse
Author
Message
Posted Tuesday, June 24, 2008 8:51 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, January 12, 2010 5:06 AM
Points: 13, Visits: 98
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 ?
Post #522603
Posted Wednesday, June 25, 2008 7:40 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, December 26, 2012 12:43 PM
Points: 1,330, Visits: 455
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.


Cheers,
Hari
Tips & Tricks for SQL BI Developers
Post #523317
Posted Thursday, June 26, 2008 3:15 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, January 12, 2010 5:06 AM
Points: 13, Visits: 98
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
Post #523960
Posted Thursday, June 26, 2008 5:23 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 18, 2014 1:12 PM
Points: 1,074, Visits: 1,152
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
Post #524021
Posted Friday, June 27, 2008 1:21 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, January 12, 2010 5:06 AM
Points: 13, Visits: 98
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
Post #524801
Posted Thursday, September 4, 2008 5:45 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:02 PM
Points: 45, Visits: 335
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
Post #563700
Posted Thursday, September 4, 2008 6:54 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:02 PM
Points: 45, Visits: 335
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
Post #563759
Posted Thursday, September 4, 2008 7:02 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 18, 2014 1:12 PM
Points: 1,074, Visits: 1,152
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.
Post #563767
Posted Thursday, September 4, 2008 8:37 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:02 PM
Points: 45, Visits: 335
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
Post #563863
Posted Wednesday, February 17, 2010 6:02 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 15, 2011 12:53 PM
Points: 243, Visits: 236
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
Post #866942
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse