RS SP2 / Oracle 10g Error Is Back

Yesterday RS kept bombing out from time to time with an Oracle error. Each
time we would do an iisreset and the issue would correct itself.
I reinstalled RS with SP2 last night. Today things ran smooth for about 5
hours, then the issue reappeared.
Of particular interest from the RS log file:
"The timeout period elapsed prior to obtaining a connection from the pool.
This may have occurred because all pooled connections were in use and max
pool size was reached."
Here's the context of the error in the log file:
w3wp!library!ae0!11/10/2005-13:49:06:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!ae0!11/10/2005-13:49:06:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has
occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. -->
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Cannot create a connection to data source 'dbReports'. -->
System.InvalidOperationException: Timeout expired. The timeout period
elapsed prior to obtaining a connection from the pool. This may have
occurred because all pooled connections were in use and max pool size was
reached.
w3wp!runningjobs!1254!11/10/2005-13:49:48:: i INFO: Adding: 1 running jobs
to the database
w3wp!library!ae0!11/10/2005-13:54:36:: i INFO: Call to RenderFirst( '[folder
/ report name was here]')
w3wp!processing!ae0!11/10/2005-13:55:06:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Cannot create a connection to data source 'dbReports'., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Cannot create a connection to data source 'dbReports'. -->
System.InvalidOperationException: Timeout expired. The timeout period
elapsed prior to obtaining a connection from the pool. This may have
occurred because all pooled connections were in use and max pool size was
reached.
at
System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String
encryptedConnectionString, OracleConnectionString options, OracleConnection
owningObject, Boolean& isInTransaction)
at
System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString
parsedConnectionString, Object transact)
at System.Data.OracleClient.OracleConnection.Open()
at Microsoft.ReportingServices.DataExtensions.ConnectionExtension.Open()
at Microsoft.ReportingServices.ReportProcessing.s.a(DataSource A_0, ab
A_1)
Is anyone running RS with Oracle 10g? If so, have you seen anything like
this?
Thanks in advance.More info from the 10g install -
This document provides information that supplements the Oracle Data Provider
for .NET (ODP.NET) documentation.
=======================DOCUMENTATION ADDENDUMS
=======================
1. Connection Pool Management Methods (New Feature)
Two new connection pool management methods have been introduced in
ODP.NET
10.2.0.1.0. ODP.NET applications can explicitly clear connections in a
connection pool through the ClearPool() or ClearAllPools() static method
on the OracleConnection object.
I'm guessing that Reporting Services doesn't know about this and the pools
are filling up. Just an FYI in case anyone hits this in the future.
For the moment, I've attempted installing the 9i client on the box hoping
that Reporting Services will resort to the 9i drivers. I'll let you know if
I see any difference.
"Jack" <anonymous@.microsoft.com> wrote in message
news:uh2QmHk5FHA.2040@.TK2MSFTNGP14.phx.gbl...
> Yesterday RS kept bombing out from time to time with an Oracle error.
> Each time we would do an iisreset and the issue would correct itself.
> I reinstalled RS with SP2 last night. Today things ran smooth for about 5
> hours, then the issue reappeared.
> Of particular interest from the RS log file:
> "The timeout period elapsed prior to obtaining a connection from the pool.
> This may have occurred because all pooled connections were in use and max
> pool size was reached."
> Here's the context of the error in the log file:
> w3wp!library!ae0!11/10/2005-13:49:06:: i INFO: Initializing
> EnableExecutionLogging to 'True' as specified in Server system
> properties.
> w3wp!webserver!ae0!11/10/2005-13:49:06:: e ERROR: Reporting Services error
> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error
> has occurred during report processing. -->
> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:
> An error has occurred during report processing. -->
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> Cannot create a connection to data source 'dbReports'. -->
> System.InvalidOperationException: Timeout expired. The timeout period
> elapsed prior to obtaining a connection from the pool. This may have
> occurred because all pooled connections were in use and max pool size was
> reached.
> w3wp!runningjobs!1254!11/10/2005-13:49:48:: i INFO: Adding: 1 running jobs
> to the database
> w3wp!library!ae0!11/10/2005-13:54:36:: i INFO: Call to RenderFirst(
> '[folder / report name was here]')
> w3wp!processing!ae0!11/10/2005-13:55:06:: e ERROR: Throwing
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> Cannot create a connection to data source 'dbReports'., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
> Cannot create a connection to data source 'dbReports'. -->
> System.InvalidOperationException: Timeout expired. The timeout period
> elapsed prior to obtaining a connection from the pool. This may have
> occurred because all pooled connections were in use and max pool size was
> reached.
> at
> System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String
> encryptedConnectionString, OracleConnectionString options,
> OracleConnection owningObject, Boolean& isInTransaction)
> at
> System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString
> parsedConnectionString, Object transact)
> at System.Data.OracleClient.OracleConnection.Open()
> at Microsoft.ReportingServices.DataExtensions.ConnectionExtension.Open()
> at Microsoft.ReportingServices.ReportProcessing.s.a(DataSource A_0, ab
> A_1)
> Is anyone running RS with Oracle 10g? If so, have you seen anything like
> this?
> Thanks in advance.
>