Smart View Worksheet Getting Error "COMMON PROVIDER SESSION TYPE MISMATCH" on Refresh or Changes (Doc ID 1520969.1)

Last updated on JULY 29, 2016

Applies to:

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

Symptoms

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 11.1.2.2.300 installed on workstation with Essbase 11.1.2.2.

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#11.1.2.0] [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#11.1.2.0] 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>

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