My Oracle Support Banner

P6 Pro Slowness During Login With Startup Filters Of View All Data (Doc ID 2564408.1)

Last updated on JULY 27, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.16.0 and later
Information 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":

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


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