SAP Knowledge Base Article - Preview

2934595 - "The hdbsql connection is not possible. Check if the database is online" during PREP_INSTALL/SHDUNINST_DB_PREP Phase in SUM

Symptom

When performing the PREP_INSTALL/SHDUNINST_DB_PREP Phase in the Software Update Manager Tool - SUM, an error is encountered:

"The hdbsql connection is not possible. Check if the database is online"

  • SUMLOG > HDBOPOUT.cmd log file displays the following error message:
EXECUTING F:\usr\sap\<SID>\SYS\exe\uc\NTAMD64\hdbclient\hdbsql.EXE -o E:\SUM\SUM\abap\log\HDBOPSQL.OUT -U UPGSHDKEY "SELECT * FROM DUMMY"
* -10709: Connection failed (RTE:[89006] System call 'connect' failed, rc=10061:No connection could be made because the target machine actively refused it (worker*_hostname_ip_address:port))
SAPup> Process with PID 5320 terminated with status -10709 at 20200126102307!

 

  • A check of the hdbuserstore list displays the subordinate* node host as the KEY for the shadow instance - UPGSHDKEY 
<sidadm> hdbuserstore list
KEY DEFAULT
ENV: <HANA_coordinator*_hostname_ip address>:port; <worker*_hostname_ip address>:30015
USER: SAPSID

KEY UPGSHDKEY
ENV : <HANA_worker*_hostname_ip address>:port; 
USER: SAPSIDSHD


  • The SUM tool is trying to connect to SAP HANA worker* node <hostname_ip:port> in the ENV section of the KEY UPGSHDKEY , instead of the coordinator* node <hostname_ip:port>


Read more...

Environment

SAP HANA, platform edition

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

KBA , master , slave , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , 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.