Dear fellow practitioner,

In My production CRM box (HANA DB - fa/hana1sp12), I see the following issue intermittently ( say biweekly) in the sap work process logs.

RTE:[89006] System call 'connect' failed, rc=111:Connection refused (<hostname>:\

32415))

SQLERRTEXT : Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused (<hostname>:\ C 32415)) B DBREPO: report table: 'REPOTEXT ' B DBREPO: program: 'CL_ICF_SYSTEM_LOGIN===========CP ' B DBREPO: state: A, lang = E, mach = 0 B ***LOG BYM=> severe DB error -10709; work process in reconnect status [dbsh 1190] B ***LOG BY4=> sql error -10709 performing SEL on table REPOTEXT [dbrepo 3169] B ***LOG BY0=> Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused (<hostname>:32415)) [dbrepo 3169]

The availability.log denotes the unavailability of around 6 minutes.

work processes did connected post 6 minutes.

-------------------

C Try to connect via secure store (DEFAULT) on connection 0 ... C Attach to HDB : 1.00.122.08.1490178281 (fa/hana1sp12) C fa/hana1sp12 : build_weekstone=0000.00.0 C fa/hana1sp12 : build_time=2017-03-22 11:32:17 C Database release is HDB 1.00.122.08.1490178281 C INFO : Database 'SID/24' instance is running on 'hostname' C INFO : Connect to DB as 'SAPSID', connection_id=200124 C INFO : DATA AGING feature is supported by HANA C INFO : FDA feature is supported by HANA C INFO : FAE with FDA feature is supported by HANA C INFO : CACHEDVIEWTS feature is supported by HANA C INFO : DEFERRED LOB WRITING is activated C DB max. input host variables : 32767 C DB max. statement length : 104857600 C DB max. array size : 100000 C use decimal precision as length C ABAPVARCHARMODE is used C use DBSL marker map C INFO : DBSL buffer size = 1048576 C Command info enabled C Now I'm connected to HDB

-----------------------

Now everything is fine. R3trans returns RC0.

I have already checked few notes.

-----------------------------------

2316463 - * -10709: Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused

2213725 - How-To: Troubleshooting of -10709 error

------------------------------

hdbuserstore list gives the correct hostname and port for default key.

Please suggest what could be checked to overcome this.