My Oracle Support Banner

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 OCTOBER 05, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information 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



 

Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.