Following v20 upgrade: Oracle error: fetch z63 ... variable not in select list
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
We discovered that our OPAC was not functioning at all after we ran the Upgrade Express.
We see the following errors in the www_server log:
Oracle error: fetch z63
ORA-01007: variable not in select list
Oracle error: io_z63_write
ORA-00913: too many values
WRITE ERROR STSGI62BCLJCSIFCRXP825USCI4472L496PJLQDBUUCVSD9YKA
Oracle error: io_z63_update
ORA-00904: "Z63_SCAN_SET_ENTRY": invalid identifier
Resolution:
This is simlar to KB 16384-21521 in that the errors are occurring because a column (Z63_SCAN_SET_ENTRY) has been added to the v20 z63 table, and your table lacks this column.
vir01 is in the a-tree. The v20 version of the vir01 tables is loaded as part of the original installation of v20.
If you ran Upgrade Express to copy over just the u-tree from v19, the v20 demo libs (including vir01) should have been preserved.
If you cloned your v19 onto v20, then you should have run $aleph_proc/oracle_imp_demo_libs as part of that process. This proc contains steps for the vir01:
echo "create_ora_user VIR01"
csh -f $aleph_proc/create_ora_user_b vir01
echo "Recreating tables..."
csh -f $aleph_proc/util_a_17_b table all >& /dev/null
<etc.>
In any case, if you see this problem post-upgrade, the solution is to run clear_vir01, which drops/creates the z63.
[From site:]
We have now run the UE without problem. We did not copy our VIR01 data over as before and the z63 was upgraded as expected.
- Article last edited: 10/8/2013