Weird transaction problem with Entity Framework

D

David Keaveny

I'm experiencing a strange issue with a .NET service I've written that
uses Entity Framework. It creates a new Client entity in my SQL2005
database, then after the exchange of a few messages over an enterprise
service bus, updates the created entity. The initial insert goes fine,
but the update fails with the following error:

2009-04-15 14:26:53,367 ERROR : 'System.Action`1[[System.Object,
mscorlib, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089]]' threw an exception consuming
message 'MyProject.Core.Messages.AgencyCreated'
System.Data.EntityException: The underlying provider failed on Open.
---> System.Transactions.TransactionException: The partner transaction
manager has disabled its support for remote/network transactions.
(Exception from HRESULT: 0x8004D025) --->
System.Runtime.InteropServices.COMException (0x8004D025): The partner
transaction manager has disabled its support for remote/network
transactions. (Exception from HRESULT: 0x8004D025)
at System.Transactions.Oletx.IDtcProxyShimFactory.ReceiveTransaction
(UInt32 propgationTokenSize, Byte[] propgationToken, IntPtr
managedIdentifier, Guid& transactionIdentifier,
OletxTransactionIsolationLevel& isolationLevel, ITransactionShim&
transactionShim)
at
System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropigationToken
(Byte[] propagationToken)
--- End of inner exception stack trace ---
at System.Transactions.Oletx.OletxTransactionManager.ProxyException
(COMException comException)
at
System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropigationToken
(Byte[] propagationToken)
at System.Transactions.TransactionStatePSPEOperation.PSPEPromote
(InternalTransaction tx)
at System.Transactions.TransactionStateDelegatedBase.EnterState
(InternalTransaction tx)
at System.Transactions.EnlistableStates.Promote(InternalTransaction
tx)
at System.Transactions.Transaction.Promote()
at System.Transactions.TransactionInterop.ConvertToOletxTransaction
(Transaction transaction)
at System.Transactions.TransactionInterop.GetExportCookie
(Transaction transaction, Byte[] whereabouts)
at System.Data.SqlClient.SqlInternalConnection.GetTransactionCookie
(Transaction transaction, Byte[] whereAbouts)
at System.Data.SqlClient.SqlInternalConnection.EnlistNonNull
(Transaction tx)
at System.Data.ProviderBase.DbConnectionInternal.ActivateConnection
(Transaction transaction)
at System.Data.ProviderBase.DbConnectionPool.GetConnection
(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection
(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection
(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf
(Boolean openCondition, DbConnection storeConnectionToOpen,
DbConnection originalConnection, String exceptionCode, String
attemptedOperation, Boolean& closeStoreConnectionOnFailure)
--- End of inner exception stack trace ---
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf
(Boolean openCondition, DbConnection storeConnectionToOpen,
DbConnection originalConnection, String exceptionCode, String
attemptedOperation, Boolean& closeStoreConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at System.Data.Objects.ObjectContext.EnsureConnection()
at System.Data.Objects.ObjectContext.SaveChanges(Boolean
acceptChangesDuringSave)
at MyProject.Data.Repository.Save(Client client)
at MyProject.Cmas.CreateAccountSaga.Consume(AgencyCreated message)
at
MassTransit.Pipeline.Sinks.MessageTranslator`2.<>c__DisplayClass1.<Enumerate>b__0
(TInput x)
at MassTransit.ServiceBus.DispatchMessageToConsumers
(IResourceLockScope`1 resourceLock, IMessageSelector selector, Object
message)

The Repository.Save method in the stack trace does this:

public void Save(Client client)
{
using (ContractsDataModel model = new ContractsDataModel())
{
EntityClient entityClient;

if (client.Id == 0)
{
entityClient = EntityClient.CreateEntityClient(0, client.Name);
model.AddToEntityClients(entityClient);
}
else
{
entityClient = model.EntityClients.Where(x => x.Id ==
client.Id).First();
}
entityClient.UpdateFrom(client);
model.SaveChanges();
client.Id = entityClient.Id;
}
}

UpdateFrom(client) copies over the various fields from Client to
EntityClient. As I said, the insert part works just fine, but when
updating the created entity, the transaction error occurs. MSDTC seems
to have all the options checked.
 
M

Mark

Never seen the error and I don't use EF like you do - but I might be able to
help. It sounds like the DTC isn't enabled over a remote network, Ive had
similiar problems over VPN.

Go to Control Panel/Administrative Tools/Component Services

Expand Component Services/Computers and right click My Computer, select
Properties, select MSDTC tab then click Security Configuration

Now I don't exactly know what all the options in here do, but you got the
Allow Remote Clients option which is what might be causing the problem so
switch on Allow Remote Clients *on the server* and try again!
--
Best regards...
Mark Baldwin
MB Consultancy | Tel: 07738924224
David Keaveny said:
I'm experiencing a strange issue with a .NET service I've written that
uses Entity Framework. It creates a new Client entity in my SQL2005
database, then after the exchange of a few messages over an enterprise
service bus, updates the created entity. The initial insert goes fine,
but the update fails with the following error:

2009-04-15 14:26:53,367 ERROR : 'System.Action`1[[System.Object,
mscorlib, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089]]' threw an exception consuming
message 'MyProject.Core.Messages.AgencyCreated'
System.Data.EntityException: The underlying provider failed on Open.
---> System.Transactions.TransactionException: The partner transaction
manager has disabled its support for remote/network transactions.
(Exception from HRESULT: 0x8004D025) --->
System.Runtime.InteropServices.COMException (0x8004D025): The partner
transaction manager has disabled its support for remote/network
transactions. (Exception from HRESULT: 0x8004D025)
at System.Transactions.Oletx.IDtcProxyShimFactory.ReceiveTransaction
(UInt32 propgationTokenSize, Byte[] propgationToken, IntPtr
managedIdentifier, Guid& transactionIdentifier,
OletxTransactionIsolationLevel& isolationLevel, ITransactionShim&
transactionShim)
at
System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropigationToken
(Byte[] propagationToken)
--- End of inner exception stack trace ---
at System.Transactions.Oletx.OletxTransactionManager.ProxyException
(COMException comException)
at
System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropigationToken
(Byte[] propagationToken)
at System.Transactions.TransactionStatePSPEOperation.PSPEPromote
(InternalTransaction tx)
at System.Transactions.TransactionStateDelegatedBase.EnterState
(InternalTransaction tx)
at System.Transactions.EnlistableStates.Promote(InternalTransaction
tx)
at System.Transactions.Transaction.Promote()
at System.Transactions.TransactionInterop.ConvertToOletxTransaction
(Transaction transaction)
at System.Transactions.TransactionInterop.GetExportCookie
(Transaction transaction, Byte[] whereabouts)
at System.Data.SqlClient.SqlInternalConnection.GetTransactionCookie
(Transaction transaction, Byte[] whereAbouts)
at System.Data.SqlClient.SqlInternalConnection.EnlistNonNull
(Transaction tx)
at System.Data.ProviderBase.DbConnectionInternal.ActivateConnection
(Transaction transaction)
at System.Data.ProviderBase.DbConnectionPool.GetConnection
(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection
(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection
(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf
(Boolean openCondition, DbConnection storeConnectionToOpen,
DbConnection originalConnection, String exceptionCode, String
attemptedOperation, Boolean& closeStoreConnectionOnFailure)
--- End of inner exception stack trace ---
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf
(Boolean openCondition, DbConnection storeConnectionToOpen,
DbConnection originalConnection, String exceptionCode, String
attemptedOperation, Boolean& closeStoreConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at System.Data.Objects.ObjectContext.EnsureConnection()
at System.Data.Objects.ObjectContext.SaveChanges(Boolean
acceptChangesDuringSave)
at MyProject.Data.Repository.Save(Client client)
at MyProject.Cmas.CreateAccountSaga.Consume(AgencyCreated message)
at
MassTransit.Pipeline.Sinks.MessageTranslator`2.<>c__DisplayClass1.<Enumerate>b__0
(TInput x)
at MassTransit.ServiceBus.DispatchMessageToConsumers
(IResourceLockScope`1 resourceLock, IMessageSelector selector, Object
message)

The Repository.Save method in the stack trace does this:

public void Save(Client client)
{
using (ContractsDataModel model = new ContractsDataModel())
{
EntityClient entityClient;

if (client.Id == 0)
{
entityClient = EntityClient.CreateEntityClient(0, client.Name);
model.AddToEntityClients(entityClient);
}
else
{
entityClient = model.EntityClients.Where(x => x.Id ==
client.Id).First();
}
entityClient.UpdateFrom(client);
model.SaveChanges();
client.Id = entityClient.Id;
}
}

UpdateFrom(client) copies over the various fields from Client to
EntityClient. As I said, the insert part works just fine, but when
updating the created entity, the transaction error occurs. MSDTC seems
to have all the options checked.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TransactionManagerCommunicationException when transaction is escalated 2
TransactionScope returns "Error HRESULT E_FAIL has been returned froma call to a COM component" 0
There is already an open DataReader associated with this Command which must be closed first 13
Transaction Promotion problem 3
Exception at SqlCommand.Connection.Open() in nested TransactionScope 0
Communication with the underlying transaction manager has failed 3
Transaction Problem after upgrading ASP.Net + C# App. from .Net 2.0 beta to .Net 2.0 Professional 4
Multithreaded Database access with C# on an Sql2005 and TransactionScope class (Bug or did I some mi 3

Top