SAP Knowledge Base Article - Preview

3289144 - SDI: Unable to connect Oracle system : 403. internal error: Test unsuccessful for remote source * Reason: IO Error: The Network Adapter could not establish the connection

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 


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.