My Oracle Support Banner

Slow Performance Of Loading Approvals On P6 Web (Doc ID 2677888.1)

Last updated on JUNE 11, 2020

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 18.8 to 18.8.6.0 [Release 18.8]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

P6 Web takes a long time to load the Approvals tab.

Below queries of UDF or Codes can often be traced by P6 Tracer utility (documented in Doc ID 894429.1 - How To Trace SQL And Java From The P6 Web Access Server):

E=xxxx F=xxxxx#xxx Uxxxxx SELECT udftype.table_name
UDFBusinessObjectType,udfvalue.udf_type_id UDFTypeId,udfvalue.udf_number UDFNumber,udfvalue.udf_date UDFEndDate,udfvalue.udf_text UDFText,udfvalue.fk_id ForeignKeyId,udftype.logical_data_type UDFDataType,udftype.udf_type_label UDFTypeLabel,udfvalue.udf_text UDFRAGType,udfvalue.proj_id ProjectId FROM udftype,udfvalue WHERE udfvalue.udf_type_id=udftype.udf_type_id AND udfvalue.fk_id IN ( ((select task_id from chgtask) union (select task_id from chgtaskproc) union (select task_id from chgtrsrc) union (select task_id from chgtaskactv) union (select fk_id from chgudfvalue))) AND udftype.table_name = ? AND ((udfvalue.udf_type_id IN (xxx,xxx,xxx,......))) v 1. TASK

E=xxx F=xxxx#xxx UxxxxSELECT taskactv.actv_code_id ActivityCodeId,taskactv.actv_code_type_id ActivityCodeTypeId,actvtype.actv_code_type ActivityCodeType,taskactv.task_id ActivityId,actvcode.actv_code_name ActivityCodeName,actvcode.short_name ShortName,taskactv.proj_id ProjectId FROM actvcode,actvtype,taskactv WHERE taskactv.actv_code_id=actvcode.actv_code_id AND taskactv.actv_code_type_id=actvtype.actv_code_type_id AND taskactv.task_id IN ( ((select task_id from chgtask) union (select task_id from chgtaskproc) union (select task_id from chgtrsrc) union (select task_id from chgtaskactv) union (select fk_id from chgudfvalue))) AND ((taskactv.actv_code_type_id IN (xxx, xxx,......)))

 

EXPTECTED BEHAVIOR

The performance of loading Approvals tab is improved.

 

The issue can be reproduced at will with the following steps:
1. Log on P6 Web.
2. Click Approvals. It takes long time to complete the page loading.

Changes

 

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
Changes
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.