OBIEE 11g Implementing Essbase Single Sign-On (SSO) Using CSS Token Fails With Error " The ID or Tree Expression did not fetch any result.All IDs must be prefixed by a '#'. " (Doc ID 1608620.1)

Last updated on APRIL 16, 2015

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.0 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

Note: Please see: Document 1993210.1 - OBIEE To Essbase Supported and Recommended Authentication Method and Release notes: Section 44.4.14, "Configuring SSO for Essbase and Hyperion Financial Management Data Sources With Oracle Business Intelligence 11.1.1.5, 11.1.1.6, and 11.1.1.6.2"

You plan to Implement Single Sign-On Using CSS Token for Integration with Essbase. You have followed the steps indicated in the <Note 1480755.1>

However, when you run the following command in the step 8 of the note,
:\Oracle\MW_BI7\instances\instance1\config\foundation\11.1.2.0>epmsys_registry.bat remove property SHARED_SERVICES_PRODUCT/@applicationId

you got the following error message.

The ID or Tree Expression did not fetch any result.
All IDs must be prefixed by a '#'.
Valid expressions are like this. Please note that file and property names must b
e preceded by a '@'
PARENTCOMPONENTTYPE/FIRSTCHILDTYPE/FIRSTGRANDCHILDTYPE
Example 1 - Looking up a component - HOST/ENGINE_MANAGER
Example 2 - Looking up a property 'Description' - HOST/ENGINE_MANAGER/@Descripti
on
An error occured during the operation. Detailed Message is - java.lang.NoClassDe
fFoundError: weblogic/jdbcx/sqlserver/SQLServerDataSource


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