"Unable to load data" When Attempting to View Resource Analysis Page in P6Web (Doc ID 2294481.1)

Last updated on AUGUST 18, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.0.0 to 16.2.7.0 [Release 16.2]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 16.2.0.0 to 16.2.7.0 [Release 16.2]
Information in this document applies to any platform.

Symptoms

When attempting to view resource analysis page via P6Web, the following error occurs:

ERROR

Unable to load data

The following error is found in the WebLogic log:

#### <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> com.primavera.bo.base.DBEngineException: DBEngine.executeSelect: {select rsrcroleasgnmentspread.rsrc_id, rsrcroleasgnmentspread.overalloc_date from rsrcroleasgnmentspread where rsrcroleasgnmentspread.proj_id is null and rsrcroleasgnmentspread.rsrc_id is not null and rsrcroleasgnmentspread.rsrc_id in (SELECT rsrc.rsrc_id FROM rsrc,rsrfolio WHERE rsrc.rsrc_id=rsrfolio.rsrc_id AND rsrfolio.rfolio_id = ? )}[214]

Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: "RSRCROLEASGNMENTSPREAD"."OVERALLOC_DATE": invalid identifier

STEPS

The issue can be reproduced at will with the following steps:
1. Open P6 EPPM web.
2. Select Resources Tab.
3. Select Analysis.
4. Observe "Unable to load data" error.

BUSINESS IMPACT

The issue has the following business impact:
Due to this issue, users cannot view resource analysis page.

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