Primavera Project Takes a Long Time to Fail to Open (Doc ID 2120132.1)

Last updated on MARCH 31, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.1.0.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 15.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to open a project via P6 Web, the project ultimately fails to open, while taking a long time to fail.

In the WebAccessLogs file you can find the following error:


ERROR
-----------------------
om.primavera.bo.remoting.RemoteDataException: Could not load service details. Please contact your system administrator.
  at com.primavera.guisupport.projects.data.ProjectsDataLoader.load(Unknown Source)
  at com.primavera.bo.remotable.RemoteRequest.loadData(Unknown Source)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
....50 more
  Caused by: com.primavera.PhoenixException: Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.
  at com.primavera.bo.base.server.ServerDAOImpl.loadRollupPrmRowSet(Unknown Source)
  ... 37 more
  Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
  ... 55 more


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to P6 Web.
2. Click the Projects tab or try to open a Project.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot edit projects via P6 Web.

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