My Oracle Support Banner

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

Last updated on JULY 26, 2022

Applies to:

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


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.