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

    clear_vir01: "PL/SQL: numeric or value error: character to number conversion err

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

    Problem Symptoms:
    I find that our clear_vir01 (hot) logs have these lines between the z60 table and the z64:

    ERROR at line 1:
    ORA-06502: PL/SQL: numeric or value error: character to number conversion error
    ORA-06512: at line 23

    Cause:
    clear_vir01 used in hot mode

    Resolution:
    The following SQL in vir01: "select count(*) from z63;" shows that there are 5.4 million z63 records.
    clear_vir01 hot has not been dropping/creating the z63 table as it should.

    Run clear_vir01 in cold mode. See Additional Information.

    Additional Information

    See articles for further reference -
    When to run clear_vir01 in hot mode?
    clear_vir01 doesn't work from job_list in version 19 and 20
    Restart Servers from job_list

    Category: Background processing (500)


    • Article last edited: 8/5/2014