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

    Following v20 upgrade: Oracle error: fetch z63 ... variable not in select list

    1. Last updated
    2. Save as PDF
    • 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