Windows Oracle Data Access Components (MOSC)

MOSC Banner

Distributed transaction recovery from ODP.NET 11.2.0.2.0 to Unix based Oracle 10g instance

edited Jun 10, 2012 8:44PM in Windows Oracle Data Access Components (MOSC) 6 commentsAnswered
Hi, I'm not sure if this is the right place to be asking the question, so please redirect me if so.
We've written some .Net 4 based software that uses NServiceBus to pick up MSMQ messages from a transactional queue, make some changes in our Oracle DB (via ODP.NET 11.2.0.2.0) and send messages to another MSMQ queue. By virtue of NServiceBus, the  whole process gets wrapped up in a distributed transaction.

The system is happily processing millions of events, but occasionally we'll get an entry in dba_2pc_pending showing a transaction in the 'prepared' state that never goes away. At the same time we get an entry in the Microsoft 'Local DTC\Transaction List' mmc snap-in listed as '(only failed to notify)'.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center