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
- Log into P6 web.
- Choose Team member.
- 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 |