Re: BizTalk DB connectivity problems



Hi,

You say that the failure occurs on regular basis. Is there something going on on the servers (e.g. backup job) when the errors occur?
Als you could try to use PAL tool (www.codeplex.com/PAL) to monitor you environment for one day and analyse what is causing the problems.

HTH,

Randal van Splunteren


"Daniel_1" <Daniel1@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:64D38C8B-32B5-4DAD-95F2-AC1DA59CA04E@xxxxxxxxxxxxxxxx
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/2022
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 documentation.
Error source:

BizTalk host name: BizTalkServerApplication
Windows service name: BTSSvc$BizTalkServerApplication

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


Event Type: Error
Event Source: ENTSSO
Event Category: (1)
Event ID: 10514
Date: 1/02/2022
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 transport-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 Support Center at
http://go.microsoft.com/fwlink/events.asp.


Event Type: Warning
Event Source: ENTSSO
Event Category: (1)
Event ID: 10532
Date: 1/02/2022
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/2022
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 transport-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 Support 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/2022
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
Support for details. The following information is part of the event: Unable
to open shim database version registry key - v2.0.50727.00000.


For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


Event Type: Information
Event Source: ENTSSO
Event Category: (1)
Event ID: 10533
Date: 1/02/2022
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 Support 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/2022
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 Support Center at
http://go.microsoft.com/fwlink/events.asp.


Event Type: Warning
Event Source: RuleEngineUpdateService
Event Category: None
Event ID: 0
Date: 1/02/2022
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 transport-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 Support Center at
http://go.microsoft.com/fwlink/events.asp.

.



Relevant Pages

  • Re: Ongoing DNS Issue? or something worse?
    ... has an issue with connecting to the SBS server correctly. ... Event Source: W32Time ... see Help and Support Center at ... The dynamic deletion of the DNS record 'WesternValve.local. ...
    (microsoft.public.windows.server.sbs)
  • Re: Im stuck - Weird behaviour on multiple Server 2000 DC/member servers.
    ... I've checked the server environmant variables and "Path" includes ... has SP4 installed so Microsoft Support suggested I install Security Rollup ... Event Type: Warning ... Event Source: SpntLog ...
    (microsoft.public.win2000.general)
  • Re: Whats going on here
    ... >>Event Source: Windows SharePoint Services 2.0 ... Check the database connection information and make ... >>sure that the database server is running. ... see Help and Support Center at ...
    (microsoft.public.windows.server.sbs)
  • Re: Event ID 2019 and Event ID 333
    ... I check the DHCP server setting over even though it returns with "The ... Event Source: MRxSmb ... see Help and Support Center at ... Event Type: Warning ...
    (microsoft.public.windows.server.general)
  • Re: Event ID 2019 and Event ID 333
    ... I check the DHCP server setting over even though it returns with "The operation completed successfully" ... Event Source: MRxSmb ... see Help and Support Center at ... Event Type: Warning ...
    (microsoft.public.windows.server.general)