Report Timeout problem ;Out of memory exception

I am having a problem with report rendering.
The MSSRS Report runs for around 15 minutes and then the report page times
out giving the error as
"Out of memory exception. Server application unavailable".
When i check the query execution time in query analyser, query returns
results in 10 minutes.
There are about 3 groups in the RDL design.
Please provide any suggestions to overcome this problem.
Thanks in advance.
Thanks and Cheers,
TruptiSounds like your report is just too big. RS renders reports in memory, thus
the 'Out of memory exception'. Try redesigning the report or adding more
memory to your machine/server.
Also, if you get the report to successfully run you can try to pin point
what's taking so long. Look in the ReportServer database; the ExecutionLog
table. It shows what report ran, when, the amount of time for data
retrieval, processing time, and rendering time. It also shows what render
format, render status (fail or success), query row count and byte size of
the rendered file.
--
Adrian M.
MCP
"Trupti" <gettrupti@.hotmail.com> wrote in message
news:e0Tt9bcNFHA.1392@.TK2MSFTNGP10.phx.gbl...
>I am having a problem with report rendering.
> The MSSRS Report runs for around 15 minutes and then the report page
> times out giving the error as
> "Out of memory exception. Server application unavailable".
> When i check the query execution time in query analyser, query returns
> results in 10 minutes.
> There are about 3 groups in the RDL design.
> Please provide any suggestions to overcome this problem.
> Thanks in advance.
> Thanks and Cheers,
> Trupti
>
>

Report Timeout Issue

