• 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.

Resolution:
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