Skip to main content
ExLibris

  • Subscribe by RSS
    • Aleph
    Ex Libris Knowledge Center

    After upgrading to v22: "Order does not exist for this record" error message in GUI

    1. Last updated
      23:36, 8 Dec 2015
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 22

    Problem Symptoms:
    After going to Aleph version 22,

    1. In the Acquisitions GUI Order List, when an order is selected, the error message "Order does not exist for this record" occurs.

    2. util f/4 for the xxx50 z68 (order) table shows the following:

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

    Cause:
    The Upgrade Express step which was supposed to add the Z68_UPD_TIME_STAMP column to the z68 table was not run for this library, or failed.

    Resolution:
    Using the util_upgrade menu:

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

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

    Additional Information

    Comparing the ./alephm/source/copy/Z68 file (which shows what columns should exist in the table) to the "s+ xxx50" "desc z68" (which shows the columns which actually exist), it is seen that the z68 lacks the Z68_UPD_TIME_STAMP column 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