Essbase-SQL/IF Users Cannot Access Essbase Load Rules In Essbase Administration Services (EAS) (Doc ID 2289885.1)

Last updated on AUGUST 01, 2017

Applies to:

Hyperion Essbase - Version 11.1.2.4.005 and later
Information in this document applies to any platform.

Symptoms

When trying to open a load rule and open the data source, it errors with

Error 1021106 Failed to Execute SQL Statement

The user has access to the tables the load rule is trying at connect to and can access those tables using sqldeveloper. This issue occurs only with certain users, other users with same access level to Essbase and database tables can access the load rule with no issues.



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