ODI Test connection fails in DIH settings screen (Doc ID 2785875.1)

Last updated on FEBRUARY 27, 2022

Applies to:

Symptoms

ODI test connection fails with below errors

1. DIH.log

[24-05-21 16:49:51.831][INFO ] [DBConnect][getConnection]Connection: weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection@11c5b1
[24-05-21 16:49:51.833][ERROR] [OdiConnectWSClient][getSocket]No route to host (Host unreachable)
java.net.NoRouteToHostException: No route to host (Host unreachable)
at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:1.8.0_281]
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:476) ~[?:1.8.0_281]
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:218) ~[?:1.8.0_281]
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:200) ~[?:1.8.0_281]
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:394) ~[?:1.8.0_281]
at java.net.Socket.connect(Socket.java:606) ~[?:1.8.0_281]
at java.net.Socket.connect(Socket.java:555) ~[?:1.8.0_281]
at java.net.Socket.(Socket.java:451) ~[?:1.8.0_281]
at java.net.Socket.(Socket.java:228) ~[?:1.8.0_281]

2. DIHWebservice.log

Error occurred while initializing logging
java.lang.Exception: Error occurred while registering component
at com.ofss.fsgbu.dihcore.utils.GlobalUtils.registerComponent(GlobalUtils.java:985)
at com.ofss.fsgbu.dih.wsServer.StartService.main(StartService.java:78)



java.lang.NullPointerException
at com.ofs.aai.database.impl.GenericOFSAAConnectionFactory.getConfigConnection(GenericOFSAAConnectionFactory.java:98)
at com.ofs.aai.util.OFSAAUtils.fetchUserDetail(OFSAAUtils.java:347)
at com.ofs.aai.util.OFSAAUtils.prepareUserPreferences(OFSAAUtils.java:323)
at com.ofs.reveleus.DIH.model.DBConnect.getConnection(DBConnect.java:77)
at com.ofs.reveleus.DIH.model.DBConnect.getConnection(DBConnect.java:101)
at com.ofs.reveleus.DIH.entity.SourceSettings.getSettings(SourceSettings.java:159)
at com.ofs.reveleus.DIH.model.OdiInstanceBuilder.getInstance(OdiInstanceBuilder.java:35)
at com.ofss.fsgbu.dih.wsServer.StartService.main(StartService.java:94)

java.lang.NullPointerException
at com.ofs.aai.database.impl.GenericOFSAAConnectionFactory.getMetaConnection(GenericOFSAAConnectionFactory.java:135)
at com.ofs.reveleus.DIH.model.DBConnect.getConnection(DBConnect.java:84)
at com.ofs.reveleus.DIH.model.DBConnect.getConnection(DBConnect.java:101)
at com.ofs.reveleus.DIH.entity.SourceSettings.getSettings(SourceSettings.java:159)
at com.ofs.reveleus.DIH.model.OdiInstanceBuilder.getInstance(OdiInstanceBuilder.java:35)
at com.ofss.fsgbu.dih.wsServer.StartService.main(StartService.java:94)



Steps to reproduce:

Data Integration Hub >> Settings >> Test Connection

Business impact:
Unable to perform connector execution

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.