	Product(s):	APM Implementation and Performance Management
	Version(s):	7.x
	Environment:	N\A
	Area:	N/A
	Subarea:	N\A

Problem

Frequent user disconnects and the following error in the server log:

2017-04-07 07:42:44.9436 Error user Ivara.OTAssert [34] File: database.cpp(3074) : Failed Assert: Database Connect Error:
   DBErrorType     = 'dbConnection'
   Native SQL Code = -1
   ODBC sqlstate   = 08S02
   ODBC errortext = '[Microsoft][ODBC Driver 11 for SQL Server]SMux Provider: Physical connection is not usable [xFFFFFFFF]. '

2017-04-07 07:42:44.9436 Error user Ivara.OTAssert [34] File: database.cpp(3074) : Failed Assert: Database Connect Error:
   DBErrorType     = 'dbConnection'
   Native SQL Code = -1
   ODBC sqlstate   = 08S02
   ODBC errortext = '[Microsoft][ODBC Driver 11 for SQL Server]Unable to open a logical session'

2017-04-07 07:42:44.9436 Error user Ivara.OTAssert [34] File: database.cpp(2921) : Failed Assert: Database Statement Error:
   DBErrorType     = 'dbStatement'
   Native SQL Code = 0
   ODBC sqlstate   = S1010
   ODBC errortext = '[Microsoft][ODBC Driver Manager] Function sequence error'

2017-04-07 07:42:47.0808 Error user Ivara.OTAssert [34] File: database.cpp(3074) : Failed Assert: Database Connect Error:
   DBErrorType     = 'dbConnection'
   Native SQL Code = 0
   ODBC sqlstate   = 08S01
   ODBC errortext = '[Microsoft][ODBC Driver 11 for SQL Server]Communication link failure'

Solution

Recommended by Amazon Team that disable the TCP Chimney Offload

Disable the below settings in Local network connection à Network adapter properties.

IPv4 Checksum Offload

Large Receive Offload (IPv4)

Large Send Offload Version 2 (IPv4)

TCP Checksum Offload (IPv4)

UDP Checksum Offload (IPv4)

And also disable below settings from Command prompt:

netsh int ip set global taskoffload=disabled

netsh int tcp set global chimney=disabled

netsh int tcp set global rss=disabled

netsh int tcp set global netdma=disabled

Frequent odbc communication link failure

Problem

Solution

See Also