I have an ASP.NET application runinng on IIS 5 .NET 1.1 Sp1 and recently
we've been experiencing this error when the users are trying to print reports
that connects to Oracle database. The only way to solve the issue right now
is to restart the server or IIS and this is the error message:
--------------------------------------------------------------------------------------
TargetSite : System.Data.OracleClient.DBPooledObject
GetObject(System.Object, Boolean ByRef)
Stack Trace : at System.Data.OracleClient.DBObjectPool.GetObject(Ob ject
owningObject, Boolean& isInTransaction)
at
System.Data.OracleClient.OracleConnectionPoolManag er.GetPooledConnection(String
encryptedConnectionString, OracleConnectionString options, OracleConnection
owningObject, Boolean& isInTransaction)
at
System.Data.OracleClient.OracleConnection.OpenInte rnal(OracleConnectionString
parsedConnectionString, Object transact)
at System.Data.OracleClient.OracleConnection.Open()
at Microsoft.Practices.EnterpriseLibrary.Data.Databas e.OpenConnection()
at
Microsoft.Practices.EnterpriseLibrary.Data.Databas e.ExecuteReader(DBCommandWrapper command)
at
Microsoft.Practices.EnterpriseLibrary.Data.Oracle. OracleDatabase.ExecuteReader(DBCommandWrapper commandWrapper)
at EssessmentDataAccessLayer.clsPMRFormDAL.get_dt_PMR _by_PMR_ID(Int32
PMR_ID)
--------------------------------------------------------------------------------------
So it look like that this an Oracle database pool issue but I don't know how
to address and any suggestions would be helpful.