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

• 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.