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 laterPrimavera 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
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 |