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

Last updated on JULY 27, 2019

Applies to:

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

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