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.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

SAP HANA DB 2.0

Product

SAP HANA, platform edition 2.0

Keywords

extraction data, nonSAP DB, HANA SDA remote source, Indexserver Trace, error, NIPING SERVER LOG, connection broken, TRACE SQL SERVER LOG, SQL Server blocked access, SAP HANA DB 2.0, SQL Server ODBC Driver, Microsoft network error code, Connection Reset by Peer, network problem, SQL Server profiler, network communication error, network connectivity issues, SAP Note#2898195, TRACE SQL SERVER LOG, HANA specific error, MS site , 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 for Me (Login required).

Search for additional results

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