Error: "Unable to connect to database" Or "The application and database version do not match" When Attempting P6 Professional Login Through Cloud Connect (Deployed To A Cluster) Configured For Single Sign On (SSO) / SAML

(Doc ID 2361587.1)

Last updated on FEBRUARY 22, 2018

Applies to:

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

Symptoms

When attempting to login to P6 Professional configured for SSO and using a Cloud Connect driver where Cloud Connect is deployed into a cluster,

The following error occurs when client side cache is turned off:

ERROR 1

"Unable to connect to database. Please run the Database Configuration tool or contact your administrator."


The following error occurs when client side cache is turned on:

ERROR 2

"The application and database version do not match. Click Exit to close the application."


ADDITIONAL INFORMATION

Regardless of having client side cache on/off, the following generates in the web server access log file:

Note, this occurs using both Round Robin and Round-Robin-Affinity load algorithms.

STEPS

The issue can be reproduced at will with the following steps:

  1. Deploy Cloud Connect to a WebLogic cluster
  2. Configure a web server to connect to the cluster
  3. Configure SSO for cloud connect
  4. Configure P6 Professional to connect to the cloud connect cluster over SSO
  5. Note the reported issue which occurs.

Changes

 

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