Home All Groups Group Topic Archive Search About

Help! Serviced componets SQL-server 2005

Author
16 Feb 2006 10:26 AM
Jo ARild
After upgrading to SQL-server 2005 the following error message occures on a
random basis.  The SQL-server does not have any deadlock.
It worked perfect before the upgrade and no database changes were made after
the upgrade.
The serviced components are called from asp.net 2.0.

If anyone have experience similare errors please post your suggestions.


System.Exception: System.Data.SqlClient.SqlException: New request is not
allowed to start because it should come with valid transaction descriptor. at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection) at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj) at
System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[]
buffer, TransactionManagerRequestType request, String transactionName,
TransactionManagerIsolationLevel isoLevel, Int32 timeout,
SqlInternalTransaction transaction, TdsParserStateObject stateObj) at
System.Data.SqlClient.SqlInternalConnectionTds.PropagateTransactionCookie(Byte[]
cookie) at System.Data.SqlClient.SqlInternalConnection.EnlistNull() at
System.Data.SqlClient.SqlInternalConnection.Enlist(Transaction tx) at
System.Data.SqlClient.SqlInternalConnectionTds.Activate(Transaction
transaction) 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
TRADEXLib.SQLUtil.CSqlDB.CreateNetConn(String app, Boolean async) at
TRADEXLib.SQLUtil.CSqlDB.CreateNetCmd() at
TRXOrders.CLogin.GetDepartmentID(String departmentName) at
TRXOrders.CLogin.GetDepartmentFromQube(String username) at
TRXOrders.CLogin.GetTradexUserIDFromQube(String QubeUserID, String GroupCode)
Server stack trace: at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number,
Object Source, Object Description, Object HelpFile, Object HelpContext) at
TRXOrders.CLogin.GetTradexUserIDFromQube(String QubeUserID, String GroupCode)
at TRXOrders.Advent.Qube.CQube.GetQubeAccountManager(String QubeCustomerID,
String DefaultuserID) at
TRXOrders.Advent.Qube.CQube.UpdateClientFromQube(String QubeCustomerID,
String UserID) at
System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr
md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext,
Object[]& outArgs) at
System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle
md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext,
Object[]& outArgs) at
System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage
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 TRXOrders.Advent.Qube.CQube.UpdateClientFromQube(String
QubeCustomerID, String UserID) at tradex.wCustomer.FillForm()

AddThis Social Bookmark Button