My Oracle Support Banner

P6 Professional Performance Degradation With Following Three Operations -- Login Delay During 'Loading Summary Data', Refresh (F5) Operation Hangs At 'Loading Summary Data' And Opening Project(s) Hang At 98% (Doc ID 1369370.1)

Last updated on APRIL 19, 2023

Applies to:

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

Symptoms

SYMPTOM #1

When selecting Refresh (F5) in P6 Professional, the application appears to present a 'Loading Summary Data' dialog box repeatedly and can hang at certain times causing perceived performance degradation.

 

SYMPTOM #2

When opening project data the 'Loading Data' window will hang at the 98% marker. 

There are no SQL statements being executed; the delay is with P6 Professional code execution which can be observed/confirmed by P6 Professional CPU activity if watching the .exe in process monitor.

The last statement executed by P6 Professional is as follows:

SELECT st.risk_id,st.scoretype_id,st.proj_id,st.threshold_id
FROM
RISKIMPACT st,PROJSHAR prj WHERE (st.proj_id = prj.proj_id and SESSION_ID =
22916 AND LOAD_STATUS = 'L') ORDER BY 1,2

 

SYMPTOM #3

Login to P6 Professional appears to hang for a long while when a 'Loading Summary Data' dialog box is displayed.

Note, there are no SQL statements being executed; the delay is with P6 Professional code execution which can be observed/confirmed by P6 Professional CPU activity if watching the .exe in process monitor.

The last statement executed by P6 Professional is as follows:

SELECT DISTINCT T.proj_id, T.rsrc_id, T.role_id from SUMTRSRC T WHERE T.proj_id IN ( SELECT st.proj_id FROM PROJECT st Where orig_proj_id is null ) OR T.proj_id IS NULL

 

All symptoms occur when User Preference start-up filters for Resources are set to 'View All Data'.

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!


In this Document
Symptoms
Cause
Solution
References


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