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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.