Login Fails with Error "ORA-06512: at "ADMUSER.PV_LOGIN"" Reported in P6WebAccess.html Log File (Doc ID 2069363.1)

Last updated on JUNE 29, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.3 to 8.3.9.0 [Release 8.3]
Information in this document applies to any platform.

Symptoms

User login to P6 Web fails.

Executing P6 API code the Authentication / Login fails with following error:

Invalid user name and/or password.
com.primavera.common.exceptions.InvalidCredentialsException: Invalid user name and/or password.

In the P6WebAccess.html Log file find the following corresponding errors:

ERROR com.primavera.bo.datacaches.ServerUserPrivsCache ?:? Failed loading user privilege information for user: 1537
com.primavera.PhoenixException: loadRootWbsNodesForLoginUser failed with error
...
Caused by: com.primavera.PhoenixException: DBEngine.executeStatement for {call pv_login(?, ?, ?, ?)}failed:ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  ORA-06512: at "ADMUSER.PV_LOGIN", line 31
  ORA-06512: at line 1
...
Caused by: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  ORA-06512: at "ADMUSER.PV_LOGIN", line 31
  ORA-06512: at line 1

This only effect some Non Admin Superusers.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms