Oracle error: update_cursor z104
- Article Type: General
- Product: Aleph
- Product Version: 20
Problem Symptoms:
* PC server log contains the following error message:
Oracle error: update_cursor z104
ORA-00942: table or view does not exist
Cause:
* table z104 does not exist in HOL library
* $data_root/file_list only contains reference to index IND z104_id2, but not to TAB z104
IND z104_id2 128K 0K TS1X
* Index z104_id2 was added by step 1006 of upgrade express 19-20 to ./xxx60/file_list, but the table z104 (Trigger for Memos) library is not present for HOL type libraries by default
Resolution:
* table z104 is by default only present in the following library types:
- ADM
- AUT
- BIB
- COURSE
- ILL und ILLSV
If you want to add table z104 to HOL type library, add the following lines to ./xxx60/file_list
TAB z104 100K 0K ts0
IND z104_id 100K 0K ts1
IND z104_id1 100K 0K ts1
IND z104_id2 100K 0K ts1
Note: the size 100K and the tablespace should be adapted to the relevant size of your library.
* Run util a/17/1 to create the table
Additional Information
* With the help of util a/17/10/2 "view merged file_list" you can see which files are defined for your library
* the system takes the definitions in the following order:
** definitions of ./xxxnn/file_list
** default definitions of $aleph_root/tab/file_list.XXX
file_list.ADM
file_list.AUT
file_list.BIB
file_list.COURSE
file_list.HOL
file_list.ILL
file_list.ILLSV
file_list.PW
file_list.USR
file_list.VIR
file_list.Z105
* The relevant template file and size are determined by parameters file_list_type and file_list_size in $data_root/prof_library:
setenv file_list_type HOL
setenv file_list_size MEDIUM
See also KCS article "Recommended settings for parameter file_list_size in $data_root/prof_library"
Category: GUI ILL (500)
- Article last edited: 10/8/2013