When Accessing EPS or Projects Tab in P6 Web, Error: "Failed to load data, please try again later, if the problem persists, contact your system administrator."

(Doc ID 2318449.1)

Last updated on NOVEMBER 14, 2017

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.

ERROR

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

P6WebAccess.html says:

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
  at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
  at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
  at com.primavera.bo.base.DBEngineImpl.executeSelect(Unknown Source)
  at com.primavera.bo.remotable.SpecialQueryHelper.a(Unknown Source)
  at com.primavera.bo.remotable.SpecialQueryHelper.findResourceOrRoleValue(Unknown Source)
  at com.primavera.bo.remotable.qproxy.SpecialQueryHelper.findResourceOrRoleValue(Unknown Source)
  at com.primavera.guisupport.resources.ResourcesDeepFindDataLoader.a(Unknown Source)
  at com.primavera.guisupport.resources.ResourcesDeepFindDataLoader.a(Unknown Source)
  at com.primavera.guisupport.dictionaries.DictionaryDeepFindDataLoader.load(Unknown Source)
  at com.primavera.bo.remotable.RemoteRequest.loadData(Unknown Source)
  at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:597)
  at com.primavera.infr.q.AbstractQProxyObject.performAction(Unknown Source)
  at com.primavera.infr.q.AbstractQProxyObject.execute(Unknown Source)
  at com.primavera.oriweb.preshelpers.BusinessObjectServletServices.executeProxyObject(Unknown Source)
  at com.primavera.pvweb.servlet.BusinessObjectServlet.service(Unknown Source)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
  at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
  at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
  at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
  at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
  at com.primavera.pvweb.XSSFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
  at com.primavera.pvweb.FrontFilter.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
  at com.primavera.pvweb.filters.ApplicationContextInjector.doFilter(Unknown Source)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
  at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
  at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
  at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
  Original Exception:
  com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ')'.

STEPS

The issue can be reproduced at will with the following steps:
1. Log in to P6 Web
2. See error
3. View logs, see additional error text

BUSINESS IMPACT

The issue has the following business impact:
Due to this issue, users cannot open Projects tab.

Changes

 

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