clear_vir01: "PL/SQL: numeric or value error: character to number conversion err
- Article Type: General
- Product: Aleph
- Product Version: 20
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
clear_vir01 used in hot mode
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.
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