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. Z00T and Z112 don't exist

    Z00T and Z112 don't exist

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    I don't know how important the Z00T table is but I noticed the following error in our pc_server_6991.log on our v20 production server:
    Oracle error: update_cursor z00t
    ORA-00942: table or view does not exist

    I get the same error when I do util/f/4 followed by the following over and over when you hit enter:
    01 z00t_doc_track \
    02 z00t_rec_key \
    03 doc_number .......000000001
    02 z00t_cataloger .....
    02 z00t_update_date ...00000000
    02 z00t_update_time ...0000
    02 z00t_field_code ....
    02 z00t_text ..........
    new doc number = K, exit = Q, continue = RETURN

    For Z112, I just get:
    Oracle error: io_z112_next
    ORA-00942: table or view does not exist

    On our v20 test server, I do not get these errors. Is this another problem related to our production upgrade? I had submitted SI #16384-281?859 with an issue with the z71 table after our upgrade but it was determined only z71, z30h and z104 were missing. So I don't know why the Z00T and Z112 problems were not found as well. Although this error is different and just looks like the tables need to be created since they are new in v20. So let me know how we should handle this.

    Resolution:
    I found that 4 steps did not complete, however 3 of them (1002, 1004 and 1009) are for ILL, which you do not have. Additionally step 1010 did not create a sequence, so I have run that step as well and confirmed its success.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • z00r expand not used when record is updated via p_manage_18
      • Z0102 and Base Cleanup
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Prod:Aleph
      4. 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