Error: "Teammember_error_generic" When Loading Team Member

(Doc ID 2389742.1)

Last updated on MAY 07, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 17.12.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to load the Team Member page, Error "Teammember_error_generic" pops up to end user and below exception is logged to P6WebAccess.html of Team Member.

ERROR
-----------------------
com.oracle.pgbu.rest.resources.teammember.TeamMemberResource handleException
SEVERE: Failed to load tasks with filter -activeAndCompleted
........................................................
Caused by: com.primavera.bo.base.DBEngineException: 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.resume_date ResumeDate,task.suspend_date SuspendDate,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,projwbs.wbs_short_name WbsShortName,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 ((taskuser.user_id = XXX) AND ((task.act_end_date IS NULL OR task.act_end_date >= TO_DATE('xxxx-xx-xx 00:00:00','yyyy-mm-dd hh24:mi:ss')) AND (project.project_flag = 'Y' AND CASE WHEN project.orig_proj_id IS NULL THEN 'N' ELSE 'Y' END = 'N' AND projwbs.status_code = 'WS_Open'))) order by task.task_id asc) WHERE rownum <=1025}
null
at com.primavera.bo.base.h.executeSelect(DBEngineImpl.java:1080)
at com.primavera.bo.base.h.executeSelect(DBEngineImpl.java:916)
...
Caused by: com.primavera.infr.db.ConnectionRecycledException: Connection has been recycled. Database XXXXX Pool PMR
at com.primavera.infr.db.PConnection.a(PConnection.java:276)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log on to Team Member (TM).
2. The TM page loads data for a long time and fails with error "Teammember_error_generic", and above exceptions is logged to P6WebAccess.html of Team Member.

Changes

 

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