Report terminates with Oracle error "ora-01555 snapshot too old" after a long runtime. The report uses logical database BRF.
Cause and prerequisitesExtensive evaluations of the document database and database updates occur at the same time. The documents are read sequentially (a SELECT database access) in logical database BRF. Because of the parallel updates (different programs) the data to be read is rolled out to a rollback segment.
Due to the long runtime, this data in the rollback segment is out of date before the data is completely imported by the ABAP/4.
Change the sequential access to "document by document".
Both access modes are realized in logical database BRF.
You only have to set parameter "BR_SEQ" of the logical database to SPACE (when you start the report).
Special case: RFGAUF00
This report sets parameter BR_SEQ in the program directly to 'X'.
Here you have to implement the correction specified below.
Additional key words
SAPDBBRF, RFGAUF00
No comments:
Post a Comment