SAP Knowledge Base Article - Public

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

Symptom

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

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

Environment

SAP Datasphere

Cause

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)

Resolution

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."

Keywords

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

Product

SAP Datasphere all versions