V
Von Shean
I have a dll in .net that is used by another dll. The second dll is used in
the web and the first one acts as a middle layer. The dll contains
non-transactional and transactional classes. I have registered the dll in
com+ services using regsvcs. Non-transactional works fine. But the calls to
transactional classes hang when called by the second dll.
I execute a SqlHelper.ExecuteReader.
No call to the database is made.
Looking at the eventlog i get different entries. The most common one was
Server stack trace:
at System.Data.Common.ITransactionExport.Export(ITransaction transaction,
UInt32& transactionCookie)
at System.Data.SqlClient.Transaction.GetTransactionCookie(Byte[] dtcAddr,
ITransaction transaction, ITransactionExport& transactionExport, Byte[]&
cookie, Int32& length)
at
System.Data.SqlClient.SqlInternalConnection.EnlistNonNullDistributedTransact
ion(ITransaction transaction)
at
System.Data.SqlClient.SqlInternalConnection.EnlistDistributedTransaction(ITr
ansaction newTransaction, Guid newTransactionGuid)
at
System.Data.SqlClient.SqlInternalConnection.EnlistDistributedTransaction()
at System.Data.SqlClient.SqlInternalConnection.Activate(Boolean
isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters)
at
WRIPPlatform.Persistence.Impl.SubscriptionSqlHandlerImpl.ListSubscriptions(P
rogram program, Participant participant)
at
WRIPPlatform.Platform.Impl.SubscriptionManagerImpl.ListSubscriptions(Program
program, Participant participant)
at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target,
Boolean fExecuteInContext)
at
System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessa
ge msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
msgData, Int32 type)
at WRIPPlatform.Platform.ISubscriptionManager.ListSubscriptions(Program
program, Participant participant)
at
WRIPWeb.ASPX.ParticipantConfigure.CreateSubscriptionDetailsSource(Participan
t participant)
at WRIPWeb.ASPX.ParticipantConfigure.OnBtnSelectClick(Object sender,
EventArgs e)
Help!!!
Regards,
the web and the first one acts as a middle layer. The dll contains
non-transactional and transactional classes. I have registered the dll in
com+ services using regsvcs. Non-transactional works fine. But the calls to
transactional classes hang when called by the second dll.
I execute a SqlHelper.ExecuteReader.
No call to the database is made.
Looking at the eventlog i get different entries. The most common one was
Server stack trace:
at System.Data.Common.ITransactionExport.Export(ITransaction transaction,
UInt32& transactionCookie)
at System.Data.SqlClient.Transaction.GetTransactionCookie(Byte[] dtcAddr,
ITransaction transaction, ITransactionExport& transactionExport, Byte[]&
cookie, Int32& length)
at
System.Data.SqlClient.SqlInternalConnection.EnlistNonNullDistributedTransact
ion(ITransaction transaction)
at
System.Data.SqlClient.SqlInternalConnection.EnlistDistributedTransaction(ITr
ansaction newTransaction, Guid newTransactionGuid)
at
System.Data.SqlClient.SqlInternalConnection.EnlistDistributedTransaction()
at System.Data.SqlClient.SqlInternalConnection.Activate(Boolean
isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters)
at
WRIPPlatform.Persistence.Impl.SubscriptionSqlHandlerImpl.ListSubscriptions(P
rogram program, Participant participant)
at
WRIPPlatform.Platform.Impl.SubscriptionManagerImpl.ListSubscriptions(Program
program, Participant participant)
at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target,
Boolean fExecuteInContext)
at
System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessa
ge msg, Int32 methodPtr, Boolean fExecuteInContext)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
msgData, Int32 type)
at WRIPPlatform.Platform.ISubscriptionManager.ListSubscriptions(Program
program, Participant participant)
at
WRIPWeb.ASPX.ParticipantConfigure.CreateSubscriptionDetailsSource(Participan
t participant)
at WRIPWeb.ASPX.ParticipantConfigure.OnBtnSelectClick(Object sender,
EventArgs e)
Help!!!
Regards,