Monday, December 8, 2014

BizTalk/SQL Server General network error

BizTalk/SQL Server - Network Error 

Error Message 1 : 

Log Name:      Application
Source:        BizTalk Server
Date:          12/8/2014 2:30:20 AM
Event ID:      6912
Task Category: BizTalk Server
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      VS55
Description:
The following stored procedure call failed: " { call admsvr_ReceiveLocation_GetAllInApp( ?)}". SQL Server returned error string: "[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.".
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="BizTalk Server" />
    <EventID Qualifiers="49344">6912</EventID>
    <Level>2</Level>
    <Task>1</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2014-12-08T09:30:20.000000000Z" />
    <Channel>Application</Channel>
    <Computer>VS55</Computer>
    <Security />
  </System>
  <EventData>
    <Data> { call admsvr_ReceiveLocation_GetAllInApp( ?)}</Data>
    <Data>[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.</Data>
  </EventData>
</Event>

Error Message 2 :

Log Name:      Application
Source:        BizTalk Server
Date:          12/8/2014 2:30:20 AM
Event ID:      5641
Task Category: BizTalk Server
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      VS55
Description:
The Messaging Engine failed to retrieve the configuration from the database. Details:"Connection failure".
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="BizTalk Server" />
    <EventID Qualifiers="49344">5641</EventID>
    <Level>2</Level>
    <Task>1</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2014-12-08T09:30:20.000000000Z" />
    <Channel>Application</Channel>
    <Computer>VS55</Computer>
    <Security />
  </System>
  <EventData>
    <Data>Connection failure</Data>
  </EventData>
</Event>

This is actually a general network issue.

This issue can be resolved by turning off the TCP Chimney. TCP Chimney is a feature of SNP(Scalable Network Pack). SNP is a high speed networking feature that were available in Windows Server 2008.

To Turn off the TCP Chimney , use the following command

"Netsh int ip set chimney DISABLED"

For More Info : 
http://support.microsoft.com/kb/942861

No comments:

Post a Comment