p_manage_18; SET Z52_SEQUENCE; "ORA-01722: invalid number"
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
This is from the p_manage_18 log:
old 2: SET Z52_SEQUENCE = (SELECT MAX(Z00_DOC_NUMBER) FROM &&1..Z00)
new 2: SET Z52_SEQUENCE = (SELECT MAX(Z00_DOC_NUMBER) FROM ABC01.Z00)
SET Z52_SEQUENCE = (SELECT MAX(Z00_DOC_NUMBER) FROM ABC01.Z00)
*
ERROR at line 2:
ORA-01722: invalid number
and this SQL shows the problem:
SQL> SELECT MAX(Z00_DOC_NUMBER) FROM ABC01.Z00;
MAX(Z00_D
---------
?»¿030095
Resolution:
As described in KB 3961, the correct_last_doc_number proc resets the z52 (util g/2) last-doc-number value.
In this case the proc has found that the max z00_doc_number contains non-numeric characters.
See KB 16384-22993 for how to handle this situation.
- Article last edited: 10/8/2013