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 laterInformation 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
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
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,
- Log into a Projects responsibility
- Navigate to Other > Requests > Run
- Submit PRC: Refresh Project Summary Amounts
- 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 |