P6 Professional Produces Application Event or STREAM READ Error When Opening Store Period Performance
(Doc ID 2568294.1)
Last updated on JUNE 07, 2021
Applies to:Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 18.8 and later
Information in this document applies to any platform.
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
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