My Oracle Support Banner

DataSync: "Cannot connect to Provider" Error While Using an Essbase Data Source (Doc ID 2493945.1)

Last updated on SEPTEMBER 03, 2019

Applies to:

Oracle Analytics Cloud - Version 18.2.1 and later
Information in this document applies to any platform.

Symptoms

You are using an Essbase Cloud source in Data Sync.  When you execute the job using this source you see this error:

131 INFO <timestamp> Non-server-state message from 127.0.0.1(127.0.0.1) received
132 SEVERE <timestamp>
ANOMALY INFO::: Connection test error!
MESSAGE:::Error while connecting to https://<host>/essbase/japi as <user>
EXCEPTION CLASS::: com.oracle.datasource.pluggablesource.exception.PluggableSourceConnectionException
com.oracle.dataflow.datareader.essbase.EssbaseSource.connect(EssbaseSource.java:80)
com.oracle.dataflow.datareader.essbase.EssbaseSource.test(EssbaseSource.java:69)
com.siebel.etl.database.DBUtils.testConnection(DBUtils.java:2029)
com.siebel.etl.database.WeakDBUtils.testConnection(WeakDBUtils.java:665)
com.siebel.etl.gui.data.StaticDatabaseCalls.testDatabaseConnection(StaticDatabaseCalls.java:646)
com.siebel.etl.net.ExecutionPlan.getDatabaseStatus(ExecutionPlan.java:233)
com.siebel.etl.net.ClientMessageDispatcher$WorkerThread.mBeanRequestDatabaseStatus(ClientMessageDispatcher.java:397)
com.siebel.etl.net.ClientMessageDispatcher$WorkerThread.consoleMessage(ClientMessageDispatcher.java:220)
com.siebel.etl.net.ClientMessageDispatcher$WorkerThread.run(ClientMessageDispatcher.java:135)
java.lang.Thread.run(Thread.java:748)
::: CAUSE :::
MESSAGE :::Cannot connect to Provider Server.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
EXCEPTION CLASS::: com.essbase.api.base.EssException

 

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.