Question Re: HANA Database Connection Error in Technology Q&A

HANA Database Connection Error

Former Member — Thu, 04 Feb 2021 03:19:08 GMT

I am new to HANA database and am attempting to make a connection from either python or SQL. With the set of username and password set in the python connection file is correct and can be used to log in to HANA explorer. Yet when I run the file on the local machine, it returns the below error:

hdbcli.dbapi.Error:
(-10709, 'Connection failed (RTE:[1000013] wrong provider for this platform
(zeus.hana.canary.eu-central-1.whitney.dbaas.ondemand.com:41587))')

I also tried to run this command on HDBSQL:

hdbsql -n zeus.hana.canary.eu-central-1.whitney.dbaas.ondemand.com:41587 -u ... -p ... -e

Even though username and password are specified in the command, the system still requests entering username and password again.

And then I got the error below:

-10709: Connection
failed (RTE:[89006] System call 'connect' failed, rc=10061:No connection could
be made because the target machine actively refused it (localhost:30015))

Anything I've missed? Package versions:

hdbcli==2.7.21
hdbsql==2.7.17.1607722875

Re: HANA Database Connection Error

BitanC — Thu, 04 Feb 2021 05:57:47 GMT

Hello Wanchen,

The error text is bit generic and there can be multiple reasons behind that. But it is clear that by any of the reasons your provided string is not able to connect the HANA server.

You may check one by one like below

hostname is reachable from your client

hostname:port combination are not blocked by security policies

the provided port is sql port and correctly mentioned

mention -d to specify tenant

please take a look on below for details of hdbsql

Log On to a Database - SAP Help Portal

Hope this helps.

Thanks,

Bitan

Re: HANA Database Connection Error

dvankempen — Thu, 04 Feb 2021 09:04:43 GMT

Hi Wanchen,

To elaborate on Bitan's response, in most cases, tthe client has no access to the instance.

Could you check the instance properties?

Re: HANA Database Connection Error

dvankempen — Fri, 05 Feb 2021 08:26:03 GMT

Got the answer to your question? To improve the knowledge base and make the right answers easier to find, please mark the best answer and close the question. Thanks!

Don’t know how? See Ask and Answer Questions on SAP Community

For the readers, before you leave, don't forget to up/down vote the answers. You can vote on the question too.

Thanks.