My Oracle Support Banner

Unable to start DIH Webservice/test connection to ODI from DIH application (Doc ID 2822956.1)

Last updated on MARCH 04, 2022

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.1.1 and later
Information in this document applies to any platform.

Symptoms

Problem Description

While trying to start DIH webservice or test connection to ODI from DIH application, below error comes

Error

[11-11-21 09:47:17.703][ERROR] [OdiInstanceBuilder][getInstance]ODI-10182: Uncategorized exception during repository access.
Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource
oracle.odi.core.config.WorkRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.
Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource
at oracle.odi.core.repository.Repository.getWorkRepository(Repository.java:233) ~[odi-core.jar:?]
at oracle.odi.core.OdiInstance.createWorkRepository(OdiInstance.java:638) ~[odi-core.jar:?]
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-java-8.0.27.jar:8.0.27]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-java-8.0.27.jar:8.0.27]
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828) ~[mysql-connector-java-8.0.27.jar:8.0.27]

Caused by: java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:?]
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:399) ~[?:?]
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:242) ~[?:?]
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:224) ~[?:?]

Business impact
Unable to establish connection to ODI

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
References


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