Search code examples
sqlbigdatahanavora

SQL Editor of SAP HANA Vora Tools cannot connect with HANA

I try to show SAP HANA tables from SQL Editor of SAP HANA Vora Tools like below:

show tables 
using com.sap.spark.hana
options 
(
host "192.168.88.200",
instance "00",
port "30215",
user "SYSTEM",
passwd "Passw0rd",
dbschema "LEAGUE_SCHEMA"
);

but appears this error:

com.sap.spark.hana.client.HANAJdbcBadStateException: [DefaultHANAConfiguration(192.168.88.200,00,30215,SYSTEM,Passw0rd,None)] Cannot acquire a connection with error code 0, status ERROR_STATUS

ERROR

Host, instance, port, user, passwd parameters are correct, and the dbschema is created in SAP HANA successfully.

What could be the error?

Thanks for the support!

Solution

  • Omit the 'port' parameter if it is not a multi-tenant HANA.