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

    Oracle Error found in pc-server log, update_cursor2 z00t

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

    Description:
    The following error was found in the pc_server log. What is the z00t table that is trying to be updated here? According to the staff user below, at the time of the error she was searching for and deleting c-fly items in the system. She did not get any GUI errors during the process though.

    SERVICE : C0227
    MODULE : Catalog Services
    DESCRIPTION: No Description Available
    ACTION :
    PROGRAM : pc_cat_c0227

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

    Resolution:
    If you want to use the Document Tracking function (new with v20), then you need to do util a/17/2 to build the Oracle indexes for the xxx01 z00t table.

    If you don't want to use the Document Tracking function, then you should remove the "fix_doc_track" line from xxx01 tab_fix: the programs will then no longer be looking for the z00t.

    The z00t functionality is described in KB 16384-42497.


    • Article last edited: 10/8/2013