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

    xxx30: "Error: library does not exist"; z103 "Invalid table name"

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

    In running p_manage_07 for a Course Reserve library you get:
    Error: library does not exist

    And in running p_manage_12 you get:
    Oracle error: update_cursor1 z103 ORA-00903: invalid table name

    The p_manage_07 is reading the SID field in order to build the SID direct index. The p_manage_12 is reading the SID field in order to build the z103 ITM links.
    These errors indicate that the programs have encountered a record which doesn't have the library in the expected position in the SID field. The SID should have a "dollar-dollar-a" (a-subfield code) and then the library. In this case the record's SID field lacked the a-subfield code.

    KEYWORDS: manage_12 p-manage-12 p-manage-107 manage_107

    Additional Information

    p_manage_107, Course Reserve, error, SID, direct index

    • Article last edited: 10/8/2013