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

Last updated on FEBRUARY 23, 2017

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

Unable to load data message in Standard View Projects/EPS

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, we can see below error message

ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR /action/pm/projectstartpage (User Id: 149 DB Id: 1) com.primavera.pvweb.BaseAction ?:? exception processing action
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. Login P6 Web -> EPS > Project
2. Select a Global View 'AAA' and move it to User Level View
3. Login as a user who were accessing 'AAA'


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see project list

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