Error: "Failed to load data. Please try again, if the problem persists contact your administrator" And "com.primavera.bo.remoting.RemoteDataException: Unable to load data for activities, Caused By SQL STATEMENT" When Loading The Activities Page (Doc ID 1536987.1)

Last updated on MAY 08, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.2.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Aug-2014***

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" 

 

Webaccess.log errors with corresponding timestamp:

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]

NOTE: the exact query can differ from the above example

 

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