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. ORA-01722: invalid number in word index log

    ORA-01722: invalid number in word index log

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

    Description:
    We ran the p_manage_01 word index on our v20 test system. There's an error in the indexing log file. I can search from Web OPAC after the index. But I am not sure if this index process is successful. Please see the error in the log;
    ----------------------------------------------------------------------------------------------------------
    aleph_admin@ALEPH0> SET Z52_SEQUENCE = (SELECT MAX(Z00_DOC_NUMBER) FROM ABC01.Z00)
    *
    ERROR at line 2:
    ORA-01722: invalid number

    -------------------------------------------------------------------------------------------------------------

    I checked the table z00 from database and find there is one record with not valid z00_doc_number "01209nam". Should I delete this record?

    Resolution:
    If the job seems to have worked OK otherwise, probably this "invalid number" error can be ignored.

    A record with z00_doc_number 01209nam is clearly wrong. If you can bring it up in GUI Cataloging and delete it, that would be best. (Then ue_01 should remove any index entries.)

    KB 16384-24964 is a somewhat similar case.


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • ORA-01654: unable to extend index ABC50.Z00P_ID2 by 16 in tablespace T
      • ORA-01919: role 'JAVA_ADMIN' does not exist
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 18.01
      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