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

    Oracle error: fetch z66; ... variable not in select list

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

    The version 18 usr00 z66 is not in the (new) correct format:

    dlib usr00
    util f/4

    enter file name (or q to exit) z66
    new key = K, exit = Q, continue = RETURN

    Oracle error: fetch z66
    ORA-01007: variable not in select list

    Also, why is the pc_server looking at usr00 when it is not our $pw_library or $usr_library?

    To correct this, you need to load a correct a version-20-format usr00 z66 file.

    If there is a usr00.exportSEQ.tar.gz file in the usr00 $data_files, then try loading it using either util a/20 or the imp_current_library proc.

    If there is no such file, then Ex Libris Support will need to get a z66.seqaa file, place it in the usr00 $data_files, and then run p_file_04, specifying "replace", to load it.

    When a GUI user logs in, the program looks for the usr00 z66 in addition to the actual $pw_library z66. (In the case where the library being accessed is a USMnn library, the program is hard-coded to use the usr00 z66. When the library being accessed is one of your own libraries, the $pw_library entries are used -- but the program still looks for the usr00 z66. )

    If the other USMnn data also has this fetch error, then you may need to do oracle_imp_demo_libraries. See Article Number 000009497 for info on running oracle_imp_demo_libraries.

    Additional Information

    usr00, z66, faq

    • Article last edited: 6/4/2014