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:
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 18.8 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |