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

    www_server log: "update_cursor z63 ... table or view does not exist"

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Problem Symptoms:
    $LOGDIR/www_server log has a single occurrence of the following errors in the middle of the night:

    Oracle error: update_cursor z63
    ORA-00942: table or view does not exist

    Oracle error: io_z63_write
    ORA-00942: table or view does not exist

    WRITE ERROR 377VH68FFTFHN115J9FJC95NSCD7SUSGQLIUUINUQC1GJJ7NPU

    Cause:
    The www_server was up while clear_vir01 was running: user attempted to search OPAC after clear_vir01 had dropped the z63 (OPAC session table).

    Resolution:
    1. dlib vir01
    2. util a/17/14 for z63

    If the util shows that the z63 (Web session) exists and its Oracle indexes exist and are valid, then this was a temporary situation and can be ignored.

    Additional Information

    If the user accesses the z63 immediately *preceding* the drop/create of the z63, then the clear_vir01 log will include a "Resource busy" error and users will have the problems described in Articles 000036760 { Can't log into Web, "unique constraint (VIR01.Z63_ID) violated" *MASTER RECORD*} or 000041595 ( Searches redisplays Initial OPAC screen; no results ).

    To prevent such problems, entries can be added to the job_list to
    * stop the www_server (and pc_server) prior to the clear_vir01 job_list entry and to
    * restart them afterwards.
    See Article 000044208 ( Restart Servers from job_list ) in this regard.
     

    Category: Web OPAC

    • Article last edited: 12/5/2013