Error: "ORA-01795: maximum number of expressions in a list is 1000" When Accessing Team Member. (Doc ID 2266267.1)

Last updated on MAY 22, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.2.0.0 to 15.2.13.0 [Release 15.2]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 15.2.0.0 to 15.2.13.0 [Release 15.2]
Information in this document applies to any platform.

Symptoms

When attempting to log into Team Member and access My Tasks, the following error occurs:

ERROR
-----------------------
Alert
Error while trying to load assignments: Error while trying to load resources: DBEngine.executeSelect: {SELECT * FROM (SELECT task.rsrc_id PrimaryResourceId,task.proj_id ProjectId,alias_projwbs.wbs_name ProjectName,task.restart_date RemainingStart,projwbs.wbs_name WbsName,task.expect_end_date ExpectFinishDate,task.location_id LocationId,task.task_id ActivityId,rsrc.rsrc_name PrimaryResourceName,task.remain_drtn_hr_cnt RemainingDuration,task.act_start_date ActualStart,task.task_name ActivityName,task.status_code ActivityStatus,task.cstr_type ConstraintType,task.cstr_type2 ConstraintType2,task.external_early_start_date ExternalEarlyStartDate,task.target_start_date PlannedStart,task.target_end_date PlannedFinish,task.act_work_qty ActualLaborUnits,task.act_end_date ActualFinish,task.wbs_id WbsId,task.act_equip_qty ActualNonLaborUnits,task.target_work_qty PlannedLaborUnits,task.control_updates_flag ReviewRequired,task.starred_flag IsStarred,taskuser.user_id ActivityOwnerUserId,task.remain_work_qty RemainingLaborUnits,task.reend_date RemainingFinish,task.remain_equip_qty RemainingNonLaborUnits,rsrc.rsrc_short_name PrimaryResourceShortName,project.proj_short_name ProjectIdName,task.complete_pct_type PercentCompleteType,task.external_late_end_date ExternalLateFinishDate,task.review_end_date ReviewFinishDate,task.clndr_id CalendarId,task.task_type ActivityType,task.phys_complete_pct DBPhysicalPercentComplete,project.step_complete_flag ProjectPhysicalPctCptUseSteps,task.target_drtn_hr_cnt PlannedDuration,task.act_work_qty + task.act_equip_qty ActualUnits,task.remain_work_qty + task.remain_equip_qty RemainingUnits,task.task_code ActivityCode FROM projwbs alias_projwbs,project,projwbs,rsrc,task,taskuser WHERE (task.wbs_id=projwbs.wbs_id AND task.proj_id=projwbs.proj_id) AND task.proj_id=alias_projwbs.proj_id and alias_projwbs.proj_node_flag='Y' AND task.proj_id=project.proj_id AND task.rsrc_id=rsrc.rsrc_id(+) AND task.task_id=taskuser.task_id(+) AND ((((task.task_id IN (43

Team Member log shows error entry: "ORA-01795: maximum number of expressions in a list is 1000"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log onto Team Member.
2. Error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms