SAP Knowledge Base Article - Preview

3461646 - HDB userstore hdbsql -U does not work

Symptom

  • An error occurred from the execution of 'hdbsql -U' where multiple host/ports pairs are added to one key in the hdbuserstore.
    • hanadm@myhost:/usr/sap/HAN/HDB00>  hdbsql -U MyKey
      * -10719: Connect failed (invalid SERVERNODE 'myhost:30013@HAN,myhost:30015') SQLSTATE: HY000
  • When adding the key with a single host/port pair, it works fine.
    • hreadm@myhost:/usr/sap/HAN/HDB00> hdbuserstore set JERRY1 "myhost:30013" SYSTEM <password>
      Operation succeed.
      hreadm@myhost:/usr/sap/HAN/HDB00> hdbuserstore set JERRY2 "myhost:30015" SYSTEM <password>
      Operation succeed.
    • hanadm@myhost:/usr/sap/HAN/HDB00> hdbsql -U JERRY1
      Welcome to the SAP HANA Database interactive terminal.
      Type:  \h for help with commands
             \q to quit
      hdbsql SYSTEMDB=> quit


Read more...

Environment

  • SAP HANA, platform edition 2.0

Product

SAP HANA, platform edition 2.0

Keywords

KBA , 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.