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:

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

Cause

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