Error: "Unable To Load Data. Unknown Error, Please Contact Your System Administrator" When Selecting My Preferences in P6 Web (Doc ID 2505869.1)

Last updated on MARCH 22, 2022

Applies to:

Symptoms

When attempting to select My Preference in P6 Web, the following error occurs:

ERROR

Error in P6 Web application:

Error
Unable to load data
Unknown error, please contact your System Administrator

The following is noted in the P6.log file:

com.primavera.bo.base.DBEngineException: DBEngine.executeSelect: {SELECT user_acceptance_consent.user_id UserId FROM user_acceptance_consent WHERE user_acceptance_consent.user_id=? AND user_acceptance_consent.status=?}
[25, 0]
at com.primavera.bo.base.DBEngineImpl.executeSelect(DBEngineImpl.java:1075)

...

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1632)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:256)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

STEPS

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

1. Login to P6 Web
2. Go to Administer --> My Preferences
3. Error is displayed in the application

Changes

Cause

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