Hi,
Has anyone experienced major SQL connectivity problems on their BizTalk
2006
servers with events log like those listed below? These errors occur on our
BizTalk servers on a regular basis even when there are no incoming
messages
arriving, a complete failure of the applications often folllows. They
definitely suggest network issues, but our network people are adamant that
everything is fine. We have 2 BizTalk boxes which talk with 2 clustered
SQL
servers. The errors appear on both BizTalk machines.
Any help greatly appreciated.
Daniel
This sequence of events are typical and occur several times daily, usually
at the exact same times each day:
Event Type: Warning
Event Source: BizTalk Server 2006
Event Category: (1)
Event ID: 5410
Date: 1/02/2008
Time: 7:00:03 PM
User: N/A
Computer: SWC88342550
Description:
An error occurred that requires the BizTalk service to terminate. The most
common causes are the following:
1) An unexpected out of memory error.
OR
2) 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: [DBNETLIB][ConnectionRead (recv()).]General network error.
Check your network do***entation.
Error source:
BizTalk host name: BizTalkServerApplication
Windows service name: BTSSvc$BizTalkServerApplication
For more information, see Help and Sup****t Center at
http://go.microsoft.com/fwlink/events.asp.
Event Type: Error
Event Source: ENTSSO
Event Category: (1)
Event ID: 10514
Date: 1/02/2008
Time: 7:00:08 PM
User: N/A
Computer: SWC88342550
Description:
An error occurred while attempting to access the SSO database.
Function: GetGlobalInfo
File: infocache.cpp:1236
A trans****t-level error has occurred when sending the request to the
server. (provider: TCP Provider, error: 0 - An existing connection was
forcibly closed by the remote host.).
SQL Error code: 0x00002746
Error code: 0xC0002A21, An error occurred while attempting to access the
SSO database.
For more information, see Help and Sup****t Center at
http://go.microsoft.com/fwlink/events.asp.
Event Type: Warning
Event Source: ENTSSO
Event Category: (1)
Event ID: 10532
Date: 1/02/2008
Time: 7:00:38 PM
User: N/A
Computer: SWC88342550
Description:
Failed to retrieve master secrets. Verify that the master secret server
name
is correct and that it is available.
Secret Server Name: SQLCluster2
Error Code: 0x800706BE, The remote procedure call failed.
Event Type: Warning
Event Source: RuleEngineUpdateService
Event Category: None
Event ID: 0
Date: 1/02/2008
Time: 7:00:59 PM
User: N/A
Computer: SWC88342550
Description:
This error was encountered while trying to determine if any changes in the
rules deployment database occurred:
System.Data.SqlClient.SqlException: A trans****t-level error has occurred
when sending the request to the server. (provider: TCP Provider, error: 0
-
An existing connection was forcibly closed by the remote host.)
For more information, see Help and Sup****t Center at
http://go.microsoft.com/fwlink/events.asp.
Event Type: Error
Event Source: .NET Runtime
Event Category: None
Event ID: 0
Date: 1/02/2008
Time: 7:01:04 PM
User: N/A
Computer: SWC88342550
Description:
The description for Event ID ( 0 ) in Source ( .NET Runtime ) cannot be
found. The local computer may not have the necessary registry information
or
message DLL files to display messages from a remote computer. You may be
able
to use the /AUXSOURCE= flag to retrieve this description; see Help and
Sup****t for details. The following information is part of the event:
Unable
to open ****m database version registry key - v2.0.50727.00000.
For more information, see Help and Sup****t Center at
http://go.microsoft.com/fwlink/events.asp.
Event Type: Information
Event Source: ENTSSO
Event Category: (1)
Event ID: 10533
Date: 1/02/2008
Time: 7:01:08 PM
User: N/A
Computer: SWC88342550
Description:
Recovered from failure to get master secrets.
Secret Server Name: SQLCluster2
For more information, see Help and Sup****t Center at
http://go.microsoft.com/fwlink/events.asp.
Event Type: Information
Event Source: BizTalk Server 2006
Event Category: (1)
Event ID: 5410
Date: 1/02/2008
Time: 7:01:20 PM
User: N/A
Computer: SWC88342550
Description:
The following BizTalk host instance has initialized successfully.
BizTalk host name: BizTalkServerApplication
Windows service name: BTSSvc$BizTalkServerApplication
For more information, see Help and Sup****t Center at
http://go.microsoft.com/fwlink/events.asp.
Event Type: Warning
Event Source: RuleEngineUpdateService
Event Category: None
Event ID: 0
Date: 1/02/2008
Time: 7:01:59 PM
User: N/A
Computer: SWC88342550
Description:
This error was encountered while trying to determine if any changes in the
rules deployment database occurred:
System.Data.SqlClient.SqlException: A trans****t-level error has occurred
when sending the request to the server. (provider: TCP Provider, error: 0
-
An existing connection was forcibly closed by the remote host.)
For more information, see Help and Sup****t Center at
http://go.microsoft.com/fwlink/events.asp.
|
