Oracle log: ORA-01555 ... SELECT * FROM RELATIONAL("XXX00"."Z00P")
- Article Type: General
- Product: Aleph
- Product Version: 20
Problem Symptoms:
The following message appears somewhat frequently in the Oracle log.
on Mar 04 04:13:22 2013
ORA-01555 caused by SQL statement below (SQL ID: 0gd097au4mh4k, Query Duration=1
362388401 sec, SCN: 0x0000.0ec22336):
SELECT * FROM RELATIONAL("XXX00"."Z00P")
Most of the messages occur early in the morning.
Cause:
Uncertain.
Resolution:
The z00p table is updated by ue_21. The ./xxx01scratch/run_e_21 log contains the following entries just before and just after 4:13 AM:
HANDLING DOC NO. - VCC01.001869793 2013-03-04 04:12:55
HANDLING DOC NO. - VCC01.001869794 2013-03-04 04:14:25
but nothing at 04:13 exactly. And there is no indication of any error.
The site will monitor the z00p for indications of problems.
Category: System Management (500)
Subject: Oracle (500)
- Article last edited: 10/8/2013