• 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