My Oracle Support Banner

Multiple Users Encountering Error 'Unable to connect to the database' at P6 Professional Login, Due to Corruption in User Preferences When Connected to a Version 19c Oracle Database (Doc ID 2751539.1)

Last updated on JULY 27, 2023

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 18.8 and later
Primavera P6 Professional Project Management - Version 18.8 and later
Information in this document applies to any platform.

Symptoms

When attempting to login to P6 Professional connected to a version 19c Oracle Database, different single users encounter the following error at different times, even though the database configuration is successful.  A reset of the user's Preferences is required to allow them to login again.

Unable to connect to the database.

The following errors can be in the P6ProCloudConnect WebAccess log for the affected user accounts:

ORA-03146: invalid buffer length for TTC field

ORA-03138: Connection terminated due to security policy violation

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.