PRC: Launch Update Project Performance Data - Index [sub]partitions Of Table PJI.PJI_PA_PROJ_EVENTS_LOG and PJI.PJI_FM_EXTR_PLNVER4 Marked Unusable
(Doc ID 2862819.1)
Last updated on APRIL 13, 2022
Applies to:
Oracle Project Planning and Control - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.9 version, Project Performance Reporting
When running Project Summarizations (PJI_FM_SUMMARIZE_INCR: PRC: Update Project and Resource Base Summaries) with >1 workers, frequently encounter concurrent request failures with the following syntax:
ORA-30926: unable to get a stable set of rows in the source tables
Database alert log shows following errors
ERROR
-----------------------
Some indexes or index [sub]partitions of table PJI.PJI_FM_EXTR_PLNVER4 have been marked unusable
Mon Dec 06 19:38:09 2021
Some indexes or index [sub]partitions of table PJI.PJI_PA_PROJ_EVENTS_LOG have been marked unusable
Changes
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 |
Changes |
Cause |
Solution |
References |