Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. *Master record for search problems resulting from clear_vir01 problems*

    *Master record for search problems resulting from clear_vir01 problems*

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1.  
    • Article Type: General
    • Product: Aleph
    • Product Version: 20, 21, 22, 23

    Description:

    This is a master record for search problems resulting from problems with clear_vir01.  The following articles discuss problems with:

               * z63 and web OPAC searching:

    • Search redisplays Initial OPAC screen; no results"

    • Can't log into Web, "unique constraint (VIR01.Z63_ID) violated" *MASTER RECORD*


    * z65 and GUI searching:     GUI "License limit exceeded"

    * z05, z110, and both web and GUI searching:

    • "Unable to retrieve set of records" error when trying to display

    • OPAC searches not working: "no items found, modify your search"


              * z52 and problem with Z63 unique constraint violated:   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 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 KB 16384-24481 (clear_vir01 in hot mode or in cold mode?) in regard to running clear_vir01 in hot mode (with the servers up).

     


    • Article last edited: 2/14/2022
    View article in the Exlibris Knowledge Center
    1. Back to top
      • *lc_call_no* tab_filing routine *MASTER RECORD*
      • *Master* Oracle Tables Document -- List for Tables with No Regular Z-Table Doc
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved