OBIEE 11g: When Invoking epmsys_registry.sh Command During Configuring SSO For Essbase: Error -"java.sql.sqlsyntaxerrorexception:ora-00942" (Doc ID 2128973.1)

Last updated on AUGUST 08, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 to 11.1.1.7.151020 [Release 11g]
Information in this document applies to any platform.

Symptoms

On 11.1.1.7.0 version of Oracle Business Intelligence Enterprise Edition (OBIEE), the below scenario is observed:

Fusion Middleware Release Notes

42.4.25.1 Configuring SSO for Essbase and Hyperion Financial Management Release 11.1.2.1 or Later

URL - http://docs.oracle.com/cd/E28280_01/doc.1111/e14774/biee.htm#ASRWA5872

BI_ORACLE_INSTANCE/config/foundation/11.1.2.0/epmsys_registry.sh removeproperty
SHARED_SERVICES_PRODUCT/@applicationId

ERROR
-----------------------
java.sql.sqlsyntaxerrorexception:ora-00942

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