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

    Getting strange search results

    • Article Type: General
    • Product: MetaLib
    • Product Version: 4

    Description:
    When we initiate a search Metalib comes back with: Search for "" in ""
    What's wrong?

    Resolution:
    The problems you're experiencing are tablespace related.
    UTIL O/14/8 shows that the "TS0" Oracle table space is quite low:

    NAME
    ------------
    TOTAL FREE M
    ------------
    TS0
    7

    TS1
    4428

    This indicates that tablespace needs to be added to TSO.
    If you do not know how to add tablespace, please submit a support incident and an Ex Libris Support Analyst will add table space for you.
    Once adequate table space has been added [e.g. using UTIL O/13/3 to add 4GB to TS0 across two files – meta4_ts0_07.dbf and meta4_ts0_08.dbf] your TSO table space, for example, will look like this:

    NAME
    ------------
    TOTAL FREE M
    ------------
    TS0
    3895

    TS1
    4428

    Note that the clear_vir01 [UTIL X/8] utility should be run after adding table space.

    In general, searches will get a little erratic when the tablespace starts to get too low (i.e., a search for 'dog' will return results for 'fish').
    When the tablespace gets really low, then searches will fail entirely (as was the case here).
    This behavior can be verified as a tablespace problem by the following error in the /exlibris/metalib/m4_3/log/search_server_4333.log:

    Oracle error: io_z115_write
    ORA-01653: unable to extend table M43_VIR01.Z115 by 128 in tablespace

    If you see strange search results and these errors in your search_server log, it's recommended to check the tablespace allocations.


    • Article last edited: 10/8/2013
    //Feedback