My Oracle Support Banner

Error: "ORA-06512: at 'ADMUSER.PV_LOGIN'" in P6WebAccess.html Log File and Login to P6 Web Fails (Doc ID 2069363.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.3 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 8.3 and later
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

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.