Smart View Worksheet Getting Error "COMMON PROVIDER SESSION TYPE MISMATCH" on Refresh or Changes

(Doc ID 1520969.1)

Last updated on JANUARY 02, 2018

Applies to:

Hyperion Essbase - Version to [Release 11.1]
Information in this document applies to any platform.


In the Smart View worksheet receive error "COMMON PROVIDER SESSION TYPE MISMATCH" whenever a refresh or change is made. Message was occasional at first and could be resolved by opening and closing the worksheet.  Eventually started occuring every time. Copying the worksheet to a brand new workbook still results in the error. Using Smart View installed on workstation with Essbase

The apsserver log shows the following:

[AnalyticProviderServices0] [TRACE] [] [oracle.EPMOHPS] [tid: 17] [userId: <anonymous>] [ecid: 0000Jhck_Fd3n3P5Qfp2id1GiStM0001oF,0] [SRC_CLASS: com.hyperion.dsf.server.framework.BaseLogger] [SID: 2F05282E8141A5EA55F78BA30828E8] [APP: APS#] [SRC_METHOD: logDebug] Setting Locale for thread: 182 to en_US
[AnalyticProviderServices0] [ERROR] [] [oracle.EPMOHPS] [tid: 17] [userId: <anonymous>] [ecid: 0000Jhck_Fd3n3P5Qfp2id1GiStM0001oF,0] [SID: 2F05282E8141A5EA55F78BA30828E8] [APP: APS#] Unknown Error : Not a valid entry[[
com.essbase.api.base.EssException: COMMON PROVIDER SESSION TYPE MISMATCH

<exception errcode="10103" type="error"><desc>COMMON PROVIDER SESSION TYPE MISMATCH</desc></exception>


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