Error: "You are not authorized to access this page. Contact administrator" When Attempting to Login with IDCS Account in OAC Essbase (Doc ID 2662257.1)

Last updated on JULY 26, 2022

Applies to:

Symptoms

After logging in with a service account error page "You are not authorized to access this page. Contact administrator."
Account is configured as a service administrator in IDCS.

Also, the same id cannot log in the MaxL client.
login <USER> <PASSWORD> on <URL>;

  ERROR - 103 - Unexpected Essbase error 1051293.
  ERROR - 1040053 - Login failed with error 1051293. Verify the URL and the login credentials.

Errors in logs have the following:

 security log:
[<DATE>] [<SERVER>] [ERROR] [] [oracle.essbase.security] [<TID>] [<USER_ID> ] [<ECID>] [<APP>] [partition-name:] [tenant-name:] [SRC_CLASS: oracle.essbase.security.opssnative.NativeAuthorizationService] [SRC_METHOD: refreshRoles] Error while fetching roles for subject [<USER>].[[
oracle.essbase.security.persistence.EssbaseSecurityPersistenceException: failed.to.fetch.role.details
at oracle.essbase.security.persistence.eao.EssbaseUserRolesEAOImpl.fetchEssbaseServiceRole(EssbaseUserRolesEAOImpl.java:514)
...(more stack trace)...
Caused by: javax.persistence.NonUniqueResultException: More than one result was returned from Query.getSingleResult()
at org.eclipse.persistence.internal.jpa.QueryImpl.throwNonUniqueResultException(QueryImpl.java:985)

Cause

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