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
Cause:
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.
Resolution:
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