Hi,
Nhibernate code from one of our WCF webservice is at times throwing "Connection must be open for this operation" on production server. This issue was not very regular - 999 out of 1000 executions work without error, and then suddenly “Connection must be open for this operation” error occurs. Also please note that there are no Network and Oracle RAC issues found when we encounter the above issue. Windows system admins cannot find any reasons for this. we were not able to re-produce the same error on developement environment using SOAP UI tool load test capabilities.

Does any one encountered similar issue? Any inputs on how to reproduce the issue is highly appriciated.

Below are execption details:

Type : System.InvalidOperationException, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Connection must be open for this operation
Source : Oracle.DataAccess

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
An exception of type 'NHibernate.ADOException' occurred and was caught.
Server stack trace:
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in C:\Documents and Settings\rharding\Desktop\NHibernate-1.2.1.GA-src\src\NHibernate\Loader\Loader.cs:line 1803
at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) in C:\Documents and Settings\rharding\Desktop\NHibernate-1.2.1.GA-src\src\NHibernate\Loader\Loader.cs:line 1745
at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes) in C:\Documents and Settings\rharding\Desktop\NHibernate-1.2.1.GA-src\src\NHibernate\Loader\Loader.cs:line 1733
at NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria, IList results) in C:\Documents and Settings\rharding\Desktop\NHibernate-1.2.1.GA-src\src\NHibernate\Impl\SessionImpl.cs:line 4963
at NHibernate.Impl.SessionImpl.Find[T](CriteriaImpl criteria) in C:\Documents and Settings\rharding\Desktop\NHibernate-1.2.1.GA-src\src\NHibernate\Impl\SessionImpl.cs:line 4914
at NHibernate.Impl.CriteriaImpl.List[T]() in C:\Documents and Settings\rharding\Desktop\NHibernate-1.2.1.GA-src\src\NHibernate\Impl\CriteriaImpl.cs:line 323

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Regards,
Kumar.