| Don Rixtown 2006-10-24, 6:38 pm |
| Hi,
I'm getting some strange errors and I'm hoping someone can point me in
the right direction.
The errors are being generated by BizTalk while trying to connect with
SQL Server. The connection seems to work under a very light load, but if
I send a lot of messages (which causes an increase of SQL activity) then
a bunch of strange errors start occuring.
The most recent error indicated an SQL connection was orphaned.
The environment is BizTalk 2004 connecting to SQL 2000 on two seperate
W2K3 servers.
Any help would be appreciated.
Thanks,
Don
Here's the messages from the event log:
Event Type: Warning
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 5740
Date: 10/13/2006
Time: 2:43:42 PM
User: N/A
Computer:
Description:
The adapter "SQL" raised an error message. Details
"HRESULT="0x80004005" Description="Protocol error in TDS stream"
".
--------------------
Event Type: Error
Event Source: XLANG/s
Event Category: None
Event ID: 10001
Date: 10/13/2006
Time: 2:43:43 PM
User: N/A
Computer:
Description:
Failed while creating a service.
Exception type: ServiceCreationExcep
tion
Source:
Target Site:
Help Link:
Additional error information:
Exception of type MalformedEnlistmentE
xception was thrown.
Exception type: MalformedEnlistmentE
xception
Source: Microsoft.XLANGs.BizTalk.Engine
Target Site: Microsoft.BizTalk.XLANGs.BTXEngine. BTXServiceStaticStat
e
_deserializeStaticSt
ate(System.Guid)
Help Link:
Additional error information:
--------------------
Event Type: Error
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 6912
Date: 10/13/2006
Time: 2:43:43 PM
User: N/A
Computer:
Description:
The following stored procedure call failed: " { call [dbo].
& #91;bts_GetStaticSta
teInfo]( ?)}". SQL Server returned error string:
"Connection failure".
--------------------
Event Type: Warning
Event Source: BizTalk Server 2004
Event Category: BizTalk Server 2004
Event ID: 5410
Date: 10/13/2006
Time: 2:43:43 PM
User: N/A
Computer:
Description:
An error has occurred that requires the BizTalk service to terminate.
The most common causes are an unexpected out of memory error and an
inability to connect or a loss of connectivity to one of the BizTalk
databases. The service will shutdown and auto-restart in 1 minute. If
the problematic database remains unavailable, this cycle will repeat.
Error message: Connection failure
Error source:
BizTalk host name: BizTalkServerApplica
tion
Windows service name: BTSSvc{0D0525E3-7BBC-46C7-9A63-3761D1BC8746}
--
Don Rixtown
don[dot]rixtown[at]gmail[dot]com
|