ORA-01722: invalid number in word index log

• 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