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.