My Oracle Support Banner

ECC Full And Incremental Loads Failing With "unable to find valid certification path to requested target" SSL Exception Error For All Modules (Doc ID 3007840.1)

Last updated on JUNE 18, 2024

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

When attempting to perform full or incremental data load with EBS/ECC setup with HTTPS, the data loads fail and the following error occurs in the jobID.log and also in the UI:

ERROR 3.o.e.i.u.s.i.DataLoadControllerServiceImpl - job failed with error code:Collection ar-billproc failed with error There is an error while registering the collection Collection ar-billproc Deletion -> Dataset ar-billproc deletion failed with error IOException occurred when talking to server at://xxx.xxx.xxx:SSLPort/core_ecc, ar-billproc Collection -> Dataset ar-billproc registration failed with error IOException occurred when talking to server at: XXX.XXX.XXX:7778/core_ecc Collection ar-billproc failed with error There is an error while registering the collection Collection ar-billproc Deletion -> Dataset ar-billproc deletion failed with error IOException occurred when talking to server at://xxx.xxx.xxx:SSLPort/core_ecc, ar-billproc Collection -> Dataset ar-billproc registration failed with error IOException occurred when talking to server at://XXX.XXX.XXX:7778/core_ecc exception details:
15:32:46.786 [pool-5-thread-2] ERROR 3.o.e.i.u.s.i.DataLoadControllerServiceImpl - job failed with error code:Error while rollbacking due to issue in collection registration Error while rollbacking due to issue in collection registration exception details:
org.apache.solr.common.SolrException: Collection not found: ar-billproc

The ecc-web-<DATE>.log under $ECC_HOME/quickinstall/logs/ecc will show the following errors:

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.Alert.createSSLException(Alert.java:131) ~[na:1.8.0_321]

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

1. Setup both E-Business Suite (EBS) and Enterprise Command Center (ECC) with TLS using steps from Doc ID: 2496445.1
2. Make sure ECC certificates are imported into EBS keystore and all EBS certificates are in the correct JDK location on the EBS side
3. Test the data load to see if the load is successful

Changes

New setup implementing Enterprise Command Center (ECC) using TLS before running full and incremental loads.

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
References


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