2.10.11

SAP Note 28229 - Report terminates with Oracle error ora-01555

Symptom:

Report terminates with Oracle error "ora-01555 snapshot too old" after a long runtime. The report uses logical database BRF.

Cause and prerequisites

Extensive 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.

Solution
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