My Oracle Support Banner

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 APRIL 23, 2020

Applies to:

Oracle Analytics Cloud - Version 105.1.0 and later
Information in this document applies to any platform.

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

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
References


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