SDI DP Agent - Unable to make JDBC connection to server. exception 151044: Agent is not available

[wzuluaga]

Hello team,

Can't connect on-premise DP Agent to HANA in the cloud. It connects at first but then it says " Unable to make JDBC connection to server"
On the WebIDE, I get Agent "<DP Agent Name>" is not available

Any ideas on this issue?

Thank you

[bob_gallo58]

Are you following teh direction in SDI Doc: Connect to SAP HANA Cloud?
Do you see any other messages about the error message in the framework.trc?

[bob_gallo58]

Looking a the message please set the jdbc.encrypt=true in the dpagentconfig.ini,
Thank you

[wzuluaga]

Thanks, Bob. It is set to true, however, it does not work even after stopping and starting the agent again.
Regards.

[bob_gallo58]

It seems that you agent cannot connect to Hana for some reason, maybe permissions?
Take a Look at the DP Agent Framework_alert.trc and Framework.trc for clues of why you cannot connect.
/sap/dataprovagent/log ==>Linux
\spa\dataproagent\log ==> Windows

[wzuluaga]

It says:
2023-01-30 12:40:57,618 [ERROR] DPFramework | JDBCConnector.makeConnection - com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://<xxxxxxxxx>.hanacloud.ondemand.com:443:443 [Receive of connect failed.].

2023-01-30 12:40:57,618 [ERROR] DPFramework | JDBCConnector.read - Unable to make JDBC connection to server.
Unable to make JDBC connection to server.