Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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