I have a report timeout issue when I view the reports from report manager.
According to execution logs my report ran in about 8 minutes. However,
during the execution the report manager times out after the first minute and
displays action canceled. (The task bar changes from long report link to
"connecting to server bla bla bla". After that, in a few seconds, the error
message pops up.)
While digging through the list, I have found these as possible causes.
1. Set the http connection timeout in IIS where reporting server is
installed.
2. Set Query timeout in RDL
3. Set Web service client timeout.
4. Set reportProcessingTimeout as system level property or report level
property.
In config IIS and RDL time out are set to 600 and 1800 secs respectively.
How can I check web service client timeout and how can I set
reportProcessingTimeout? Are there any other settings I should check for
this issue?
Thanks.
CDIt tooks exactly 60 seconds to RS time out. First the task bar changes from
the address to connecting to server bla bla bla after another minute, Action
Cancelled message popsup.
I was playing with RSReportServer.config file. I changed a few parameters,
which didn't help of course. Is it sufficient to restart RS services and www
service on win 2003 machine to apply the new config settings or do I have to
do something else?
Thanks a lot
CD
"DC" <DC@.yahoo.com> wrote in message
news:u9d2WCBnEHA.1800@.TK2MSFTNGP15.phx.gbl...
> I have a report timeout issue when I view the reports from report manager.
> According to execution logs my report ran in about 8 minutes. However,
> during the execution the report manager times out after the first minute
and
> displays action canceled. (The task bar changes from long report link to
> "connecting to server bla bla bla". After that, in a few seconds, the
error
> message pops up.)
> While digging through the list, I have found these as possible causes.
> 1. Set the http connection timeout in IIS where reporting server is
> installed.
> 2. Set Query timeout in RDL
> 3. Set Web service client timeout.
> 4. Set reportProcessingTimeout as system level property or report level
> property.
> In config IIS and RDL time out are set to 600 and 1800 secs respectively.
> How can I check web service client timeout and how can I set
> reportProcessingTimeout? Are there any other settings I should check for
> this issue?
> Thanks.
> CD
>|||Some more info about my timeout issue. When I run the report from VS,
without restricting parameters, I receive outofmemory error after 10
minutes. If I run the query with a few restricting parameters, the report
shows up properly after 4 minutes, which doesn't happen on report manager.
Here are my config and log files - another wierd thing I realize in my log
files is WebApp log says DatabaseQueryTimeout is not set so default to 30
sec. The other hand report server log file says DatabaseQueryTimeout is set
to '1200' as specified at config file. Any help would be really appriciated.
Thanks.
CD
<Configuration>
<Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAyJKMRfN3j0yU3k4Y0TdabAQAAAAiAAAAUgBlAHA
AbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAO8FzVdcu5BIKubzECnNHiIAAAAA
BIAAAKAAAAAQAAAABnuEnlJ6HCYNdxFNukwafSgBAACS3ffr9Zc2xw/odaxolOYJPVwbU4ypb4/5
gcU64sVF2JxKZtWkmLOZmNQhLimhxd2/rG1O2Cki3apdyDqTkhgrzMRhypP3S8lOY/4Q5Oy2u4RG
ZhMkw/XLkU9qXA5hY6hpOqjIq2B+7gQ2nApDxLhJ/Hxy8SBVqGX/tx5PesCH07v3XAJR0No9Sf0Q
SrvaQMcms1dQ8R+5tPi8yeshK1m0YlFGtFE7AzN9HSQehPC9K5BOZdngTLVgFiYnUq6yFZzChfK0
DafRrp31cMRQoP/lDN0qKg+76OfqyHGQ7dX3Nq3wF+l5x0TbhseBdHYInFHMGTfCO+50yWHPZFJh
QROOcN6dIHOyxdbOlDaVfmqAHW9RWyQo1QaTbYpESZ8yGAuoNcct+MRzYBQAAAD2NINjB49+UjeL
TM/32cM+tm2Efw==</Dsn>
<ConnectionType>Impersonate</ConnectionType>
<LogonUser>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAyJKMRfN3j0yU3k4Y0TdabAQAAAAiAAAAU
gBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAOINUpgdIZeEXU3n8qnQYtcAAAAA
BIAAAKAAAAAQAAAAsbOR9m0262nd6XCybTV/AiAAAABvYXDGqkvg5P2Zd55SPP6heZyNvw+jyQ+r
Lx6Qmhy7nhQAAAAEvamqoaAIum7GC7mn2c3IiMcUtA==</LogonUser>
<LogonDomain>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAyJKMRfN3j0yU3k4Y0TdabAQAAAAiAAA
AUgBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAEj5jp/Vyo7KnomNyHH0VwMAAAAA
BIAAAKAAAAAQAAAAuHejR1tO5W9Gf4JKYmy+dRAAAAAQ73ovMYnFVRfG5zOoUQfJFAAAAFuQzeMP
ZLNXEZQEpCbBr6McvXyD
</LogonDomain>
<LogonCred>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAyJKMRfN3j0yU3k4Y0TdabAQAAAAiAAAAU
gBlAHAAbwBy
AHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAACoAAAAEAAAAFEWJL8iLEIAFj7aVXNTX5wAAAAA
BIAAAKAAAAAQAAAAToDz75beiDZy9QrFubtrjiAAAADLxPycsLUM9WpDvQhs1fpBWiy9U2RD2eNh
gDQnPgdzfhQAAAC5rw7ykRDPFF4023KVrSatgcBgfQ==</LogonCred>
<InstanceId>MSSQL.1</InstanceId>
<InstallationID>{7a490394-c71b-41a1-982b-c4ad17dc026a}</InstallationID>
<Add Key="SecureConnectionLevel" Value="0"/>
<Add Key="InstanceName" Value="MSSQLSERVER"/>
<Add Key="ProcessRecycleOptions" Value="0"/>
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="SQLCommandTimeoutSeconds" Value="600"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DatabaseQueryTimeout" Value="1200"/>
<Add Key="RunningRequestsScavengerCycle" Value="60"/>
<Add Key="RunningRequestsDbCycle" Value="60"/>
<Add Key="RunningRequestsAge" Value="30"/>
<Add Key="MaxScheduleWait" Value="5"/>
<Add Key="DisplayErrorLink" Value="true"/>
<Service>
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<PollingInterval>10</PollingInterval>
<MemoryLimit>60</MemoryLimit>
<RecycleTime>720</RecycleTime>
<MaximumMemoryLimit>80</MaximumMemoryLimit>
<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://10.1.1.61/ReportServer2</UrlRoot>
<UnattendedExecutionAccount>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccount>
<PolicyLevel>rssrvpolicy.config</PolicyLevel>
</Service>
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvide
r,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,Report
ingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>10.1.1.245</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>cem@.hirzel.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,Reportin
gServicesNullDeliveryProvider"/>
</Delivery>
<Render>
<Extension Name="XML"
Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Mi
crosoft.ReportingServices.XmlRendering"/>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsof
t.ReportingServices.NullRendering" Visible="false"/>
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.
ReportingServices.CsvRendering"/>
<Extension Name="IMAGE"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Micros
oft.ReportingServices.ImageRendering"/>
<Extension Name="PDF"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsof
t.ReportingServices.ImageRendering"/>
<Extension Name="HTML4.0"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExte
nsion,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="HTML3.2"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExte
nsion,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="MHTML"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExten
sion,Microsoft.ReportingServices.HtmlRendering"/>
<Extension Name="EXCEL"
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Micr
osoft.ReportingServices.ExcelRendering"/>
<Extension Name="HTMLOWC"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExt
ension,Microsoft.ReportingServices.HtmlRendering">
<Configuration>
<OWCConfiguration>
<OWCDownloadLocation
language="de">http://office.microsoft.com/germany/downloads/2002/owc10.aspx<
/OWCDownloadLocation>
<OWCDownloadLocation
language="en">http://office.microsoft.com/downloads/2002/owc10.aspx</OWCDown
loadLocation>
<OWCDownloadLocation
language="ja">http://office.microsoft.com/japan/downloads/2002/owc10.aspx</O
WCDownloadLocation>
<OWCDownloadLocation
language="zh-chs">http://office.microsoft.com/china/downloads/2002/owc10.asp
x</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-cht">http://office.microsoft.com/china/downloads/2002/owc10.asp
x</OWCDownloadLocation>
<OWCDownloadLocation
language="es">http://office.microsoft.com/spain/downloads/2002/owc10.aspx</O
WCDownloadLocation>
<OWCDownloadLocation
language="ko">http://office.microsoft.com/korea/downloads/2002/owc10.aspx</O
WCDownloadLocation>
<OWCDownloadLocation
language="fr">http://office.microsoft.com/france/downloads/2002/owc10.aspx</
OWCDownloadLocation>
<OWCDownloadLocation
language="it">http://office.microsoft.com/italy/downloads/2002/owc10.aspx</O
WCDownloadLocation>
</OWCConfiguration>
</Configuration>
</Extension>
</Render>
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
oft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
osoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
er,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
soft.ReportingServices.DataExtensions"/>
</Data>
<Security>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,
Microsoft.ReportingServices.Authorization"/>
</Security>
<Authentication>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,
Microsoft.ReportingServices.Authorization"/>
</Authentication>
<EventProcessing>
<Extension Name="SnapShot Extension"
Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,Repo
rtingServicesLibrary">
<Event>
<Type>ReportHistorySnapshotCreated</Type>
</Event>
</Extension>
<Extension Name="Timed Subscription Extension"
Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,Reporting
ServicesLibrary">
<Event>
<Type>TimedSubscription</Type>
</Event>
</Extension>
<Extension Name="Cache Update Extension"
Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEvent
Handler,ReportingServicesLibrary">
<Event>
<Type>SnapshotUpdated</Type>
</Event>
</Extension>
</EventProcessing>
</Extensions>
</Configuration>
----
--
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServer__09_17_2004_10_24_27.log</Path>
<SystemName>DELL04-02</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!webserver!bac!9/17/2004-10:24:27:: i INFO: Reporting Web Server started
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing ConnectionType to
'1' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing IsEventService to
'True' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing PollingInterval
to '10' second(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing MemoryLimit to
'60' percent as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing MaxQueueThreads
to '0' thread(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing MaxScheduleWait
to '5' second(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
DatabaseQueryTimeout to '1200' second(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing InstanceName to
'MSSQLSERVER' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!bac!9/17/2004-10:24:27:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was
not specified in Configuration file.
w3wp!resourceutilities!bac!9/17/2004-10:24:27:: i INFO: Running on 1
physical processors, 2 logical processors
w3wp!resourceutilities!bac!9/17/2004-10:24:27:: i INFO: Reporting Services
starting SKU: Developer
w3wp!runningjobs!bac!9/17/2004-10:24:27:: i INFO: Database Cleanup (Web
Service) timer enabled: Cycle: 600 seconds
w3wp!runningjobs!bac!9/17/2004-10:24:27:: i INFO: Running Requests Scavenger
timer enabled: Cycle: 60 seconds
w3wp!runningjobs!bac!9/17/2004-10:24:27:: i INFO: Running Requests DB timer
enabled: Cycle: 60 seconds
w3wp!runningjobs!bac!9/17/2004-10:24:27:: i INFO: Memory stats update timer
enabled: Cycle: 60 seconds
w3wp!library!c84!09/17/2004-10:24:31:: i INFO: Call to GetPermissions:/
w3wp!crypto!c84!09/17/2004-10:24:31:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!c84!09/17/2004-10:24:31:: i INFO: Exporting public key
w3wp!crypto!c84!09/17/2004-10:24:31:: i INFO: Performing sku validation
w3wp!crypto!c84!09/17/2004-10:24:31:: i INFO: Importing existing encryption
key
w3wp!library!c84!09/17/2004-10:24:32:: i INFO: Call to GetSystemPermissions
w3wp!library!c84!09/17/2004-10:24:37:: i INFO: Call to
GetPermissions:/SalesReport
w3wp!library!c84!09/17/2004-10:24:37:: i INFO: Call to GetSystemPermissions
w3wp!library!bac!09/17/2004-10:24:45:: i INFO: Call to
GetPermissions:/SalesReport/BrokerSalesCaseAvgPrice
w3wp!library!bac!09/17/2004-10:24:45:: i INFO: Initializing
EnableIntegratedSecurity to 'True' as specified in Server system
properties.
w3wp!library!c84!09/17/2004-10:24:45:: i INFO: Call to GetSystemPermissions
w3wp!library!bac!09/17/2004-10:24:45:: i INFO: Initializing
ResponseBufferSizeKb to default value of '64' KB because it was not
specified in Server system properties.
w3wp!library!bac!09/17/2004-10:24:46:: i INFO: Initializing
UseSessionCookies to 'True' as specified in Server system properties.
w3wp!library!fa4!09/17/2004-10:24:47:: i INFO: Initializing SessionTimeout
to '600' second(s) as specified in Server system properties.
w3wp!library!fa4!09/17/2004-10:24:47:: i INFO: Initializing
SessionAccessTimeout to default value of '600' seconds because it was not
specified in Server system properties.
w3wp!session!fa4!09/17/2004-10:24:47:: i INFO: LoadSnapshot: Item with
session: rvoibn45odxph345gud0ok2d, reportPath:
/SalesReport/BrokerSalesCaseAvgPrice, userName: HIRZEL\cem not found in the
database
w3wp!library!fa4!09/17/2004-10:24:47:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesCaseAvgPrice' )
w3wp!library!fa4!09/17/2004-10:24:48:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!09/17/2004-10:24:57:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesCaseAvgPrice' )
w3wp!library!bac!09/17/2004-10:24:58:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!runningjobs!c84!9/17/2004-10:25:27:: i INFO: Adding: 2 running jobs to
the database
w3wp!library!c84!09/17/2004-10:25:58:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesCaseAvgPrice' )
w3wp!library!c84!09/17/2004-10:25:59:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!9/17/2004-10:26:49:: i INFO: Initializing
SqlStreamingBufferSize to default value of '64640' Bytes because it was not
specified in Server system properties.
w3wp!library!bac!9/17/2004-10:26:49:: i INFO: Initializing
SnapshotCompression to 'SQL' as specified in Server system properties.
w3wp!library!bac!09/17/2004-10:26:51:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!bac!09/17/2004-10:26:51:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice', Stream=''
w3wp!runningjobs!434!9/17/2004-10:27:27:: i INFO: Adding: 1 running jobs to
the database
w3wp!library!c84!09/17/2004-10:28:12:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!c84!09/17/2004-10:28:12:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice', Stream=''
w3wp!library!fa4!09/17/2004-10:34:26:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!fa4!09/17/2004-10:34:27:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice', Stream=''
w3wp!library!bac!9/17/2004-10:34:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!fa4!9/17/2004-10:44:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-10:54:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-11:04:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-11:14:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!09/17/2004-11:18:56:: i INFO: Call to GetPermissions:/
w3wp!library!c84!09/17/2004-11:18:56:: i INFO: Call to GetSystemPermissions
w3wp!library!c84!9/17/2004-11:24:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!9/17/2004-11:34:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!9/17/2004-11:44:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!9/17/2004-11:54:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!9/17/2004-12:04:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!c84!9/17/2004-12:14:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!fa4!9/17/2004-12:24:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-12:34:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-12:44:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!9/17/2004-12:54:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!fa4!9/17/2004-13:04:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!fa4!9/17/2004-13:14:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!fa4!09/17/2004-13:22:31:: i INFO: Call to GetPermissions:/
w3wp!library!fa4!09/17/2004-13:22:31:: i INFO: Call to GetSystemPermissions
w3wp!library!bac!09/17/2004-13:22:38:: i INFO: Call to
GetPermissions:/SalesReport
w3wp!library!bac!09/17/2004-13:22:38:: i INFO: Call to GetSystemPermissions
w3wp!library!fa4!09/17/2004-13:22:43:: i INFO: Call to
GetPermissions:/SalesReport/BrokerSalesCaseAvgPrice
w3wp!library!fa4!09/17/2004-13:22:43:: i INFO: Call to GetSystemPermissions
w3wp!library!fa4!09/17/2004-13:22:47:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesCaseAvgPrice' )
w3wp!library!fa4!09/17/2004-13:22:47:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!09/17/2004-13:22:55:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesCaseAvgPrice' )
w3wp!library!bac!09/17/2004-13:22:55:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!09/17/2004-13:23:07:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!bac!09/17/2004-13:23:07:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice', Stream=''
w3wp!webserver!bac!09/17/2004-13:23:08:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice',
Stream='b6e1061c-d8bd-46da-a12f-bc592acf8a64'
w3wp!webserver!8c!09/17/2004-13:23:09:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice',
Stream='ad1c7113-7c0f-4fe4-9cbe-c8cc01f79e68'
w3wp!webserver!8c!09/17/2004-13:23:09:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesCaseAvgPrice',
Stream='ad1c7113-7c0f-4fe4-9cbe-c8cc01f79e68'
w3wp!library!bac!09/17/2004-13:23:16:: i INFO: Call to
GetPermissions:/SalesReport
w3wp!library!bac!09/17/2004-13:23:16:: i INFO: Call to GetSystemPermissions
w3wp!library!8c!09/17/2004-13:23:18:: i INFO: Call to
GetPermissions:/SalesReport/BrokerSalesInCases
w3wp!library!8c!09/17/2004-13:23:19:: i INFO: Call to GetSystemPermissions
w3wp!library!8c!09/17/2004-13:23:27:: i INFO: Call to RenderFirst(
'/SalesReport/BrokerSalesInCases' )
w3wp!runningjobs!bac!9/17/2004-13:23:27:: i INFO: Adding: 1 running jobs to
the database
w3wp!library!8c!09/17/2004-13:23:28:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!8c!09/17/2004-13:23:33:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!8c!09/17/2004-13:23:33:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases', Stream=''
w3wp!webserver!8c!09/17/2004-13:23:34:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!webserver!bac!09/17/2004-13:23:34:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='e047512a-ef5d-4b99-b028-d5393752f24f'
w3wp!webserver!8c!09/17/2004-13:23:34:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!library!8c!09/17/2004-13:23:38:: i INFO: Call to RenderNext(
'/SalesReport/BrokerSalesInCases' )
w3wp!cache!8c!09/17/2004-13:23:38:: i INFO: Session live:
/SalesReport/BrokerSalesInCases
w3wp!webserver!8c!09/17/2004-13:23:38:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases', Stream=''
w3wp!webserver!8c!09/17/2004-13:23:39:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='e047512a-ef5d-4b99-b028-d5393752f24f'
w3wp!webserver!bac!09/17/2004-13:23:39:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!webserver!8c!09/17/2004-13:23:39:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!library!8c!09/17/2004-13:23:40:: i INFO: Call to RenderNext(
'/SalesReport/BrokerSalesInCases' )
w3wp!cache!8c!09/17/2004-13:23:40:: i INFO: Session live:
/SalesReport/BrokerSalesInCases
w3wp!webserver!8c!09/17/2004-13:23:40:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases', Stream=''
w3wp!webserver!8c!09/17/2004-13:23:41:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!webserver!bac!09/17/2004-13:23:41:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='e047512a-ef5d-4b99-b028-d5393752f24f'
w3wp!webserver!8c!09/17/2004-13:23:41:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!library!8c!09/17/2004-13:23:42:: i INFO: Call to RenderNext(
'/SalesReport/BrokerSalesInCases' )
w3wp!cache!8c!09/17/2004-13:23:43:: i INFO: Session live:
/SalesReport/BrokerSalesInCases
w3wp!webserver!8c!09/17/2004-13:23:43:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases', Stream=''
w3wp!webserver!bac!09/17/2004-13:23:43:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!webserver!8c!09/17/2004-13:23:43:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='e047512a-ef5d-4b99-b028-d5393752f24f'
w3wp!webserver!8c!09/17/2004-13:23:43:: i INFO: Processed report.
Report='/SalesReport/BrokerSalesInCases',
Stream='1fbe8216-66e6-47a1-9e2f-50368b35da83'
w3wp!library!bac!09/17/2004-13:23:49:: i INFO: Call to
GetPermissions:/SalesReport
w3wp!library!bac!09/17/2004-13:23:50:: i INFO: Call to GetSystemPermissions
w3wp!library!bac!09/17/2004-13:23:52:: i INFO: Call to
GetPermissions:/SalesReport/CustomerSalesByBillingAccount
w3wp!library!bac!09/17/2004-13:23:53:: i INFO: Call to GetSystemPermissions
w3wp!library!bac!09/17/2004-13:24:07:: i INFO: Call to RenderFirst(
'/SalesReport/CustomerSalesByBillingAccount' )
w3wp!library!bac!09/17/2004-13:24:08:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!09/17/2004-13:24:19:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!bac!09/17/2004-13:24:19:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount', Stream=''
w3wp!webserver!8c!09/17/2004-13:24:19:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!webserver!bac!09/17/2004-13:24:19:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='9c7edb88-15f2-4934-9b0a-c5ba442891b8'
w3wp!webserver!8c!09/17/2004-13:24:19:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!library!934!09/17/2004-13:24:22:: i INFO: Call to RenderNext(
'/SalesReport/CustomerSalesByBillingAccount' )
w3wp!cache!934!09/17/2004-13:24:22:: i INFO: Session live:
/SalesReport/CustomerSalesByBillingAccount
w3wp!webserver!934!09/17/2004-13:24:22:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount', Stream=''
w3wp!webserver!bac!09/17/2004-13:24:23:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='9c7edb88-15f2-4934-9b0a-c5ba442891b8'
w3wp!webserver!934!09/17/2004-13:24:23:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!webserver!bac!09/17/2004-13:24:23:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!library!934!9/17/2004-13:24:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!bac!09/17/2004-13:24:53:: i INFO: Call to RenderFirst(
'/SalesReport/CustomerSalesByBillingAccount' )
w3wp!library!bac!09/17/2004-13:24:54:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The
item '/SalesReport/hirzellogobackground' cannot be found.
w3wp!library!bac!09/17/2004-13:25:03:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!bac!09/17/2004-13:25:03:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount', Stream=''
w3wp!webserver!934!09/17/2004-13:25:03:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='9c7edb88-15f2-4934-9b0a-c5ba442891b8'
w3wp!webserver!bac!09/17/2004-13:25:03:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!webserver!934!09/17/2004-13:25:03:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!library!8c!09/17/2004-13:25:08:: i INFO: Call to RenderNext(
'/SalesReport/CustomerSalesByBillingAccount' )
w3wp!cache!8c!09/17/2004-13:25:08:: i INFO: Session live:
/SalesReport/CustomerSalesByBillingAccount
w3wp!webserver!8c!09/17/2004-13:25:08:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount', Stream=''
w3wp!webserver!8c!09/17/2004-13:25:08:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='9c7edb88-15f2-4934-9b0a-c5ba442891b8'
w3wp!webserver!bac!09/17/2004-13:25:08:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!webserver!8c!09/17/2004-13:25:09:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount',
Stream='cb8f8726-fe69-4913-83ff-c8b772a41f19'
w3wp!library!8c!09/17/2004-13:25:15:: i INFO: Call to RenderNext(
'/SalesReport/CustomerSalesByBillingAccount' )
w3wp!chunks!8c!09/17/2004-13:25:15:: i INFO: ###
GetReportChunk('RenderingInfo_EXCEL', 2), chunk was not found!
this=4a2b5a60-bf8e-4e04-8652-7435411127e1
w3wp!cache!8c!09/17/2004-13:25:19:: i INFO: Session live:
/SalesReport/CustomerSalesByBillingAccount
w3wp!webserver!8c!09/17/2004-13:25:19:: i INFO: Processed report.
Report='/SalesReport/CustomerSalesByBillingAccount', Stream=''
w3wp!library!8c!09/17/2004-13:32:59:: i INFO: Call to CreateReport(
'CustomerSalesByBillingAccount', '/SalesReport', def)
w3wp!library!8c!09/17/2004-13:32:59:: i INFO: Call to SetReportDefinition(
'/SalesReport/CustomerSalesByBillingAccount', def )
w3wp!library!8c!9/17/2004-13:34:27:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
---
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerWebApp__09_17_2004_10_24_17.log</Path>
<SystemName>DELL04-02</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing MaxScheduleWait
to default value of '1' second(s) because it was not specified in
Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
DatabaseQueryTimeout to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing InstanceName to
default value of 'MSSQLSERVER.1' because it was not specified in
Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
ProcessRecycleOptions to default value of '0' because it was not specified
in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
RunningRequestsScavengerCycle to default value of '30' second(s) because it
was not specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
RunningRequestsDbCycle to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
RunningRequestsAge to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
CleanupCycleMinutes to default value of '10' minute(s) because it was not
specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not specified
in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!fa4!9/17/2004-10:24:17:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was
not specified in Configuration file.|||Check the IIS timeout for the Report Manager website.

Report timeout after 60 minutes

I'm running a long report from Reporting Services web site. When I run
the stored procedure by itself, it executes with no problem, taking
about 3 hours to complete. When I execute the report itself, it runs
for exactly 60 minutes and after that I get "The page can not be
displayed" message. I played around with session timeouts and report
execution timeout setting both of these to 5 hours, however that didn't
give any positive results. I'm beginning to think that it maybe some
IIS issue. I also increased the connection timeout in IIS to 5 hours.
Does anyone have any clues?
I'm running this on Windows 2000, IIS 5.
Thank you.
-IKI solved the problem myself. Looks like IE version 5.x and higher,
have 60 minute time-out limit.
A quick registry setting and a restart fixes the problem.
1. Add a ReceiveTimeout DWORD value with a data value of (<number of
seconds>)*1000 in the following registry key:
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet
Settings
For example, if you want the timeout duration to be 8 minutes, set the
ReceiveTimeout data value to 480000 (<480>*1000).
2. Restart your computer.
You can find more info at:
http://support.microsoft.com/kb/q181050/
-IK|||hi IK,
one clarification.
need to set this on the server or on the client.
i am adjusting this setting on a comp connecting to the server and checking
this out.
would be quite a relief to get round this one.
thanks for your note,
SamK
"IK" wrote:
> I solved the problem myself. Looks like IE version 5.x and higher,
> have 60 minute time-out limit.
> A quick registry setting and a restart fixes the problem.
> 1. Add a ReceiveTimeout DWORD value with a data value of (<number of
> seconds>)*1000 in the following registry key:
> HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet
> Settings
> For example, if you want the timeout duration to be 8 minutes, set the
> ReceiveTimeout data value to 480000 (<480>*1000).
> 2. Restart your computer.
>
> You can find more info at:
> http://support.microsoft.com/kb/q181050/
> -IK
>sql

Report timeout - long running SPROC

Hi all,
I have a SPROC that returns 773,923 rows and takes 13mins to execute in SQL
Query Analyzer.
I think I have increased all available timeout and session settings, but the
report returns page cannot be displayed.
The same happens when I try to create a snapshot.
Any ideas?
Thank you in advance.
Cheers
ShaneThis is a very bad idea. RS renders everything in RAM. Depending on the
format it can take varying amounts of time. If you try to render to PDF or
Excel (can Excel even take that many rows, I'm not sure what the limit is
now, it was 64K in Excel 2000) it will most likely never finish. What are
you trying to do, a human will never look at that many rows. If you are
trying to do data extraction then there are better technologies to use. HTML
is fast and might be possible but not sure what it buys you since this is
probably 100,000 rows of data. I suggest reading up on drill through, that
is a very good technique for navigating large amounts of data. If you
explain what you are trying to do there might be some other way to
accomplish it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shane" <s.dixon@.hia.asn.auNOSPAM> wrote in message
news:86D96692-5AD5-4BC0-953D-99A53D623AE3@.microsoft.com...
> Hi all,
> I have a SPROC that returns 773,923 rows and takes 13mins to execute in
> SQL
> Query Analyzer.
> I think I have increased all available timeout and session settings, but
> the
> report returns page cannot be displayed.
> The same happens when I try to create a snapshot.
> Any ideas?
> Thank you in advance.
> Cheers
> Shane|||Thanks for taking the time to read my post Bruce.
The report is an age trial balance for our entire organisation. So each line
(all 773,923 rows) are invoice lines.
It allows our snr management to see what debt are owed to our company.
I use a drill down so when the report is initially loaded you see each of my
company's regions (10 of them) and the sum of the money owed by age 30 Days,
60-90 Days, 120+ Days...
If you click on the + it expands to reveal the different general leger
accounts and the sum of the money owed by age 30 Days, 60-90 Days, 120+
Days...
If you click on the + again, it will display the person who owes the money
and the sum of the money owed by age 30 Days, 60-90 Days, 120+ Days...
If you click on the + again, it will display each of the invoice details..
The report is being rendered in HTML and I also want the execution snapshot
to be rendered in HTML as well.
Cheers,
Shane
"Bruce L-C [MVP]" wrote:
> This is a very bad idea. RS renders everything in RAM. Depending on the
> format it can take varying amounts of time. If you try to render to PDF or
> Excel (can Excel even take that many rows, I'm not sure what the limit is
> now, it was 64K in Excel 2000) it will most likely never finish. What are
> you trying to do, a human will never look at that many rows. If you are
> trying to do data extraction then there are better technologies to use. HTML
> is fast and might be possible but not sure what it buys you since this is
> probably 100,000 rows of data. I suggest reading up on drill through, that
> is a very good technique for navigating large amounts of data. If you
> explain what you are trying to do there might be some other way to
> accomplish it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shane" <s.dixon@.hia.asn.auNOSPAM> wrote in message
> news:86D96692-5AD5-4BC0-953D-99A53D623AE3@.microsoft.com...
> > Hi all,
> >
> > I have a SPROC that returns 773,923 rows and takes 13mins to execute in
> > SQL
> > Query Analyzer.
> >
> > I think I have increased all available timeout and session settings, but
> > the
> > report returns page cannot be displayed.
> >
> > The same happens when I try to create a snapshot.
> >
> > Any ideas?
> >
> > Thank you in advance.
> >
> > Cheers
> >
> > Shane
>
>|||OK, that is what I thought. Drill downs are great. Very intuitive.
Unfortunately they require all the data to be present. So although it is
great for the user it is not so a great a solution for speed. What I suggest
is to change this to limit the amount of data. Perhaps make it a combination
of drilldown and drillthrough. For instance, how much data is decreased if
you do a drillthrough for the involice details. Or perhaps the Person and
the invoice details. Make that it's own report with the appropriate
parameters and then drill through to it. My guess is that the sp would speed
up tremendously and the amount of data being dealt with by RS would drop to
a manageable level. My users (a very wide range from production operators to
management) have found drillthough to be very intuitive.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shane" <s.dixon@.hia.asn.auNOSPAM> wrote in message
news:3A3D9583-DF23-43B9-806F-0B4DD3A68F12@.microsoft.com...
> Thanks for taking the time to read my post Bruce.
> The report is an age trial balance for our entire organisation. So each
> line
> (all 773,923 rows) are invoice lines.
> It allows our snr management to see what debt are owed to our company.
> I use a drill down so when the report is initially loaded you see each of
> my
> company's regions (10 of them) and the sum of the money owed by age 30
> Days,
> 60-90 Days, 120+ Days...
> If you click on the + it expands to reveal the different general leger
> accounts and the sum of the money owed by age 30 Days, 60-90 Days, 120+
> Days...
> If you click on the + again, it will display the person who owes the money
> and the sum of the money owed by age 30 Days, 60-90 Days, 120+ Days...
> If you click on the + again, it will display each of the invoice details..
> The report is being rendered in HTML and I also want the execution
> snapshot
> to be rendered in HTML as well.
> Cheers,
> Shane
> "Bruce L-C [MVP]" wrote:
>> This is a very bad idea. RS renders everything in RAM. Depending on the
>> format it can take varying amounts of time. If you try to render to PDF
>> or
>> Excel (can Excel even take that many rows, I'm not sure what the limit is
>> now, it was 64K in Excel 2000) it will most likely never finish. What are
>> you trying to do, a human will never look at that many rows. If you are
>> trying to do data extraction then there are better technologies to use.
>> HTML
>> is fast and might be possible but not sure what it buys you since this is
>> probably 100,000 rows of data. I suggest reading up on drill through,
>> that
>> is a very good technique for navigating large amounts of data. If you
>> explain what you are trying to do there might be some other way to
>> accomplish it.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Shane" <s.dixon@.hia.asn.auNOSPAM> wrote in message
>> news:86D96692-5AD5-4BC0-953D-99A53D623AE3@.microsoft.com...
>> > Hi all,
>> >
>> > I have a SPROC that returns 773,923 rows and takes 13mins to execute in
>> > SQL
>> > Query Analyzer.
>> >
>> > I think I have increased all available timeout and session settings,
>> > but
>> > the
>> > report returns page cannot be displayed.
>> >
>> > The same happens when I try to create a snapshot.
>> >
>> > Any ideas?
>> >
>> > Thank you in advance.
>> >
>> > Cheers
>> >
>> > Shane
>>|||Thanks again Bruce.
I think the drillthrough idea sounds like a good one. Similar to this Sample
report:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_samplereports_v1_4z95.asp
I'll give it a go and let you know how I go! :)
Cheers,
Shane
"Bruce L-C [MVP]" wrote:
> OK, that is what I thought. Drill downs are great. Very intuitive.
> Unfortunately they require all the data to be present. So although it is
> great for the user it is not so a great a solution for speed. What I suggest
> is to change this to limit the amount of data. Perhaps make it a combination
> of drilldown and drillthrough. For instance, how much data is decreased if
> you do a drillthrough for the involice details. Or perhaps the Person and
> the invoice details. Make that it's own report with the appropriate
> parameters and then drill through to it. My guess is that the sp would speed
> up tremendously and the amount of data being dealt with by RS would drop to
> a manageable level. My users (a very wide range from production operators to
> management) have found drillthough to be very intuitive.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shane" <s.dixon@.hia.asn.auNOSPAM> wrote in message
> news:3A3D9583-DF23-43B9-806F-0B4DD3A68F12@.microsoft.com...
> > Thanks for taking the time to read my post Bruce.
> >
> > The report is an age trial balance for our entire organisation. So each
> > line
> > (all 773,923 rows) are invoice lines.
> >
> > It allows our snr management to see what debt are owed to our company.
> >
> > I use a drill down so when the report is initially loaded you see each of
> > my
> > company's regions (10 of them) and the sum of the money owed by age 30
> > Days,
> > 60-90 Days, 120+ Days...
> >
> > If you click on the + it expands to reveal the different general leger
> > accounts and the sum of the money owed by age 30 Days, 60-90 Days, 120+
> > Days...
> >
> > If you click on the + again, it will display the person who owes the money
> > and the sum of the money owed by age 30 Days, 60-90 Days, 120+ Days...
> >
> > If you click on the + again, it will display each of the invoice details..
> >
> > The report is being rendered in HTML and I also want the execution
> > snapshot
> > to be rendered in HTML as well.
> >
> > Cheers,
> >
> > Shane
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> This is a very bad idea. RS renders everything in RAM. Depending on the
> >> format it can take varying amounts of time. If you try to render to PDF
> >> or
> >> Excel (can Excel even take that many rows, I'm not sure what the limit is
> >> now, it was 64K in Excel 2000) it will most likely never finish. What are
> >> you trying to do, a human will never look at that many rows. If you are
> >> trying to do data extraction then there are better technologies to use.
> >> HTML
> >> is fast and might be possible but not sure what it buys you since this is
> >> probably 100,000 rows of data. I suggest reading up on drill through,
> >> that
> >> is a very good technique for navigating large amounts of data. If you
> >> explain what you are trying to do there might be some other way to
> >> accomplish it.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Shane" <s.dixon@.hia.asn.auNOSPAM> wrote in message
> >> news:86D96692-5AD5-4BC0-953D-99A53D623AE3@.microsoft.com...
> >> > Hi all,
> >> >
> >> > I have a SPROC that returns 773,923 rows and takes 13mins to execute in
> >> > SQL
> >> > Query Analyzer.
> >> >
> >> > I think I have increased all available timeout and session settings,
> >> > but
> >> > the
> >> > report returns page cannot be displayed.
> >> >
> >> > The same happens when I try to create a snapshot.
> >> >
> >> > Any ideas?
> >> >
> >> > Thank you in advance.
> >> >
> >> > Cheers
> >> >
> >> > Shane
> >>
> >>
> >>
>
>

Report Timeout

I have designed a report that hits a large table of over a million rows. The report runs in the development environment as a preview. When deployed, the report runs about 1.5 hours and then returns an error. The report is set not to timeout. What could be causing this behavior?What error is being returned?
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"DJP" <DJP@.discussions.microsoft.com> wrote in message
news:D8468C56-4D72-47FB-AA76-9A82D8A9CDAC@.microsoft.com...
> I have designed a report that hits a large table of over a million rows.
The report runs in the development environment as a preview. When deployed,
the report runs about 1.5 hours and then returns an error. The report is
set not to timeout. What could be causing this behavior?|||The page displayed is: The page cannot be displayed
"Bruce Johnson [MSFT]" wrote:
> What error is being returned?
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "DJP" <DJP@.discussions.microsoft.com> wrote in message
> news:D8468C56-4D72-47FB-AA76-9A82D8A9CDAC@.microsoft.com...
> > I have designed a report that hits a large table of over a million rows.
> The report runs in the development environment as a preview. When deployed,
> the report runs about 1.5 hours and then returns an error. The report is
> set not to timeout. What could be causing this behavior?
>
>

Report Timeout

I have a report I execute from an Asp.Net front-end. The report is rendered
directly to PDF via a web services call to the Reporting Services web
service. For this particular report, at exactly 3 minutes, the report always
aborts processing and redirects to a "Page Cannot Be Displayed". The Report
Server log file at this time shows IsClientConnected...Orphan Request
detected or something like that. When I run the report via Report Manager,
everything works fine. I do specify a timeout value of 2400000 in my Asp.Net
where I'm consuming the web service. I've looked at almost every other
timeout but since it works fine in Report Manager, I am inclined to believe
the problem is in my Asp.Net code. Any ideas?Open your Reporing service's web service reference file and in the
constructor
add: "this.Timeout=......"
Works for web service access method.
"AdamB" <AdamB@.discussions.microsoft.com> wrote in message
news:290174E9-D359-4376-9EC7-591FC3421D74@.microsoft.com...
>I have a report I execute from an Asp.Net front-end. The report is
>rendered
> directly to PDF via a web services call to the Reporting Services web
> service. For this particular report, at exactly 3 minutes, the report
> always
> aborts processing and redirects to a "Page Cannot Be Displayed". The
> Report
> Server log file at this time shows IsClientConnected...Orphan Request
> detected or something like that. When I run the report via Report
> Manager,
> everything works fine. I do specify a timeout value of 2400000 in my
> Asp.Net
> where I'm consuming the web service. I've looked at almost every other
> timeout but since it works fine in Report Manager, I am inclined to
> believe
> the problem is in my Asp.Net code. Any ideas?|||I'm not sure where this file is that you are referring to. Also, in my
Asp.Net where I am consuming the web service, I am doing the following:
Dim rs As New WebService (where WebService is the name of my reference to
the Reporting Service ws)
rs.Timeout = 2400000
"Oleg Yevteyev" wrote:
> Open your Reporing service's web service reference file and in the
> constructor
> add: "this.Timeout=......"
> Works for web service access method.
> "AdamB" <AdamB@.discussions.microsoft.com> wrote in message
> news:290174E9-D359-4376-9EC7-591FC3421D74@.microsoft.com...
> >I have a report I execute from an Asp.Net front-end. The report is
> >rendered
> > directly to PDF via a web services call to the Reporting Services web
> > service. For this particular report, at exactly 3 minutes, the report
> > always
> > aborts processing and redirects to a "Page Cannot Be Displayed". The
> > Report
> > Server log file at this time shows IsClientConnected...Orphan Request
> > detected or something like that. When I run the report via Report
> > Manager,
> > everything works fine. I do specify a timeout value of 2400000 in my
> > Asp.Net
> > where I'm consuming the web service. I've looked at almost every other
> > timeout but since it works fine in Report Manager, I am inclined to
> > believe
> > the problem is in my Asp.Net code. Any ideas?
>
>|||Ok, I think you're talking about the Reference.vb file but I have no idea
where this timeout setting is supposed to go.
Adam
"Oleg Yevteyev" wrote:
> Open your Reporing service's web service reference file and in the
> constructor
> add: "this.Timeout=......"
> Works for web service access method.
> "AdamB" <AdamB@.discussions.microsoft.com> wrote in message
> news:290174E9-D359-4376-9EC7-591FC3421D74@.microsoft.com...
> >I have a report I execute from an Asp.Net front-end. The report is
> >rendered
> > directly to PDF via a web services call to the Reporting Services web
> > service. For this particular report, at exactly 3 minutes, the report
> > always
> > aborts processing and redirects to a "Page Cannot Be Displayed". The
> > Report
> > Server log file at this time shows IsClientConnected...Orphan Request
> > detected or something like that. When I run the report via Report
> > Manager,
> > everything works fine. I do specify a timeout value of 2400000 in my
> > Asp.Net
> > where I'm consuming the web service. I've looked at almost every other
> > timeout but since it works fine in Report Manager, I am inclined to
> > believe
> > the problem is in my Asp.Net code. Any ideas?
>
>|||"AdamB" <AdamB@.discussions.microsoft.com> wrote in message
news:D19C1C10-7F24-4834-9EAC-7A20650CE348@.microsoft.com...
> I'm not sure where this file is that you are referring to. Also, in my
> Asp.Net where I am consuming the web service, I am doing the following:
> Dim rs As New WebService (where WebService is the name of my reference to
> the Reporting Service ws)
> rs.Timeout = 2400000
Ok - seems like it is correct - just be sure to set that Timeout property on
every instance of "ws" you are creating.
More simple way is to open the reference file you correctly identified in
another post and place "rs.Timeout = 2400000"
in the constructor. In that case you wouldn't have to set that property on
every instance of "ws" you're creating.
I hope, you know what the constructor is.
There are a couple more places to check.
1. You can set in Page_Load method of your page
Server.ScriptTimeout=2400
2. Do it globally in machine.config or web.config
<configuration>
<system.web>
<httpRuntime executionTimeout="2400"
................................/>
in addtion of what you have already done.