My Oracle Support Banner

"ODI-14215: Failed to perform List All Compartments on Object Storage" Error Received when Creating Object Storage Physical Schema for ODI Installed on OCI VM (Doc ID 2520696.1)

Last updated on OCTOBER 18, 2019

Applies to:

Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Oracle Data Integrator - Version 12.2.1.3.181204 and later
Information in this document applies to any platform.

Symptoms

An Object Storage Data Server was created in Oracle Data Integrator (ODI) using the following documentation:

Connectivity and Knowledge Modules Guide for Oracle Data Integrator
30 Oracle Object Storage
Setting Up the Topology
Security
https://docs.oracle.com/en/middleware/data-integrator/12.2.1.3/odikm/oracle-object-storage.html#GUID-492B4261-F646-4328-B7AE-8C7C042FFD06

The Data Server tests successfully using the Standalone Agent and the Local (No agent). When creating the Physical Schema to view the Object Storage Buckets, the following error occurs:

oracle.odi.core.service.objectstorage.OdiObjectStorageServiceException: ODI-14215: Failed to perform List All Compartments on Object Storage.
javax.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
  at oracle.odi.core.service.objectstorage.OdiObjectStorageService.getAllCompartments(OdiObjectStorageService.java:703)
  at oracle.odi.core.service.objectstorage.OdiObjectStorageService.getAllBuckets(OdiObjectStorageService.java:372)
  at com.sunopsis.graphical.frame.edit.EditFrameSnpPschema.getSnpsComboBoxObjStoreBucketName(EditFrameSnpPschema.java:933)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at com.sunopsis.graphical.definition.component.AbsUIComponentNode.locateExistingComponent(AbsUIComponentNode.java:478)
  ...
Caused by: java.util.concurrent.ExecutionException: javax.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
  at jersey.repackaged.com.google.common.util.concurrent.AbstractFuture$Sync.getValue(AbstractFuture.java:299)
  at jersey.repackaged.com.google.common.util.concurrent.AbstractFuture$Sync.get(AbstractFuture.java:286)
  at jersey.repackaged.com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:116)
  at com.oracle.bmc.util.internal.TransformingFuture.get(TransformingFuture.java:44)
  at oracle.odi.core.service.objectstorage.OdiObjectStorageService.getAllCompartments(OdiObjectStorageService.java:689)
  ... 90 more
Caused by: javax.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
  at org.glassfish.jersey.client.internal.HttpUrlConnector$3.run(HttpUrlConnector.java:299)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  ...
Caused by: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
  at sun.security.ssl.Alerts.getSSLException(Alerts.java:192)
  at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1964)
  at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:328)
  at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:322)
  at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1614)
  ...
Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
  at sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:397)
  at sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java:302)
  at sun.security.validator.Validator.validate(Validator.java:260)
  at sun.security.ssl.X509TrustManagerImpl.validate(X509TrustManagerImpl.java:324)
  at sun.security.ssl.X509TrustManagerImpl.checkTrusted(X509TrustManagerImpl.java:229)
  at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java:124)
  at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1596)
  ... 41 more
Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
  at sun.security.provider.certpath.SunCertPathBuilder.build(SunCertPathBuilder.java:141)
  at sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:126)
  at java.security.cert.CertPathBuilder.build(CertPathBuilder.java:280)
  at sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:392)
  ... 47 more

The issue can be reproduced at will with the following steps:

  1. Create an Object Storage Data Server.
  2. Test the connection using Local (No agent) or Standalone Agent
  3. Create a Physical Schema.
  4. Observe the error reported above.

Changes

 

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
Changes
Cause
Solution


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