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

    Searches in Metalib return the following: Search for "" in ""

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

    Description:
    When we initiate a search Metalib comes back with: Search for "" in ""

    Resolution:
    The problems you're experiencing are tablespace related.

    Note that searches will become 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 in your case).

    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

    Anytime in the future that you notice this kind of searching behavior, and see the above log error, check the current tablespace allocations:

    Output of util O-14-8 shows that TS0 is quite low:

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

    TS1
    4428

    This was resolved by adding 4GB to TS0 (across two files – meta4_ts0_07.dbf and meta4_ts0_08.dbf) using util O-13-3.
    Output of util O-14-8 for TS0 is now:

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

    TS1
    4428

    You should also run clear_vir01 using UTIL X/8.


    • Article last edited: 10/8/2013
    • Was this article helpful?