3384188 - Error "SQL error code =-709" when connecting HANA On Premise into SAP Datasphere

Error when validating HANA On-Prem connection in SAP Datasphere:

Error occurred when connecting to Hana database. [SQL error code =-709] Code:1300004

SAP Datasphere

In DPAgent log file (framework.trc) find the following error entry:

20XX-XX-XX XX:XX:XX,XX [ERROR] [XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXXXXXXX] DPFramework | WorkerThread.processRequest [] - com.sap.hana.dp.adapter.sdk.AdapterException: Error occurred when connecting to Hana database. [SQL error code =-709] Context: com.sap.db.jdbc.exceptions.SQLNonTransientConnectionExceptionSapDB: Data receive failed.: XX.XX.XX.XX:PORT_NUMBER -> HANA_HOST:PORT_NUMBER ConnectionID:0 SessionID:0
                                at com.sap.db.jdbc.exceptions.SQLExceptionSapDB._newInstance(SQLExceptionSapDB.java:159)
                                at com.sap.db.jdbc.exceptions.SQLExceptionSapDB._newInstance(SQLExceptionSapDB.java:222)
                                at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.newInstanceWithMessage(SQLExceptionSapDB.java:58)
                                at com.sap.db.jdbc.exceptions.ConnectionException.createException(ConnectionException.java:23)
                                at com.sap.db.jdbc.ConnectionSapDB._handleSendReceiveException(ConnectionSapDB.java:6434)
                                at com.sap.db.jdbc.ConnectionSapDB._receive(ConnectionSapDB.java:5973)
                                at com.sap.db.jdbc.ConnectionSapDB.exchange(ConnectionSapDB.java:2566)

Adjust the HANA SQL Port defined in Datasphere's connection.

Connect to HANA On-Premise via SQL Port as explained at SAP HANA Connections:
"You can find the SQL port in the list of service details in the SAP HANA Cockpit. For more information, see Service Details in the SAP HANA Administration with SAP HANA Cockpit documentation."

KBA , DS-DI-CON , Connections , Known Error