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

    After upgrading to v22: "Unable to find item" error message in GUI

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

    Problem Symptoms:
    After going to Aleph version 22,

    1. In the Circ or Cataloging GUI, when an item is selected, the error message "Unable to find item" occurs.

    2. util f/4 for the xxx50 z30 (item) table shows the following:

    Oracle error: fetch z30
    ORA-01007: variable not in select list

    The Upgrade Express step which was supposed to add the Z30-UPD-TIME-STAMP and/or Z30-IP-LAST-RETURN-V6 column to the z30 table was not run for this library, or failed.

    Using the util_upgrade menu:

    3. Upgrade Express --> 2. Run a specific step

    Run/rerun the step which was supposed to add the columns.

    Additional Information

    Comparing the ./alephm/source/copy/Z30 file (which shows what columns should exist in the table) to the "s+ xxx50" "desc z30" (which shows what columns actually exist), it is seen that the z30 lacks the Z30-UPD-TIME-STAMP and Z30-IP-LAST-RETURN-V6 columns which should have been added by Upgrade Express.

    See also, Article 00011209 (Oracle: "fetch znnn" & "variable not in select list"; "Libraries to be upgraded")

    Category: System Management (500)

    • Article last edited: 5/29/2014