Dear Community Members,
Ours is a Windows Application where we are using Remoting to connect our application server (running as a Windows Service). We are using SQL Server 2000 SP3 as database. At a certain instance while performing a huge transaction (when our application updates some 9000+ records) we are getting the following error:
at System.Data.Sql Client.SqlConne ction.OnError(S qlException exception, Boolean breakConnection )
at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion exception, Boolean breakConnection )
at System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct stateObj)
at System.Data.Sql Client.TdsParse r.Run(RunBehavi or runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleR esultSet bulkCopyHandler , TdsParserStateO bject stateObj)
at System.Data.Sql Client.SqlComma nd.FinishExecut eReader(SqlData Reader ds, RunBehavior runBehavior, String resetOptionsStr ing)
at System.Data.Sql Client.SqlComma nd.RunExecuteRe aderTds(Command Behavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.Sql Client.SqlComma nd.RunExecuteRe ader(CommandBeh avior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.Sql Client.SqlComma nd.InternalExec uteNonQuery(DbA syncResult result, String methodName, Boolean sendToPipe)
at System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery()
*** Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction. ---
The application is basically running on Windows 2003 SBS. This problem has started coming only after all the systems were upgraded to Service pack 2 (without this SP there is no problem). The moment the user uninstalls this service pack, the process is getting completed without any problem.
I understood that this problem is something to do with MS DTC and accordingly updated the Timeout to 600 sec (10 Min) but the problem is not resolved.
Have you faced this problem and found a solution please let me know immediately. I am waiting anxiously for your answer.
Regards
Ayan
Ours is a Windows Application where we are using Remoting to connect our application server (running as a Windows Service). We are using SQL Server 2000 SP3 as database. At a certain instance while performing a huge transaction (when our application updates some 9000+ records) we are getting the following error:
at System.Data.Sql Client.SqlConne ction.OnError(S qlException exception, Boolean breakConnection )
at System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion exception, Boolean breakConnection )
at System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct stateObj)
at System.Data.Sql Client.TdsParse r.Run(RunBehavi or runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleR esultSet bulkCopyHandler , TdsParserStateO bject stateObj)
at System.Data.Sql Client.SqlComma nd.FinishExecut eReader(SqlData Reader ds, RunBehavior runBehavior, String resetOptionsStr ing)
at System.Data.Sql Client.SqlComma nd.RunExecuteRe aderTds(Command Behavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.Sql Client.SqlComma nd.RunExecuteRe ader(CommandBeh avior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.Sql Client.SqlComma nd.InternalExec uteNonQuery(DbA syncResult result, String methodName, Boolean sendToPipe)
at System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery()
*** Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction. ---
The application is basically running on Windows 2003 SBS. This problem has started coming only after all the systems were upgraded to Service pack 2 (without this SP there is no problem). The moment the user uninstalls this service pack, the process is getting completed without any problem.
I understood that this problem is something to do with MS DTC and accordingly updated the Timeout to 600 sec (10 Min) but the problem is not resolved.
Have you faced this problem and found a solution please let me know immediately. I am waiting anxiously for your answer.
Regards
Ayan