My Oracle Support Banner

Team Member Page Not Loading Due to Error "ORA-01795: maximum number of expressions in a list is 1000" (Doc ID 2930424.1)

Last updated on MAY 15, 2023

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 21.12.12.0 to 21.12.13.0 [Release 21.12]
Primavera P6 Enterprise Project Portfolio Management - Version 22.12.1.0 to 22.12.3.0 [Release 22.12]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 23.1 to 23.2 [Release 23.1 to 23.2]
Information in this document applies to any platform.

Symptoms

Team member page does not load for particular user(s).

Error captured in p6webaccess.html and/or p6.log

<SQLSynxaxErrorException: SELECT * FROM
(SELECT chgtask.status_code ApprovalStatus,chgtask.new_complete_pct
PendingPercentComplete,chgtask.new_remain_equip_qty
PendingRemainingNonLaborUnits,chgtask.new_remain_work_qty
PendingRemainingLaborUnits,chgtask.proj_id
ProjectId,chgtask.new_act_start_date PendingActualStart,task.clndr_id
CalendarId,chgtask.task_id ActivityId,task.task_type
ActivityType,chgtask.new_cstr_type
PendingConstraintType,chgtask.new_resume_date
PendingResumeDate,chgtask.new_suspend_date
PendingSuspendDate,chgtask.new_exp_end_date
PendingExpectedFinish,chgtask.all_data AllData,chgtask.transaction_id
TransactionId,chgtask.new_act_equip_qty
PendingActualNonLaborUnits,chgtask.new_act_end_date
PendingActualFinish,chgtask.new_remain_drtn
PendingRemainingDuration,chgtask.new_act_work_qty
PendingActualLaborUnits,chgtask.new_cstr_date
PendingConstraintDate,task.wbs_id WbsId,chghead.transaction_date
TransactionDate FROM chghead,chgtask,task,taskuser WHERE
chgtask.task_id=taskuser.task_id(+) AND chgtask.task_id=task.task_id AND
chgtask.transaction_id=chghead.transaction_id AND (((chghead.request_user_id
= 224) AND (chgtask.status_code = 'PENDING' OR chgtask.status_code = 'HELD'
OR chgtask.status_code = 'REJECTED')) AND (taskuser.user_id IS NULL OR
taskuser.user_id IN (224) OR chgtask.task_id IN (346117 , 346116 , 229377 ,
346119 , 229376 , 346118 , 346113 , 346112 , 231429 , 346115 , 346114 ,
229387 , 231435 , 346124 , 229391 , 346121 , 346120 , 229389 , 315402 ,

...

315386 , 346107 , 346106))) order by chghead.transaction_date asc,
chgtask.task_id asc, chgtask.transaction_id asc) WHERE rownum
<=10000001--ORA-01795: maximum number of expressions in a list is 1000

Steps to Reproduce

  1. Log into P6 web.
  2. Choose Team member.
  3. Page will not load.

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.