Unable to cast exception in Distributed Transaction

Unable to cast exception in Distributed Transaction

Postby djryan » Mon 05 Dec 2011 21:14

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:
djryan
 
Posts: 2
Joined: Wed 30 Nov 2011 17:42

Postby Pinturiccio » Tue 06 Dec 2011 13:35

We could not reproduce the issue. Could you please specify the version and edition of dotConnect for Oracle.
Pinturiccio
Devart Team
 
Posts: 1866
Joined: Wed 02 Nov 2011 09:44

Fails using Direct Connection

Postby djryan » Tue 06 Dec 2011 14:30

This appears to only happen if I choose direct connection. It is working now if I use an Oracle home.
djryan
 
Posts: 2
Joined: Wed 30 Nov 2011 17:42

Postby Pinturiccio » Thu 08 Dec 2011 10:24

We could not reproduce this issue with direct mode either. Could you please specify the version and edition of dotConnect for Oracle, and, if possible, send us a test project with DDL/DML scripts?
Pinturiccio
Devart Team
 
Posts: 1866
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle