My Oracle Support Banner

Gather Schema Statistics Process Fails For PJI Schema (Doc ID 1470584.1)

Last updated on OCTOBER 29, 2018

Applies to:

Oracle Project Planning and Control - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to run Gather Schema Statistics for PJI,
the following error occurs.

ERROR
-----------------------
Error #1: ERROR: While GATHER_TABLE_STATS:
  object_name=PJI.PJI_FP_TXN_ACCUM1***ORA-12801: error signaled in parallel query server P013
ORA-01555: snapshot too old: rollback segment number 63 with name "_SYSSMU63_1698316916$" too small***



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run FNDGSCST module: Gather Schema Statistics for PJI schema

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.