Skip to main content
ExLibris

 

  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Web OPAC and GUI Search keyword searches (Find), extremely slow / time out

    •  
    • Product: Aleph
    • Product Version: 20, 21, 22, 23

    Description:
    Web OPAC and GUI Search keyword searches (Find), are extremely slow and usually time out.

    Resolution:
    The primary tables involved in keyword searching are z95, z97, z98, and z980.
    Checking with util a/17/14, we found that the z98_id Oracle index was not present.

    Running util a/17/2 to rebuild it was unsuccessful because of duplicates:
    CREATE UNIQUE INDEX XXX01.Z98_ID ON XXX01.Z98 (Z98_REC_KEY ASC)
    ERROR at line 1:
    ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found


    Running util a/17/18 to delete the duplicates (and create the unique index) was successful. (See article Cannot CREATE UNIQUE INDEX; duplicate keys found; using util a/17/18 **HOW TO** (KB 8192-424) for details on util a/17/18.)

     


    • Article last edited: 22-Mar-2016