www_server log: "update_cursor z63 ... table or view does not exist"
- Article Type: General
- Product: Aleph
- Product Version: 20
Problem Symptoms:
$LOGDIR/www_server log has a single occurrence of the following errors in the middle of the night:
Oracle error: update_cursor z63
ORA-00942: table or view does not exist
Oracle error: io_z63_write
ORA-00942: table or view does not exist
WRITE ERROR 377VH68FFTFHN115J9FJC95NSCD7SUSGQLIUUINUQC1GJJ7NPU
Cause:
The www_server was up while clear_vir01 was running: user attempted to search OPAC after clear_vir01 had dropped the z63 (OPAC session table).
Resolution:
1. dlib vir01
2. util a/17/14 for z63
If the util shows that the z63 (Web session) exists and its Oracle indexes exist and are valid, then this was a temporary situation and can be ignored.
Additional Information
If the user accesses the z63 immediately *preceding* the drop/create of the z63, then the clear_vir01 log will include a "Resource busy" error and users will have the problems described in Articles 000036760 { Can't log into Web, "unique constraint (VIR01.Z63_ID) violated" *MASTER RECORD*} or 000041595 ( Searches redisplays Initial OPAC screen; no results ).
To prevent such problems, entries can be added to the job_list to
* stop the www_server (and pc_server) prior to the clear_vir01 job_list entry and to
* restart them afterwards.
See Article 000044208 ( Restart Servers from job_list ) in this regard.
Category: Web OPAC
- Article last edited: 12/5/2013