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

    p_item_01: errors writing z07 records for non-existent xxx20 ILL library

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

    In the item_01 log for MDC on 6/20, we see this error repeated:

    Oracle error: io_z07_write
    ORA-00942: table or view does not exist

    WARNING: cannot write Z07 for MDC20-000001158. See above io_z07_write message.

    We no longer have the xxx20 libraries and are not sure what to do about this error.

    Note: p_item_01 has been corrected so that it does not write z07 indexing requests. See KB 16384-7105.

    **OLD Answer:**

    As can be seen from the following SQL, you still have z103 links from the mdc50 records to the mdc20:

    mdc50@ALEPH18> select count(*) from z103 where z103_rec_key_1 like 'MDC20%';

    1 row selected.

    mdc50@ALEPH18> select z103_rec_key, z103_rec_key_1 from z103 where z103_rec_key_1 like 'MDC20%';
    Z103_REC_KEY Z103_REC_KEY_1
    ---------------- --------------
    MDC5000900031002 MDC20000001158
    MDC5000900032202 MDC20000001271
    MDC5000900033202 MDC20000001320
    MDC5000900033302 MDC20000001321
    MDC5000900036102 MDC20000002192
    MDC5000900037902 MDC20000002507
    MDC5000900041102 MDC20000002819
    MDC5000900041202 MDC20000002822
    MDC5000900041302 MDC20000002823
    MDC5000900041402 MDC20000002824
    MDC5000900041902 MDC20000002841

    Since the MDC20 library no longer exists, you can use SQL to delete these Z103's.

    <end OLD Answer>

    • Article last edited: 10/8/2013