Error "ORA-01555: snapshot too old: rollback segment number with name "" too small" When Running the Publish Auditing Data Job and Data Is Not Being Deleted From the PAUDIT Table
(Doc ID 2891812.1)
Last updated on JANUARY 30, 2024
Applies to:
Primavera P6 Enterprise Project Portfolio Management - Version 19.12.2.0 to 19.12.13.0 [Release 19.12]Primavera P6 Enterprise Project Portfolio Management - Version 20.12 to 20.12.3.0 [Release 20.12]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 20.1 to 22.3 [Release 20.1 to 22.3]
Information in this document applies to any platform.
Symptoms
The Publish Audit Data Global Scheduled Service job fails with the following error.
[PxService]: BEGIN: Px Service Job
[PxService]: Job Name: Publish Audit Data
[PxService]: Job Type: Publish Audit Data (JT_AuditData)
[PxService]: Job Start Time: <date/time>
[PxService]: Initializing px service job...
[PxService]: Px service (PRE) task count: 0
[PxService]: Px service (CORE) task count: 1
[PxService]: Px service (POST) task count: 0
[PxService]: Creating Px service task(s)...
[TASK]:[PxAuditServiceTaskImpl]: [1] CORE(BRE): Executing: px_audit_demand...
SEVERE: <date/time>:[TASK]:[PxAuditServiceTaskImpl]: [1] CORE(BRE): ORA-01555: snapshot too old: rollback segment number with name "" too small
A query of the PAUDIT table indicates that more records are present than the KeepInterval parameter for the Publish Audit Data job is set to (in the SETTINGS table), and :
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! |