p_union_02: ORA-01555: snapshot too old

• Article Type: General
• Product: Aleph
• Product Version: 16.02

Description:
p_union_02 stops with the following error:

Oracle error: fetch z120
ORA-01555: snapshot too old: rollback segment number 6 with name "_SYS
21864 END READING AT 00:23:18

Resolution:
Correct the "snapshot too old" problem as described in KB 8192-2519, then re-run p_union_01 and p_union_02.

Note: it might seem that one could use the "From Document Number" parameter to skip records which have already been processed, but p_union_02 does not process the records strictly sequentially and the following SQL shows that, in fact, record 350150 has not been processed:

odn01@ALEPH0> select min (z120_rec_key) from z120 where z120_update_flag = 'N';
**** Hit return to continue ****

MIN(Z120_
---------
000350150

This record is less than 10% of the way into the database. Therefore, it is cleaner and better to just start over.