Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. manage-01: Oracle errors "io_z30_sub_library_list_n" and "update_cursor13 z30"

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

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • manage-01: "A write error occurred while sorting"; /var 100% full
      • manage-02 fails to index certain headings; ue_01 *does* index them
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 21
      2. Batch (500)
      3. contype:kba
      4. Prod:Aleph
      5. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved