Hi,
We have a production environment that consists of four machines.
Two BizTalk server 2004 (load balanced) and two SQL servers 2000
(clustered).
A couple of weeks ago we installed windows server 2003 SP1 on the BizTalk
machines and last Saturday we did the same on the SQL servers.
On the biztalk servers we have a windows service that uses a COM+
application running that regularly fails.
it says: "Timeout expired. The timeout period elapsed prior to completion of
the operation or the server is not responding."
It is something that happens a couple of times a day and we have no idea
what could be causing this issue.
We have looked at the DTC settings But if they were wrong biztalk would
simply not function
If the network would go down i guess that biztalk would also experience
problems since both apps use the same database server.
When I type in the eror message most sites point me in the direction of DTC
but that seems to function properly.
Any help would be appreciated.
Jay
Below is the complete error information.
************************************************** ************************************************** ************************************************** ************************************************** ************
Exception Type: System.Data.SqlClient.SqlException
Errors: System.Data.SqlClient.SqlErrorCollection
Class: 10
LineNumber: 0
Message: Timeout expired. The timeout period elapsed prior to completion of
the operation or the server is not responding.
Number: -2
Procedure: ConnectionRead (recv()).
Server: HQPSQL09\INSTANCE3
State: 0
Source: .Net SqlClient Data Provider
TargetSite: Void OnError(System.Data.SqlClient.SqlException,
System.Data.SqlClient.TdsParserState)
HelpLink: NULL
StackTrace Information
*********************************************
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning()
at System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)
at System.Data.SqlClient.TdsParser.ReadBuffer()
at System.Data.SqlClient.TdsParser.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
cmdHandler, SqlDataReader dataStream)
at System.Data.SqlClient.TdsParser.PropagateDistribut edTransaction(Byte[]
buffer, Int32 length, Int32 timeout)
at
System.Data.SqlClient.SqlInternalConnection.Enlist NonNullDistributedTransaction(ITransaction
transaction)
at
System.Data.SqlClient.SqlInternalConnection.Enlist DistributedTransaction(ITransaction
newTransaction, Guid newTransactionGuid)
at
System.Data.SqlClient.SqlInternalConnection.Enlist DistributedTransaction()
at System.Data.SqlClient.SqlInternalConnection.Activa te(Boolean
isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ApplicationBlocks.Data.SqlHelper.Execute Reader(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.Execute Reader(String
connectionString, CommandType commandType, String commandText)
at CODit.LoopService.DAL.Locker.GetSettings()
|