Symptom
In an SLT system, the target HANA DB is enabled with System Replication.
In the target HANA DB, you performed failover (takeover): primary -> secondary, after that, SLT starts to fail.
Later, you performed failback: secondary (original) -> primary (original), after that, SLT fails either.
In the work process trace, the same or similar error messages as below are observed.
It failed due to it tries to connect to <secondary IP>.
----------------------------------------------
C connect to S4_TO_DW/<pwd>@<virtual IP>:30053 on connection 1 ...
C *** ERROR => Connect to database failed, rc=1, rcSQL=-10709
[dbhdbsql.cpp 616]
C SQLCODE : -10709
C SQLERRTEXT : Connection failed (RTE:[89006] System call 'send' failed, rc=32:Broken pipe {<secondary IP>:30053} (<primary IP>:30053))
B ***LOG BY2=> sql error -10709 performing CON [dbds 1001]
B ***LOG BY0=> Connection failed (RTE:[89006] System call 'send' failed, rc=32:Broken pipe {<secondary IP>:30053} (<primary IP>:30053)) [dbds 1001]
B Connect to S4_TO_DW as S4_TO_DW with <virtual IP>:30053
C Try to connect as S4_TO_DW/<pwd>@<virtual IP>:30053 on connection 1 ...
----------------------------------------------
In DBCO, you creates a new connection to primary site (primary IP). During the test, you observed it still try to connect to <secondary IP> and fails with the similar error:
Connection failed (RTE:[89006] System call 'send' failed, rc=32:Broken pipe {<secondary IP>:30053}
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Read more...
Environment
- SAP NetWeaver Application Server for ABAP
- SAP HANA, platform edition 2.0
Product
Keywords
HANA, SLT, system replication, primary, secondary, Connect to database failed , Connection failed, System call 'send' failed, rc=32:Broken pipe, sql error -10709 , KBA , BC-DB-HDB-SYS , Database Interface/DBMS for SAP HANA , 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.