p_cir_32: z35 Oracle errors

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

Description:
I'm seeing this in the p_cir_32 job log:

Oracle error: fetch z35
ORA-01555: snapshot too old: rollback segment number 9 with name "_SYS

And the following in the Oracle alert_log:

ORA-01555 caused by SQL statement below (Query Duration=3700 sec, SCN: 0x0000.06aa2515):
select * from mbb50.z35 where z35_time_stamp >= :v1

What should be done?

Resolution:
You should kill this job and try running it at night (when fewer updates are occurring to the z35).

See also, KB 8192-2519.