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.