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.