Skip to Main Content

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!

DbCommand timing out after an hour

bwalther766Apr 4 2020 — edited Apr 5 2020

I have a long running query that's timing out after an hour, but I can't find any timeout values specified. The DbCommand has its timeout set to 0. This is wrapped within an OracleTransaction, but I can't find any timeouts at that level. On the client all I'm getting is "System.InvalidOperationException: The transaction associated with the connection has completed but not yet disposed.  Dispose the transaction to execute SQL statements on this connection" on ExecuteNonQuery for the *next* query. I'm not finding anything in the database alert log. I enabled tracing on the client, but I'm not sure what I'm looking for. I see an XCTEND rlbk=1 rd_only=0.

Any advice on why my query's timing out after an hour?

Comments

Post Details

Added on Apr 4 2020
1 comment
665 views