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.
SAP Knowledge Base Article - Preview