My Oracle Support Banner

Error 'Unable to load data' When Attempting to Load the View Service Status Page (Doc ID 2690222.1)

Last updated on JULY 23, 2020

Applies to:

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

Symptoms

When attempting to access the View Service Status window, one or both of the following errors occur.

Unable to load data.
An unknown error has occurred.

OR

An error occurred while processing your request. Please try again or contact administrator.

The following error can also be found in the 'Publish Resource Role Assignment Spread' job log:

Errors occurred when executing following statement: DECLARE V_PROJECT_ID number; BEGIN V_PROJ_ID := :proj_id;
Delete RSRCROLEASSIGNMENTSPREAD where rsrc_id in( select rsrc_id from RSRCROLEASSIGNMENTSPREAD where rsrc_id is not NULL and
proj_id=V_PROJ_ID) and proj_id is NULL and rolledup_record ='Y'; Delete RSRCROLEASSIGNMENTSPREAD where role_id in( select role_id
from RSRCROLEASSIGNMENTSPREAD where role_is is not NULL andproj_id=V_PROJ_ID) and proj_id is NULL and rolledup_record = 'Y';
Delete RSRCROLEASSIGNMENTSPREAD where proj_id=V_PROJ_ID; COMMIT; END;
ORA-00060: deadlock detected while waiting for resource ...

 

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

  1. Sign in to P6 Web.
  2. Select the user's name drop-down menu > View Service Status.
  3. View the reported errors.

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.