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

    Holdings library - Oracle errors for z11, z13, z50

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

    Description:
    I'm trying to better sort out what Oracle tables are and are not needed. I see the following in the pc_server logs:

    DESCRIPTION: Retrieve/Create HOL Record of a Specific Item
    ACTION :
    PROGRAM : pc_item_c0910
    ...
    ...
    Oracle error: update_cursor1 z11
    ORA-00942: table or view does not exist
    ...
    Oracle error: update_cursor z13
    ORA-00942: table or view does not exist
    ...
    Oracle error: io_z13_write
    ORA-00942: table or view does not exist
    ...
    ...
    Oracle error: update_cursor z50
    ORA-00942: table or view does not exist

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

    Why is Aleph looking for tables z11, z13, and z50 for the holdings library ABC60? These should not be necessary for this library, should they? Can we eliminate these error messages by changing Aleph tables?

    Resolution:
    Consulting KB 8192-2329, we see that these are tables which are updated immediately (by update_docx) when a doc record (bib, adm, hol, authority, or Course Reseve record) is saved to the server. So even if you don't run ue_01 in the library, update_docx will still be wanting to update these tables.

    The only choices are (1) to ignore these errors or (2) add these tables to the file_list.

    • Article last edited: 10/8/2013