P6 Pro Slowness During Login With Startup Filters Of View All Data
(Doc ID 2564408.1)
Last updated on MARCH 22, 2022
Applies to:
Primavera P6 Enterprise Project Portfolio Management - Version 16.2.16.0 and laterInformation in this document applies to any platform.
Symptoms
Note: While this was reported in P6 Professional 16.2.16, this symptom would also be applicable to earlier releases as well.
Using P6 Professional for EPPM, with these "startup filters":
- Resources (View All Data)
- Roles (View All Data)
- OBS (View All Data)
- Activity Codes (View All Data)
- Cost Accounts (View All Data)
- Resource Summary Data (UNCHECKED)
the following query is generated and it is running for minutes.
SELECT T.wbs_id, T.proj_id, T.complete_cnt, T.active_cnt, T.notstarted_cnt, T.base_complete_cnt, T.base_active_cnt, T.base_notstarted_cnt, T.act_drtn_hr_cnt, T.act_equip_qty, T.act_work_qty, T.total_drtn_hr_cnt, T.base_drtn_hr_cnt, T.base_work_qty, T.base_equip_qty, T.etc_work_qty, T.remain_drtn_hr_cnt, T.remain_work_qty, T.remain_equip_qty, T.total_float_hr_cnt, T.act_expense_cost, T.act_work_cost, T.act_equip_cost, T.base_expense_cost, T.base_work_cost, T.base_equip_cost, T.bcwp, T.etc, T.bcws, T.remain_expense_cost, T.remain_work_cost, T.remain_equip_cost, T.perfm_work_qty, T.sched_work_qty, T.act_end_date, T.act_start_date, T.base_end_date, T.base_start_date, T.reend_date, T.restart_date, T.act_this_per_work_cost, T.act_this_per_work_qty, T.act_this_per_equip_cost, T.act_this_per_equip_qty, T.base_mat_cost, T.remain_mat_cost, T.act_mat_cost, T.act_this_per_mat_cost, T.eac_work_qty FROM SUMTASK T, PROJWBS P WHERE T.WBS_ID=P.WBS_ID ORDER BY T.proj_iD
A trace shows the following items and timing:
2018-10-09 2:07:33 PM -- 1217ms
executed id:244534928
Token:TaskSumAdapter.LoadSumTask_NO_Portfolio_No_Delay_SuperUser
2018-10-09 2:07:34 PM -- 113117ms
end id:244534928
Token:TaskSumAdapter.LoadSumTask_NO_Portfolio_No_Delay_SuperUser ->FetchCount: 564368
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 |