SAP Knowledge Base Article - Preview

3005962 - ODBC error: connected: 0 state: 08S01 code: 10060 [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x274C

Symptom

During extraction data from nonSAP DB via HANA SDA remote source, following error occurs:

Indexserver Trace:
[25196]{220417}[30/-1] 2020-10-26 16:59:05.798783 e FedTrace odbccustom.cpp(00709) : Configuration file:/usr/sap/HAD/HDB00/exe//config/property_mss.ini could not be opened.
[5230]{242903}[32/254411719] 2020-10-26 19:04:23.003547 e FedTrace odbcaccess.cpp(03884) : ODBC error: connected: 0 state: 08S01 code: 10060 [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x274C

NIPING SERVER LOG
Mon Nov 09 21:12:09 2020
***LOG Q0I=> NiIRead: P=10.1.0.50:65070; L=10.20.1.25:3298: recv (10054: WSAECONNRESET: Connection reset by peer) [D:/depot/bas/753_REL/src/base/ni/nixxi.cpp 5429]
*** ERROR => NiIRead: SiRecv failed for hdl 9/sock 420
(SI_ECONN_BROKEN/10054; I4; ST; P=10.1.0.50:65070; L=10.20.1.25:3298) [nixxi.cpp 5429]

*****************************************************************************
*
* ERROR connection to partner '10.1.0.50:65070' broken
*
* TIME Mon Nov 09 21:12:09 2020
* RELEASE 753
* COMPONENT NI (network interface)
* VERSION 40
* RC -6
* MODULE D:/depot/bas/753_REL/src/base/ni/nixxi.cpp
* LINE 5429
* DETAIL NiIRead: P=10.1.0.50:65070; L=10.20.1.25:3298
* SYSTEM CALL recv
* ERRNO 10054
* ERRNO TEXT WSAECONNRESET: Connection reset by peer
* COUNTER 3
*
*****************************************************************************

client hdl 9 disconnected ...


TRACE SQL SERVER LOG
SQL Server blocked access to procedure 'sys.xp_sqlagent_enum_jobs' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online.


Read more...

Environment

SAP HANA DB 2.0

Product

SAP HANA, platform edition 2.0

Keywords

MSSQL, Database, Communiction, Smart Data Access , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.