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

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 hundreds of Community platforms