Activities Page Within P6 Web Does Not Load Data (Doc ID 1620786.1)

Last updated on JANUARY 26, 2016

Applies to:

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

Symptoms

In P6 Web, the Activities page fails to load the data, and the following error is observed in the P6webacces.html file.

com.primavera.bo.remoting.RemoteDataException: Unable to load data for activities
     at com.primavera.guisupport.activities.data.ActivitiesDataLoader.load(Unknown Source)
     at com.primavera.bo.remotable.RemoteRequest.loadData(Unknown Source)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     at java.lang.reflect.Method.invoke(Method.java:597)
     at com.primavera.infr.q.AbstractQProxyObject.performAction(Unknown Source)
     at com.primavera.infr.q.AbstractQProxyObject.execute(Unknown Source)
     at com.primavera.oriweb.preshelpers.BusinessObjectServletServices.executeProxyObject(Unknown Source)
     at com.primavera.pvweb.servlet.BusinessObjectServlet.service(Unknown Source)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:821)
     at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
     at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
     at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
     at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:27)
     at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
     at com.primavera.pvweb.XSSFilter.doFilter(Unknown Source)
     at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
     at com.primavera.pvweb.FrontFilter.doFilter(Unknown Source)
     at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
     at com.primavera.pvweb.filters.ApplicationContextInjector.doFilter(Unknown Source)
     at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
     at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
     at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
     at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
     at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
     at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
     at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
     at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
     at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
     at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
     at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
     at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
    Caused by: com.primavera.bo.common.QueryTimeoutException: Timeout error waiting for data. Please try again later: 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.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_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.rsrc_id PrimaryResourceId,rsrc.rsrc_name PrimaryResourceName,task.free_float_hr_cnt FreeFloat,project.proj_short_name ProjectIdName,task.cstr_type ConstraintType,task.cstr_type2 ConstraintType2,task.external_early_start_date ExternalEarlyStartDate,projwbs.obs_id ObsId,obs.obs_name ResponsibleManager,task.reend_date RemainingFinish,task.duration_type DurationType,alias_projwbs.wbs_name ProjectName,task.task_code ActivityCode,task.external_late_end_date ExternalLateFinishDate,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.target_start_date PlannedStart,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 = ?) order by task.task_id asc



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