Description

Running 'Create Tar File for ALEPH Published Records (publish-06)' the following error appears:
Oracle error: update_cursor z100
ORA-00942: table or view does not exist

Error reading Z100 in usr_library
Z100-REC-KEY:
Wrote Z100 record with rec-key: no_such_symbol

Resolution: 

Table z100 must also be defined for the $usr_library in Aleph 19 (and up)

Definition of z100 for the $usr_library can be done in one of 2 ways:
1) adding it to the $usr_library $data_root/file_list or
2) setting the $usr_library $data_root/prof_library file_list_type so that it will be included from the $aleph_root/tab/file_list.USR template.

Then do dlib $usr_library and run util a/17/1 for z100 to actually create it.

Also, when the USR and the ADM library are the same, in the XXX50/prof_library file parameter, "file_list_type", should be ADM:

setenv file_list_type ADM

In addition to this setting, the variable usr_library in $alephe_root/aleph_start.private should also be ADM.

setenv usr_library <xxx50 ADM library>

(such as "USM50")

Additional Information

See also Knowledge Base item clear_vir01 error after v19 Upgrade Express: &quot;Error reading Z100 in usr_library&quot; for a case where the error was occurring in clear_vir01.

Category: Background processing

• Article last edited: 21/March/2016