Error: 'Unable to load data for resource assignments' When Attempting to Open the Project Assignment View

(Doc ID 2390524.1)

Last updated on MAY 17, 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

The Assignments view takes a very long time to load, and the following error occurs in the P6.out file:

<Error> <com.primavera.rest.common.exception.RemoteDataErrorResponseExceptionMapper> <BEA-000000> <Unable to load data for resource assignments
com.primavera.bo.remoting.RemoteDataException: Unable to load data for resource assignments
Caused By: com.primavera.bo.base.DBEngineException: DBEngine.executeSelect: {SELECT /*+ FIRST_ROWS */ * FROM (SELECT taskrsrc.taskrsrc_id AssignmentId,task.status_code ActivityStatus,task.task_name ActivityName,task.status_code ActActivityStatus,alias_projwbs.wbs_name ProjectName,rsrc.rsrc_name ResourceName,taskrsrc.task_id ActivityId,CASE WHEN task.task_type = 'TT_Rsrc' AND taskrsrc.rsrc_id IS NOT NULL THEN rsrc.clndr_id ELSE task.clndr_id END CalendarId,task.act_end_date ActActualFinish,task.restart_date ActRemainingStart,task.act_start_date ActActualStart,taskrsrc.act_start_date ActualStart,taskrsrc.restart_date RemainingStart,task.cstr_type2 ActConstraintType2,taskrsrc.act_this_per_qty ActualThisPeriodUnits,taskrsrc.act_end_date ActualFinish,task.wbs_id WbsId,task.duration_type DurationType,project.proj_short_name ProjectIdName,projwbs.wbs_name WbsName,task.reend_date ActRemainingFinish,task.task_code ActivityCode,taskrsrc.proj_id ProjectId,projwbs.wbs_short_name WbsShortName,task.task_type ActivityType,task.target_start_date ActivityPlannedStart,taskrsrc.rsrc_type ResourceType,task.cstr_type ActConstraintType,taskrsrc.reend_date RemainingFinish,taskrsrc.act_reg_qty+taskrsrc.act_ot_qty ActualUnits,taskrsrc.role_id RoleId,task.external_early_start_date ActExternalEarlyStartDate,taskrsrc.rsrc_id ResourceId,task.external_late_end_date ActExternalLateFinishDate,taskrsrc.cost_qty_link_flag SyncUnitsFromCost,task.restart_date ActivityRemainingStart,taskrsrc.cost_per_qty_source_type RateSource,rsrc.rsrc_short_name ResourceShortName FROM projwbs alias_projwbs,project,projwbs,rsrc,task,taskrsrc WHERE projwbs.wbs_id=task.wbs_id AND taskrsrc.proj_id=alias_projwbs.proj_id and alias_projwbs.proj_node_flag='Y' AND taskrsrc.proj_id=project.proj_id AND taskrsrc.rsrc_id=rsrc.rsrc_id(+) AND taskrsrc.task_id=task.task_id AND (taskrsrc.role_id IS NULL) AND ((CASE WHEN project.orig_proj_id IS NULL THEN 'N' ELSE 'Y' END = 'N' AND decode(alias_projwbs.status_code, 'WS_Template', 'Y', 'N') = 'N' AND decode(alias_projwbs.status_code, 'WS_Requested', 'Y', 'N') = 'N')) AND (())  order by taskrsrc.taskrsrc_id asc) WHERE rownum <=2001}
null
Caused By: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression>

 

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

  1. Log into P6 Web.
  2. Open a project.
  3. Select the Resources tab.
  4. Select the Assignments view.
  5. Observe reported behavior.

 

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