My Oracle Support Banner

PAXACRPT: PRC: Refresh Project Summary Amounts Is Failing With 'Error: ORA-01555: Snapshot Too Old: rollback segment number with name "" too small' (Doc ID 2995209.1)

Last updated on DECEMBER 28, 2023

Applies to:

Oracle Project Foundation - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

PRC: Refresh Project Summary Amounts is completing in error with the following error message;

MSG-00001: ORA-01555: snapshot too old: rollback segment number with name "" too small
MSG-00001: Exception was generated by Accumulation API
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-1419: MSG-00001: Calling Refresh Project Accumulation
MSG-00001: Concurrent request id is 193176635
MSG-00001: ORA-01555: snapshot too old: rollback segment number with name "" too small
MSG-00001: Exception was generated by Accumulation API

The user is unable to determine the rollback segment as it is not provided in the log.

PRC: Update Project Amounts completes normally without error.

The database Alert log has the following error messages;

Fatal NI connect error 12170.

 VERSION INFORMATION:
TNS for Linux: Version 19.0.0.0.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 19.0.0.0.0 - Production
 Version 19.10.0.0.0
 Time: 03-AUG-2021 01:32:31
 Tracing not turned on.
 Tns error struct:
   ns main err code: 12535
   
TNS-12535: TNS:operation timed out
   ns secondary err code: 12560
   nt main err code: 505
   
TNS-00505: Operation timed out
   nt secondary err code: 110
   nt OS err code: 0
...
Fatal NI connect error 12637, connecting to:
(ADDRESS=(PROTOCOL=tcp)(HOST=10.72.212.90)(PORT=51936))
...
TNS-12637: Packet receive failed
...
2023-08-18T23:51:31.736266-04:00
opiodr aborting process unknown ospid (10678) as a result of ORA-609

To reproduce the issue,

  1. Log into a Projects responsibility
  2. Navigate to Other > Requests > Run
  3. Submit PRC: Refresh Project Summary Amounts
  4. See snapshot too old error in log file with no rollback segment provided.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.