Error: io_z00 - table doesn't exist ... USR00; update_cursor1 z103
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Problem Symptoms:
In www_server_4500.log the following messages appear:
WWW-F : ITEM-GLOBAL
Error: io_z00 - table doesn't exist in database or tab_io_remote for library: USR00
Error: io_z00 - table doesn't exist in database or tab_io_remote for library: USR00
Oracle error: update_cursor1 z103
ORA-00942: table or view does not exist
Oracle error: update_cursor1 z103
ORA-00942: table or view does not exist
Oracle error: update_cursor1 z103
ORA-00942: table or view does not exist
Cause:
Resolution:
These messages are occurring in connection with the Holdings Detail / Item display. USR00 is the Aleph Demo usr_library. Checking the xxx50 Z103, I don't find any (incorrect) links to USR00.
We believe that this may be due to the
DOC-TYPE-ADM=Y
in the usr00/tab/tab100. (The system thinks it's an ADM library and looks for z00, z103, etc.). In version 20, this is corrected to
DOC-TYPE-ADM=N
The xxx00/tab/tab100 should have:
DOC-TYPE-BIB=N
DOC-TYPE-HOL=N
DOC-TYPE-ADM=N
DOC-TYPE-AUT=N
DOC-TYPE-ILL=N
This change should be made in the usr00 tab100 for earlier versions as well.
Environment
Aleph 18
Cause
Configuration
Category: Web OPAC (500)
Subject: Web server (500)
- Article last edited: 10/8/2013