HANA to HANA SDA (Smart Data Access) Issue

[celo_berger]

Hi,

I'm trying to do SDA from with my S/4 system being the target (HANAS4), and my BW on HANA being the Source (HANABW). We have some data in BW that we want to use when creating the virtual models from S/4.

Both environments are in the same HANA DB, but under different tenants.

The user in S/4 has the correct System Privilege: CREATE REMOTE SOURCE

We didn't do any connector setup since we're assuming the HANA ODBC driver was automatically installed.

We created a new user in BW for the connection. Virtual Names are all maintained, but when I try to activate the connection, I get the error below:

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [SAP AG][LIBODBCHDB SO][HDBODBC] Communication link failure;-10709 Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused

I've looked left and right across the the mighty interwebs for a How To Guide specifically for HANA to HANA SDA setup but haven't found anything.

Any help would be greatly appreciated.

Thank you!

[former_member597073]

Hi celoberger

ask os team to add ip address of source and remote in os

Thanks You

Srikanth

[thomadi1]

Not sure if the originator here found an answer since this is years old....but I got this exact error and MY issue was that I had wrong UserName and/or password for "Credentials," and so this caused the error. Once a valid username/pw was put in place for Credentials, i.e. a username/pw which existed on the Target system, then the error went away.

[former_member291651]

Hi all,

I faced the same issue.

I tried to check Server and Port, please note that if your Instance is 00, the port you need to input is: 30015. It worked for me,

I hope it can help.

Regards,

Sang Tran

[former_member298205]

Hi

same error here, did you solve it ?

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [SAP AG][LIBODBCHDB SO][HDBODBC] Communication link failure;-10709 Connection failed (RTE:[89006] System call 'connect' failed, rc=110:Connection timed out

Best wishes,

Robert

[Former Member]

Hello Everyone,

Have found any solution for this Issue??
Because we are getting similar Issue when trying to connect two different HANA instances on cloud?
Is it possible to connect two HANA Instances on cloud via SDA ?? Thanks Inadvance

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [SAP AG][LIBODBCHDB SO][HDBODBC] Communication link failure;-10709 Connection failed (RTE:[89006] System call 'connect' failed, rc=110:Connection timed out

[former_member298064]

Single DB system:

• port 3xx15 connects to the master index server SQL port, where 'xx' is the instance number
  • Example:
  • ./hdbsql -n HOSTNAME -d SystemDB
  • ./hdbsql -n HOSTNAME:3xx15

Multitenant DB system (MDC):

• Port 3xx13 connects to the SYSTEMDB SQL port
• Port 3xx41 connects to the 1st tenant database SQL port
• Port 3xx44 connects to the 2nd tenant database SQL port

• Example:
• ./hdbsql -n HOSTNAME -d SystemDB
• ./hdbsql -n HOSTNAME:3xx13
• ./hdbsql -n HOSTNAME -d Tenant1
• ./hdbsql -n HOSTNAME:3xx41

[HakanHaslaman]

May this help:

1. Verify, if user name and password are correct.
2. Check, if the user have the system privilege CREATE REMOTE SOURCE or DATA ADMIN in target DB.
3. You have configured an ODBC connection from SAP HANA to the remote database.
4. Be sure, that the remote data source is reachable by the network from the computer you are using.
5. Please following admin guide for assistance.
   

[smohamedhassan]

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [SAP AG][LIBODBCHDB SO][HDBODBC] General error;10 authentication failed

[Former Member]

hi,

I am facing the same issue. Please let me know the resolution.

[Former Member]

Hi Marcelo,

Did you check SAP Note 2316463 - * -10709: Connection failed (RTE:[89006] System call 'connect' failed, rc=111:Connection refused?

Kind regards,

Andrey

[former_member287033]

DId you guys resolve this issue? I am facing same issue while trying to connect B4HANA System to S/4 HANA SYstem.

[Former Member]

Hi Marcelo,

Were you able to resolve this issue? If so, could you please share the solution?

I am trying to SDA from an on-premise HANA instance to another HANA instance on cloud, and getting the same error.

Thanks,

Sarath

[Former Member]

do you use dynamic tiering?