P6 Professional Produces Application Event or STREAM READ Error When Opening Store Period Performance (Doc ID 2568294.1)

Last updated on OCTOBER 19, 2023

Applies to:

Symptoms

P6 crashes when attempting to open "Store Period Performance" under TOOLS menu

ERRORS:

1.  "Application Event, code:  VTRAG-0408-2  or  SRE-2835-B
2.  "Stream Read Error"
3.  "communication with the server error"

The following errors appear multiple times in the p6cloudconnect.log:
ORA-1795: maximum number of expressions in a list is 1000

STEPS TO REPRODUCE:
 1. Log in to P6 professional.
 2. Open project.
 3. Go under Tools, Store Period Performance.
 4. Observe crash with reported error.

ADDITIONAL INFO:
The number of resources that are subject to the Change Control are in excess of 6,000 , more than 1000 projects are open
Issue appears to be a query with no Bind variables used, just a very long Proj_id list:

Example:  
Select proj_id from projects where proj_id in (select distinct pred_proj_id from taskpred where pred_proj_id not in (<list of ids>)

ERROR:
java.sql.SQLSyntaxErrorException: ORA-1795: maximum number of expressions in a list is 1000

EXPECTED OUTCOME:
Users can open Store Period Performance under TOOLS menu when > 1000 projects opened 

POTENTIAL WORKAROUNDS:
Open less than 1000 projects when storing period performance

Cause

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