My Oracle Support Banner

"Unable to load data - Unknown error, please contact your System Administrator." When Accessing Standard View Projects/EPS (Doc ID 2235389.1)

Last updated on JUNE 07, 2021

Applies to:

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

Symptoms

Some users are experiencing an error message when attempting to access the EPS sub-tab under the Projects tab using the Standard (non-Java) view. The Error popup message reads "Unable to load data - Unknown error, please contact your System Administrator

ERROR
-----------------------
Unable to load data - Unknown error, please contact your System Administrator.

In P6Webaccess.html, below error messages can be found:

com.primavera.PhoenixException: Error opening projects
at com.primavera.pvweb.pm.ProjectStartPageAction.a(Unknown Source)
at com.primavera.pvweb.pm.ProjectStartPageAction.a(Unknown Source)
at com.primavera.pvweb.pm.ProjectStartPageAction.executeGet(Unknown Source)

Caused by: com.primavera.PhoenixException: Failed to open projectsORA-00001: unique constraint (ADMUSER.PK_PROJSHAR) violated
at com.primavera.bo.remotable.SpecialQueryHelper.openProjects(Unknown Source)
at com.primavera.bo.remotable.SpecialQueryHelper.openProjectsAsReadOnly(Unknown Source)
at com.primavera.bo.remotable.qproxy.SpecialQueryHelper.openProjectsAsReadOnly(Unknown Source)
... 41 more

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

  1. Log in P6 Web -> EPS > Project
  2. Select a Global View <viewname> and move it to User Level View
  3. Log in as a user who was accessing Global View <viewname>

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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