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

    ORA-01007 (fetch z403)

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

    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

    Lines preceding these errors in the log (such as "Load: /aleph_tmp/utf_files/.../xxx60/tab/tab_buf_z403") indicate that the program is looking for the z403 in an xxx60 HOL library.

    The xxx60 Z403 has the 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.

    * 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 exist in BIB and CRS libraries.

    • Article last edited: 5/8/2014