EM Login Fails with: Authentication failed. If problem persists, contact your system administrator. java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition (Doc ID 2589827.1)

Last updated on DECEMBER 04, 2023

Applies to:

Symptoms

Cannot login to EM with SYSMAN etc. accounts.
The EM Console login errors with:

User Name: sysman
Password: xxxxx

Authentication failed. If problem persists, contact your system administrator.

Using EMCLI we get:
./emcli login -username=sysman -password=xxxxxxx
Error: Login failed

File = emoms.trc in DEBUG shows:

2019-09-05 13:44:57,281 [[ACTIVE] ExecuteThread: '76' for queue: 'weblogic.kernel.Default (self-tuning)'] INFO auth.EMRepLoginFilter doFilter.276 - RepLoginFilter Entry. Request URI = /em [isEMCLI = false] [req.remoteUser = SYSMAN] [header.Proxy-Remote-User = null] [req.userPrincipal = SYSMAN]
2019-09-05 13:44:57,282 [[ACTIVE] ExecuteThread: '76' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG auth.EMLoginService isReposUser.378 - Determining if user is repos user? :Subject:
Principal: SYSMAN
Principal: EMUSER
Principal: EMREPOSUSER
Principal: EMBIPAdministrators
Principal: Administrators

2019-09-05 13:44:57,297 [[ACTIVE] ExecuteThread: '76' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG conn.FGAConnection _setConnContext.362 - connection obj=1732154369 trueUserName=SYSMAN operation=1 emKey is NULL =false auditSessionGuid=null auditSessionGuidType=null
2019-09-05 13:44:57,416 [[ACTIVE] ExecuteThread: '76' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG auth.EMLoginService _performLogin.1266 - Error
java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition
ORA-06512: at "SYSMAN.MGMT_AUDIT", line 919
ORA-06512: at "SYSMAN.MGMT_AUDIT", line 417
ORA-06512: at "SYSMAN.EM_USER_MODEL_UI", line 1683
ORA-06512: at line 1

2019-09-05 13:44:57,421 [[ACTIVE] ExecuteThread: '76' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG conn.FGAConnection fgaClose.320 - Connection object closed: 1585085884
2019-09-05 13:44:57,423 [[ACTIVE] ExecuteThread: '76' for queue: 'weblogic.kernel.Default (self-tuning)'] DEBUG auth.EMLoginService _performLogin.1283 - Exit: Fail
2019-09-05 13:44:57,424 [[ACTIVE] ExecuteThread: '76' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN auth.EMRepLoginFilter doFilter.454 - InvalidEMUserException caught in EMRepLoginFilter: Failed to login using repository authentication for user: SYSMAN
oracle.sysman.emSDK.sec.auth.InvalidEMUserException: Failed to login using repository authentication for user: SYSMAN

THINGS CHECKED:
A)
SYSMAN password Working with:
-SQLPLUS connection with SYSMAN is working with repository connect string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOST>)(PORT=1521)))(LOAD_BALANCE=ON)(CONNECT_DATA=(SERVICE_NAME=EMREP)))
-EMCTL accepts the SYSMAN password for command that require it such as "emctl status oms -details"

No password changes were done before the login issue started to happen.

B)
Also ruled out:
Doc ID 1493151.1: EM 12c, EM 13c: Login to Enterprise Manager Cloud Control with the Correct Password Fails with Error: Authentication failed.

Cause

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