- Article Type: General
- Product: Aleph
- Product Version: 20
- Relevant for Installation Type: Dedicated-Direct; Direct; Local; Total Care
When you connect to the Web OPAC, you get a correct search screen, but when you do the search, instead of results, you get "The requested base/library is not accessible now" and the base-list screen.
The GUI Search also does not work. GUI Circulation is working fine.
The OPAC Browse gives you a correct list of headings, but when you click on one of the headings, it gives you the same message as above.
If you find "$local_base=usm01" in the http URL and only USM databases display when you click on "Databases", then see KB 8192-5896 instead of this KB.
(Note: If the problem occurs only with one particular base and not with others, then the problem is *not* the z05/z110 described below. That problem would apply to *all* bases, as the z05 and z110 are used by all bases.)
These symptoms indicate a problem with the Brief list / Results list: the z05. util a/17/14 showed that the z05_id was missing.
Doing util a/17/1 for the vir01 z110 and z05 fixed the problem.
Since the z05 is reinitialized by clear_vir01, the clear_vir01 log from the previous night was checked and found the following error was found:
22:35:05 SQL-ALEPH_ADMIN> CREATE UNIQUE INDEX VIR01.Z05_ID ON VIR01.Z05 (Z05_REC_KEY ASC)
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
This clear_vir01 error is exactly like KB 8192-9608, but the odd thing is that the symptom ("The requested base/library is not accessible now.") is completely different!
This means that someone/something was trying to do a search when clear_vir01 was running.
KB 8192-9608 describes different means of preventing this problem. See KB 8192-9608 for further info.
Category: Web OPAC
- Article last edited: 10/8/2013