Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Oracle error: fetch z66; ... variable not in select list

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

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    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?

    Resolution:
    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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Oracle error question
      • Oracle error: fetch znn ; variable not in select list **IN GENERAL**
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved