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 11.1.2.4.005 and laterInformation 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
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
Symptoms |
Cause |
Solution |