My Oracle Support Banner

Error 'Failed to load data, please try again later' When Accessing the EPS or Projects Tab in P6 Web (Doc ID 2318449.1)

Last updated on JANUARY 22, 2020

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.2 1.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to access the EPS or Projects tab, the following error occurs.

Failed to load data, please try again later, if the problem persists, contact your system administrator.

The following error is also seen in the P6WebAccess.html log file:

ERROR com.primavera.bo.remotable.SpecialQueryHelper ?:? Failed executing query; WITH RORVALIDLIST(parent_rsrc_id) AS (SELECT parent_rsrc_id FROM rsrc WHERE () UNION ALL SELECT R.parent_rsrc_id FROM rsrc R JOIN RORVALIDLIST RL ON R.rsrc_id = RL.parent_rsrc_id) SELECT parent_rsrc_id FROM rsrc WHERE rsrc.parent_rsrc_id IN (SELECT parent_rsrc_id FROM RORVALIDLIST) with params null
com.primavera.PhoenixException: DBEngine.executeSelect: { WITH RORVALIDLIST(parent_rsrc_id) AS (SELECT parent_rsrc_id FROM rsrc WHERE () UNION ALL SELECT R.parent_rsrc_id FROM rsrc R JOIN RORVALIDLIST RL ON R.rsrc_id = RL.parent_rsrc_id) SELECT parent_rsrc_id FROM rsrc WHERE rsrc.parent_rsrc_id IN (SELECT parent_rsrc_id FROM RORVALIDLIST)}
  null
...
  Original Exception:
  com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'.

 

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

  1. In P6 Web, navigate to the EPS or Projects view.
  2. Observe the reported errors.

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.