ODI Test connection fails in DIH settings screen
(Doc ID 2785875.1)
Last updated on FEBRUARY 27, 2022
Applies to:
Oracle Financial Services Data Integration Hub - Version 8.1.1 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |