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