• 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