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
- hanadm@myhost:/usr/sap/HAN/HDB00> hdbsql -U MyKey
- 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
- hreadm@myhost:/usr/sap/HAN/HDB00> hdbuserstore set JERRY1 "myhost:30013" SYSTEM <password>
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.