SAP Knowledge Base Article - Preview

2843393 - "SQL code: -10709" occurred while accessing table "DDFTX"

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.