• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
I'm trying to better sort out what Oracle tables are and are not needed. I see the following in the pc_server logs:

DESCRIPTION: Retrieve/Create HOL Record of a Specific Item
ACTION :
PROGRAM : pc_item_c0910
...
...
Oracle error: update_cursor1 z11
ORA-00942: table or view does not exist
...
Oracle error: update_cursor z13
ORA-00942: table or view does not exist
...
Oracle error: io_z13_write
ORA-00942: table or view does not exist
...
...
Oracle error: update_cursor z50
ORA-00942: table or view does not exist

Oracle error: io_z50_write
ORA-00942: table or view does not exist

Why is Aleph looking for tables z11, z13, and z50 for the holdings library ABC60? These should not be necessary for this library, should they? Can we eliminate these error messages by changing Aleph tables?

Resolution:
Consulting KB 8192-2329, we see that these are tables which are updated immediately (by update_docx) when a doc record (bib, adm, hol, authority, or Course Reseve record) is saved to the server. So even if you don't run ue_01 in the library, update_docx will still be wanting to update these tables.

The only choices are (1) to ignore these errors or (2) add these tables to the file_list.

• Article last edited: 10/8/2013