My Oracle Support Banner

Error 'Failed to load data' and 'Unable to load data for activities' When Loading the Activities Page (Doc ID 1536987.1)

Last updated on FEBRUARY 28, 2019

Applies to:

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

Symptoms

When attempting to load the 'Activities' page in P6 Web, the following error occurs:

Error: "Failed to load data. Please try again, if the problem persists contact your administrator"

The following errors can also be found in the P6WebAccess.html log file:

WARN - com.primavera.infr.db.DBCloserUtils - SQL Exception attempting to close a Connection
com.primavera.infr.db.ConnectionRecycledException: Connection has been recycled. Database PMDB Pool PMR

ERROR - com.primavera.bo.remotable.RemoteRequest - Failed loading data for web pm com.primavera.guisupport.activities.data.ActivitiesDataLoader
com.primavera.bo.remoting.RemoteDataException: Unable to load data for activities

 Caused by: com.primavera.PhoenixException: DBEngine.executeSelect:  {SELECT TOP 5001 task.task_id ActivityId,task.remain_drtn_hr_cnt RemainingDuration,task.complete_pct_type PercentCompleteType,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_end_date PlannedFinish,task.act_start_date ActualStart,task.act_end_date ActualFinish,project.plan_start_date ProjectPlannedStart,project.last_recalc_date ProjectRemainingStart,task.restart_date RemainingStart,task.clndr_id CalendarId,task.suspend_date SuspendDate,task.resume_date ResumeDate,task.cstr_type ConstraintType,task.cstr_type2 ConstraintType2,task.external_early_start_date ExternalEarlyStartDate,task.target_start_date PlannedStart,project.sum_base_proj_id ProjectSummaryBLProjectId,task.reend_date RemainingFinish,task.external_late_end_date ExternalLateFinishDate,task.target_work_qty PlannedLaborUnits,project.def_cost_per_qty DefaultPricePerTime,task.remain_work_qty RemainingLaborUnits,task.remain_equip_qty RemainingNonLaborUnits,task.target_equip_qty PlannedNonLaborUnits,task.act_work_qty + task.remain_work_qty AtCompletionLaborUnits,task.act_work_qty ActualLaborUnits,task.act_equip_qty + task.remain_equip_qty AtCompletionNonLaborUnits,task.act_equip_qty ActualNonLaborUnits,project.use_project_baseline_flag UseProjectBaselineForEV,task.rsrc_id PrimaryResourceId,task.free_float_hr_cnt FreeFloat,rsrc.rsrc_name PrimaryResourceName,project.proj_short_name ProjectIdName,projwbs.obs_id ObsId,obs.obs_name ResponsibleManager,task.duration_type DurationType,alias_projwbs.wbs_name ProjectName,task.task_code ActivityCode,CASE (select distinct 'Y' from task internal_alias_task where internal_alias_task.task_type <> 'TT_LOE' and internal_alias_task.status_code <> 'TK_Complete' and ((project.critical_path_type = 'CT_DrivPath' and internal_alias_task.driving_path_flag = 'Y') or (project.critical_path_type <> 'CT_DrivPath' and internal_alias_task.total_float_hr_cnt <= project.critical_drtn_hr_cnt)) and internal_alias_task.task_id = task.task_id) WHEN 'Y' THEN 'Y' ELSE 'N' END Critical,calendar.clndr_name CalendarName,task.wbs_id WbsId,task.early_start_date EarlyStart,projwbs.wbs_name WbsName,CASE (select isnull(max(internal_alias_taskproc.task_id),0) from taskproc internal_alias_taskproc where internal_alias_taskproc.task_id=task.task_id) WHEN 0 THEN 'N' ELSE 'Y' END HasSteps,task.task_name ActivityName,rsrc.rsrc_short_name PrimaryResourceShortName,project.clndr_id ProjectCalendarId FROM projwbs alias_projwbs,calendar,obs,project,projwbs,task LEFT OUTER JOIN rsrc ON task.rsrc_id=rsrc.rsrc_id WHERE task.clndr_id=calendar.clndr_id AND (task.wbs_id=projwbs.wbs_id AND task.proj_id=projwbs.proj_id) AND projwbs.obs_id=obs.obs_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.proj_id IN (select proj_id from projshar where session_id = ?)}
    [16772]

The specific query can differ from the above example.

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.