Symptom
Queries to any t-code on an ABAP Instance connected to a HANA DB results in a hanging situation on application server followed by this dump in ST22 for the DDFTX table.
SQL error "SQL code: -10709" occurred while accessing table "DDFTX".
Database error text:
"SQL message: Connection failed (RTE:[89006] System call
'connect' failed, rc=10060:A connection attempt failed because the connected
party did not properly respond after a period of time, or established
connection failed because connected host has failed "
R3Trans -d returns the following in the trans.log file
4 ETW000 [dbhdbsql.cpp,00000] *** ERROR => Connect to database failed, rc=1, rcSQL=-10709
4 ETW000 [ dev trc,00000] SQLCODE : -10709
4 ETW000 [ dev trc,00000] SQLERRTEXT : Connection failed (RTE:[89006] System call 'connect' failed, rc=10060:A connection attempt failed be\
4 ETW000 [ dev trc,00000] cause the connected party did not properly respond after a period of time, or established connection
4 ETW000 [ dev trc,00000] failed because connected host has failed to respond (hostname:30015))
4 ETW000 [ dblink ,00000] ***LOG BY2=>sql error -10709 performing CON
4 ETW000 [ dblink ,00000] ***LOG BY0=>Connection failed (RTE:[89006] System call 'connect' failed, rc=10060:A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond (hostname:30015))
2EETW169 no connect possible: "DBMS = HDB --- SERVER = '' PORT = ''"
The following parameters are set to 1 on the Linux host for the HANA System
-
net.ipv4.tcp_tw_reuse = 1
-
net.ipv4.tcp_tw_recycle = 1
- You are running ABAP Application Server instances on Windows OS
Read more...
Environment
- SAP HANA Database Platform Edition 1.0
- SAP HANA Database Platform Edition 2.0
- Application client platform on Windows OS
- SAP Netweaver 7.5
Product
SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0 ; SAP NetWeaver 7.5
Keywords
DDFTX, -10709 , KBA , HAN-DB , SAP HANA Database , 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.