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.
Additional Information
usr00, z66, faq
- Article last edited: 6/4/2014