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