Guys,

I am still struggling with report time out issue. All my reports run about
60 seconds after that, they time out. I am pretty sure it is a settings
issue,but so far I couldn't find the main cause. Below you may find my
config and log files. IIS time out is set to 1800 secs.

Thank you.
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<

Jeff,

I encounter this problem only on a few reports. Also, if I run the
problematic reports with smaller datasets, they work great.

Thanks.

CD


[quoted text, click to view]