19c Preupgrade.jar fails with "ERROR - Unable to run preupgrade due to: check "job_table_integrity" raised the following exception and did not complete."
(Doc ID 2710280.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
19c Pre-Upgrade Utility fails with below Errors-
$ORACLE_HOME/jdk/bin/java -jar preupgrade.jar FILE TEXT DIR test
ERROR - Unable to run the preupgrade due to:ERROR - Unable to run preupgrade due to:
check "job_table_integrity" raised the following exception and did not complete.
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_PREUP", line 9585
ORA-00904: "NEXT_RUN_TIME": invalid identifier
ORA-06512: at "SYS.DBMS_PREUP", line 9585
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_PREUP", line 5256
preupgrade will attempt to continue from that error
ORA-06512: at "SYS.DBMS_PREUP", line 2145
ORA-06512: at "SYS.DBMS_PREUP", line 5150
ORA-06512: at "SYS.DBMS_PREUP", line 4997
INTERNAL ERROR: An internal preupgrade error occurred that prevents further execution. This is unexpected and usually caused by some sort of internal inconsistency. You may want to contact Oracle Support. The internal error message is:
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_PREUP", line 293
ORA-06512: at "SYS.DBMS_PREUP", line 5054
ORA-06512: at line 39
declare
*
ERROR at line 1:
ORA-20000: ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_PREUP", line 293
ORA-06512: at "SYS.DBMS_PREUP", line 5054
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at line 56
ERROR - Unable to run the preupgrade due to:ERROR - Unable to run preupgrade due to:
check "job_table_integrity" raised the following exception and did not complete.
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_PREUP", line 9585
ORA-00904: "NEXT_RUN_TIME": invalid identifier
ORA-06512: at "SYS.DBMS_PREUP", line 9585
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_PREUP", line 5256
preupgrade will attempt to continue from that error
ORA-06512: at "SYS.DBMS_PREUP", line 2145
ORA-06512: at "SYS.DBMS_PREUP", line 5150
ORA-06512: at "SYS.DBMS_PREUP", line 4997
INTERNAL ERROR: An internal preupgrade error occurred that prevents further execution. This is unexpected and usually caused by some sort of internal inconsistency. You may want to contact Oracle Support. The internal error message is:
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_PREUP", line 293
ORA-06512: at "SYS.DBMS_PREUP", line 5054
ORA-06512: at line 39
declare
*
ERROR at line 1:
ORA-20000: ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_PREUP", line 293
ORA-06512: at "SYS.DBMS_PREUP", line 5054
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at line 56
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |