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

    manage-01: Oracle errors "io_z30_sub_library_list_n" and "update_cursor13 z30"

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

    Problem Symptoms:
    manage-01: the following errors appear in the xxx01 $data_scratch p_manage_01_a_*log's:

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

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

    There are 8 occurrences of the former and 11 of the latter.

    Note: this is a multi-ADM site.

    Cause:
    Uncertain

    Resolution:
    Given the fact that there are just 18 occurances (each representing one link/record), the best option is to just ignore them. If there's a real problem, someone will report it.

    Though Article 000014285 ("Oracle error: update_cursor1 z30; ... table or view does not exist") is for "Oracle error: update_cursor1 z30", I believe it's the same principle as this cursor13 (z30_id13 Oracle index) error.

    The SQL shown in that Article on xxx50 gives the results shown in Additional Information below. There are no blank or incorrect z103_lkr_library values. The same should be done for the other ADM's.

    Article 12400 ("Oracle error: io_z30_sub_library_list_n") is relevant to the other error, but, likewise, with just the 8 occurrences, it is not a cause for real concern.

    Additional Information

    xxx50@ALEPH21> select z103_lkr_library, z103_lkr_type, count(*) from z103 group by z103_lkr_library, z103_lkr_type order by z103_lkr_library, z103_lkr_type;
    **** Hit return to continue ****

    Z103_ Z10 COUNT(*)
    ----- --- ----------
    XXX30 ADM 3327
    XXX30 ITM 9806
    XXX50 ADM 1352296
    YYY01 ADM 1348969
    YYY01 ITM 8674
    ZZZ30 ITM 11

    Category: Batch (500)


    • Article last edited: 9/3/2014