My Oracle Support Banner

Error "Unexpected login error" When Attempting to Login to P6 Web (Doc ID 2980232.1)

Last updated on OCTOBER 22, 2023

Applies to:

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

Symptoms

When a user attempts login to P6 EPPM Web, the following error is received:

Unexpected login error

The following error can also be found in the <P6 EPPM home>\p6\WebAccess\P6WebAccess.html log file:

ERROR /action/login (User Id: ### DB Id: #) com.primavera.bo.base.DBEngineImpl SQLSynxaxErrorException: <complicated SELECT query>
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

Changes

 

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!


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