My Oracle Support Banner

Unable to Load Team Member - My Tasks Page (Doc ID 2341835.1)

Last updated on JANUARY 08, 2018

Applies to:

Primavera P6 Team Member - Version 15.1.5.0 and later
Information in this document applies to any platform.

Symptoms

Team Member - My Tasks Page is getting an Alert Message when user is trying to login into Team Member -> My Tasks.

ERROR
-----------------------
Error while trying to load activities: DBEngine.executeSelect: {SELECT * FROM (SELECT task.remain_drtn_hr_cnt RemainingDuration,task.complete_pct_type PercentCompleteType,task.task_id ActivityId,task.phys_complete_pct DBPhysicalPercentComplete,project.step_complete_flag ProjectPhysicalPctCptUseSteps,task.proj_id ProjectId,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_type ActivityType,task.status_code ActivityStatus,task.target_start_date PlannedStart,task.act_work_qty ActualLaborUnits,task.target_work_qty PlannedLaborUnits,task.starred_flag IsStarred,rsrc.rsrc_short_name PrimaryResourceShortName,task.reend_date RemainingFinish,task.clndr_id CalendarId,rsrc.rsrc_name PrimaryResourceName,task.act_start_date ActualStart,task.restart_date RemainingStart,task.cstr_type ConstraintType,task.cstr_type2 ConstraintType2,task.external_early_start_date ExternalEarlyStartDate,task.location_id LocationId,task.review_end_date ReviewFinishDate,task.expect_end_date ExpectFinishDate,alias_projwbs.wbs_name ProjectName,task.act_end_date ActualFinish,task.external_late_end_date ExternalLateFinishDate,projwbs.wbs_name WbsName,task.target_end_date PlannedFinish,task.task_name ActivityName,task.act_equip_qty ActualNonLaborUnits,task.remain_work_qty RemainingLaborUnits,task.wbs_id WbsId,task.task_code ActivityCode,task.control_updates_flag ReviewRequired,project.proj_short_name ProjectIdName,task.remain_equip_qty RemainingNonLaborUnits,task.rsrc_id PrimaryResourceId 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 ((taskuser.user_id = 2016 OR task.rsrc_id IN (37727)) AND (task.act_end_date IS NULL OR task.act_end_date >= TO_DATE('2017-03-05 00:00:00','yyyy-mm-dd hh24:mi:ss'))) order by task.task_id asc) WHERE rownum <=1025} null

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Log into Team Member
  2. The page takes a long time to load
  3. Error reported above is seen
  4. Click OK on the alert and the page starts to load

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.