Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    *Master record for search problems resulting from clear_vir01 problems*

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

    Description:
    This is a master record for search problems resulting from problems with clear_vir01.

    The following Articles(KB records) discuss problems with:

    * z63 and web OPAC searching:
    Article 000041595 (KB 8192-1433) ("Search redisplays Initial OPAC screen; no results") and
    Article 000036760 (KB 5711) ("Can't log into Web, 'unique constraint (VIR01.Z63_ID) violated' *MASTER RECORD*")

    * z65 and GUI searching:
    Article 000038483 (KB 8192-482) (GUI "License limit exceeded" )

    * z05, z110, and both web and GUI searching:
    Article 000046157 (KB 4456) ("'Unable to retrieve set of records' error when trying to display") and
    Article 000033257 (KB 8192-9608) ("OPAC searches not working: 'no items found, modify your search')

    * z52 and problem with Z63 unique constraint violated:
    Article 000033458 (KB 8192-6105) ("Z63 Unique Constraint - WRITE ERROR; clear_vir01 hangs")

    Resolution:
    There is a potential for any of the following processes to interfere with the proper running of clear_vir01: www_server, pc_server, oclc_server, and batch jobs which do searches and read the z05 and z110 (such as, p_sdi_01, p_serial_52, p_ret_03, and p_print_04).

    Note: the z39_server and z39_gate also use the tables mentioned above, but if the the www_server and the pc_server specified in the z39_server.conf hostname localhost are down, this will prevent the z39_server and z39_gate from reading the tables.

    Since it is difficult or impossible to run clear_vir01 when one can be certain that there will be no interference from other server activity, we recommend that it be run with the server processes down.

    See Article 000044208 (KB 5737) ("Restart Servers from job_list") in regard to stopping/restarting servers from the job list.

    In addition, you need to make certain that p_sdi_01, p_serial_52, p_ret_03, and p_print_04 don't run at the same time as clear_vir01.

    See Article 000035466 (KB 16384-24481) ("When to run clear_vir01 in hot mode?") in regard to running clear_vir01 in hot mode (with the servers up).