Symptom
- Trying to connect to remote source using SAP HANA Web-based Development Workbench gives this Error:
- 403 - SQL error, server error code: 403. internal error: Test unsuccessful for remote source * Reason: IO Error: The Network Adapter could not establish the connection at BuiltinProcedure/impl/BP_CheckRemoteSource.cpp:87
- framework.trc shows:
- 2022-11-18 15:12:59,459 [INFO ] [<Session ID>] DPFramework | WorkerThread.processAdapterOpen [] - Open request for <remote Source>
2022-11-18 15:13:59,505 [ERROR] [<Session ID>] OracleConnectionFactory | OracleConnectionFactory.createConnection [] - Failed to establish connection with URL:[jdbc:oracle:thin:<Oracle DB>] and Properties:[{user=<USERID>, remarksReporting=false, password=********}] due to: IO Error: The Network Adapter could not establish the connection
2022-11-18 15:13:59,517 [ERROR] [<Session ID>] OracleLogReaderAdapter | OracleLogReaderAdapter.sdaOpen [] - Remote source database is down, HANA DPServer will try to re-connect. Refer to HANA parameter <framework.maintenancePeriod> and <framework.reconnectCount> in dpserver.ini to change reconnect interval. java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
- 2022-11-18 15:12:59,459 [INFO ] [<Session ID>] DPFramework | WorkerThread.processAdapterOpen [] - Open request for <remote Source>
Read more...
Environment
- Smart Data integration (SDI)
- Data Provisioning (DP) Agent 2.6.2.0
- OracleLogreaderAdapter
Product
SAP HANA smart data integration 2.0
Keywords
SDI Network Error , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview