ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Transaction Issue : System.NullReferenceException from OracleConnection.Beg

576967May 10 2007 — edited Jun 27 2007

Hi,
We have a .Net web application with Oracle 9i as back-end. As part of maintenance activities, we recycle the site at 4:00 AM everyday, when the load is supposed to be low but not necessarily zero. We are noticing that after the recycle, the application is throwing the below error :

Error Message = System.NullReferenceException: Object reference not set to an instance of an object.
at Oracle.DataAccess.Client.OracleConnection.BeginTransaction()

My guess is, this is happening when Oracle was in the middle of a transaction from a session and the application pool was recycled.From then on, all requests for a new transaction fails with the above exception.

Is this a known BUG ? Is there a solution or work around for it ?

The issue gets resolved only when a second recycle is done - sometimes that does not work either and the website has to be stopped and restarted.

Any inputs would be appreciated.

Best Regards,
Partha

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 25 2007

Added on May 10 2007

#odp-net

3 comments

2,061 views