Error: "ORA-01795: MAXIMUM NUMBER of EXPRESSIONS in a LIST IS 1000" When Viewing a Portfolio in P6

(Doc ID 2346878.1)

Last updated on FEBRUARY 05, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 17.10.0.0 to 17.12.0.0 [Release 17.10 to 17.12]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 17.10.0.0 to 17.12.0.0 [Release 17.10 to 17.12]
Information in this document applies to any platform.

Symptoms

When viewing managed portfolios in P6 web the following error is observed :
"Unable to load data"

"Unknown error, please contact your System Administrator"

After selecting 'Ok' the following error is also observed:
"An error occured while processing your request. Please try again or contact administrator."


The P6WebAccess.html and p6.log file contain the following:

<Error>
<com.primavera.rest.common.exception.InternalErrorResponseExceptionMapper>
<win2012r2std> <P6> <[ACTIVE] ExecuteThread: '1' for queue:
'weblogic.kernel.Default (self-tuning)'> <> <>
<a27d7271-ab3d-417b-9c1a-a90a49b4910b-00000015> <1512514642572>
<[severity-value: 8] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] >
<BEA-000000> <DBEngine.executeSelect: {SELECT projwbs.wbs_name
Name,projwbs.wbs_id WbsId,projwbs.proj_id ProjectId,projwbs.wbs_short_name
ShortName,obs.obs_name ObsName,project.plan_start_date
ProjectPlannedStart,projwbs.proj_node_flag ProjectFlag,project.project_flag
ProjectProjectFlag,project.orig_proj_id ProjectOriginalId,projwbs.status_code
StatusCode,project.checkout_flag ProjectCheckoutFlag,project.clndr_id
ProjectCalendarId FROM obs,project,projwbs WHERE projwbs.obs_id=obs.obs_id
AND projwbs.proj_id=project.proj_id AND (project.orig_proj_id IS NULL) AND
(projwbs.status_code <> 'WS_Template') AND (projwbs.status_code <>
'WS_Requested') AND projwbs.wbs_id IN
(31333,31334,31335, ...
)}
null
com.primavera.bo.base.DBEngineException: DBEngine.executeSelect: {SELECT
projwbs.wbs_name Name,projwbs.wbs_id WbsId,projwbs.proj_id
ProjectId,projwbs.wbs_short_name ShortName,obs.obs_name
ObsName,project.plan_start_date ProjectPlannedStart,projwbs.proj_node_flag
ProjectFlag,project.project_flag ProjectProjectFlag,project.orig_proj_id
ProjectOriginalId,projwbs.status_code StatusCode,project.checkout_flag
ProjectCheckoutFlag,project.clndr_id ProjectCalendarId FROM
obs,project,projwbs WHERE projwbs.obs_id=obs.obs_id AND
projwbs.proj_id=project.proj_id AND (project.orig_proj_id IS NULL) AND
(projwbs.status_code <> 'WS_Template') AND (projwbs.status_code <>
'WS_Requested') AND projwbs.wbs_id IN
(31333,31334,31335...
)}
null
at com.primavera.bo.base.DBEngineImpl.executeSelect(DBEngineImpl.java:1080)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
Caused By: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of
expressions in a list is 1000


STEPS to Duplicate
-----------------------
The issue can be reproduced at will with the following steps:

  1. Login to P6 Web
  2. Select drop-down next to Portfolio tab and select 'Managed Portfolios"
  3. Observe errors.

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