I'm doing a distributed Transaction using Oracle and Sql Server. Everything succeeds including commiting the results to Oracle and SQL Server but I recieve the following exception in the Debugger.
{"Unable to cast object of type 'Devart.Data.Oracle.ak' to type 'Devart.Data.Oracle.a3'."}
System.InvalidCastException was unhandled
Message=Unable to cast object of type 'Devart.Data.Oracle.ak' to type 'Devart.Data.Oracle.a3'.
Source=Devart.Data.Oracle
StackTrace:
at Devart.Data.Oracle.OracleInternalConnection.a()
at Devart.Common.DbConnectionInternal.f()
at Devart.Common.DbConnectionInternal.CloseInternalConnection()
at Devart.Common.DbConnectionInternal.a(Object A_0, TransactionEventArgs A_1)
at System.Transactions.TransactionCompletedEventHandler.Invoke(Object sender, TransactionEventArgs e)
at System.Transactions.TransactionStateCommitted.EnterState(InternalTransaction tx)
at System.Transactions.SinglePhaseEnlistment.Committed()
at System.Data.SqlClient.SqlDelegatedTransaction.SinglePhaseCommit(SinglePhaseEnlistment enlistment)
at System.Transactions.DurableEnlistmentCommitting.EnterState(InternalEnlistment enlistment)
at System.Transactions.PreparingEnlistment.Prepared()
at Devart.Common.s.a(PreparingEnlistment A_0)
at System.Transactions.VolatileEnlistmentPreparing.EnterState(InternalEnlistment enlistment)
at System.Transactions.TransactionStateVolatilePhase1.EnterState(InternalTransaction tx)
at System.Transactions.CommittableTransaction.Commit()
at System.Transactions.TransactionScope.InternalDispose()
at System.Transactions.TransactionScope.Dispose()
at Raytheon.Highways.DataTransferAgent.UnmatchedFingerprintHandler.ProcessAnyUnmatchedFingerprints() in D:\source\Dave\DataTransferAgentGui.root\DataTransferAgentGui\DataTransferAgentGui\UnmatchedFingerprintHandler.cs:line 97
at Raytheon.Highways.DataTransferAgent.UnmatchedFingerprintHandler.ProcessUnmatchedFingerprintRequest() in D:\source\Dave\DataTransferAgentGui.root\DataTransferAgentGui\DataTransferAgentGui\UnmatchedFingerprintHandler.cs:line 45
at System.Threading.ExecutionContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException:
Unable to cast exception in Distributed Transaction
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Fails using Direct Connection
This appears to only happen if I choose direct connection. It is working now if I use an Oracle home.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44