My Oracle Support Banner

Smart View Writing Error to Analytic Provider Services Log (apsserver.log) When Connecting to Essbase Server "error in Common Provider, Invalid datasource " (Doc ID 2330397.1)

Last updated on NOVEMBER 21, 2017

Applies to:

Hyperion Essbase - Version 11.1.2.4.011 and later
Information in this document applies to any platform.

Symptoms

In Smart View, as soon as you select "Oracle Essbase" from Shared Connections, the error appears in the /Oracle/Middleware/user_projects/domains/EPMSystem/servers/AnalyticProviderServices0/logs/apsserver.log:

[2017-10-31T15:49:44.090+00:00] [AnalyticProviderServices0] [ERROR] []
[oracle.EPMOHPS] [tid: 27] [userId: <anonymous>] [ecid:
005NDaoBCSdBT81_vtDCiX0002cD000017,0:1] [APP: APS#11.1.2.0] [SID:
159A7E4BD57A25213569AF5387533B] error in Common Provider, Invalid datasource
[[
com.essbase.api.base.EssException: error in Common Provider, Invalid 
datasource
at com.essbase.smartview.SmartViewException.getEssException(Unknown
Source)
at com.essbase.smartview.util.EssLogger.writeException(Unknown
Source)
at com.essbase.smartview.xml.XmlHandler.invoke(Unknown Source)
at com.essbase.smartview.xml.XmlHandler.invoke(Unknown Source)
at com.essbase.smartview.xml.XmlHandler.invoke(Unknown Source)
at com.essbase.smartview.xml.EssbaseSmartView.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at
weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecu
rityHelper.java:227)

The error occurs when using either a Shared or Private connection, as soon as you click the Oracle Essbase listed, the error message is written to the apsserver.log.

 

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!


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