Error: "500--Internal Server Error" Connecting to P6 (Web) and Following Errors Are Noted in the P6WebAccess.html Log File: "java.sql.SQLException: ORA-28001: the password has expired" and "java.sql.SQLException: ORA-28000: the account is locked" (Doc ID 2147715.1)

Last updated on JUNE 09, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.4.0.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 8.4.0.0 and later
Information in this document applies to any platform.

Symptoms

When connecting to the P6 (web) login page, the following error occurs:

ERROR
-----------------------
Error 500 - Internal Server Error
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.

And the P6WebAccess.html log file contains the following errors:

ERROR
-----------------------
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Establish connection error.
...
Caused by: java.sql.SQLException: ORA-28001: the password has expired

and
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Establish connection error.
...
Caused by: java.sql.SQLException: ORA-28000: the account is locked


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to P6 Web URL in browser
2. See Error
3. View P6 logs for causes

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