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

    ORA-01007 (fetch z403)

    • Article Type: General
    • Product: Aleph
    • Product Version: 22

    Problem Symptoms:
    After upgrade to Aleph 22 following messages occured in pc_server_nnnn.log:

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

    Cause:
    In XXX60 exists Z403 having old Aleph 21 structure.
    The structure of Z403 can be checked via SQL:
    desc XXX60.z403;

    In Aleph 22 the table should have field Z403_IP_ADDRESS_V6.
    Z403 is not needed in HOL libraries and therefore obsolete in XXX60.

    Resolution:
    * Make sure that Z403 in XXX60 is empty:
    >select count(*) from xxx60.z403;
    * If it has no data drop the table:
    >drop table xxx60.z403;

    Additional Information

    Per system design Z403 should only exists in BIB and CRS libraries.


    • Article last edited: 5/8/2014