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 ONE Support launchpad (Login required).

Search for additional results

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