My Oracle Support Banner

Logging into P6 Web Takes Too Long after Restarting P6 EPPM (Doc ID 2881857.1)

Last updated on JULY 25, 2022

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

The first P6 Web login after P6 EPPM/WebLogic is restarted takes many minutes.  All subsequent logins complete in an acceptable time.  The SQL tool indicates that the following query takes an excessive amount of time to complete:

select clndr_id , count(*) from task where (clndr_id = 642) group by clndr_id union all select clndr_id , count(*)
from project where (clndr_id = 642) group by clndr_id;

EXPECTED BEHAVIOR

The initial P6 Web login should not take multiple minutes to complete.

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.