2464079 - Error in phase MAIN_POSTPROC/JOB_RSFIXUPG -ORA-00922 error while executing DDL in database oracle 12c during an upgrade or update

• During update or upgrade of a system with Oracle database version 12c, using the Software Update Manager (SUM), the following error is displayed in MAIN_POSTPROC/JOB_RSFIXUPG phase ,

• Checking the JOB logs it shows ORA-00922 error while executing DDL command,

./SUM/abap/log/SAPup_troubleticket.log

SAPup broke during phase JOB_RSFIXUPG in module MAIN_POSTPROC / Post Processing
Error Message: Single errors (code <= 8) found in logfile 'RSFIXUPG.ELG'

./SUM/abap/log/RSFIXUPG.ELG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
FIX INCONSISTENCIES ERRORS and RETURN CODE in RSFIXUPG2.<SID>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4 ETG011 "+-- DROP SHADOW GTTs --+"
4 ETG011 "+-- DROP /1FS/* TABLES --+"
4 ETG011 "+-- DROP ECM,COM,CME-TABLES --+"
4 ETG011 "+-- CHECK INDEX TRDIRT~NAM --+"
4 ETG011 "+-- CREATE VER_CLUSTR and CLU4 --+"
2EETG013 "CLU4" "needs to be created" "on the database"
2EETG013 "VER_CLUSTR" "needs to be created" "on the database"

./SUM/abap/log/RSFIXUPG.LOG

1 ETQ234 Call of function module "SUBST_START_BATCHJOB" by RFC succeeded
4 ETQ010 Date & Time: 20170328100937 
2 ETQ373 parameter "JOBCOUNT" = "10093700"
2 ETQ374 parameter "RC_START" = "0"
4 ETQ311 Batch job "RSFIXUPG2" with job count "10093700" scheduled
2 ETQ399 20170328100937: Job RSFIXUPG2 jobcount 10093700 still running...
1 ETQ359 RFC Login to: System="<SID>", AsHost="SAP<SID>" Nr="00", Client="000", GwHost="SAP<SID>", GwService="sapgw00"
2 ETQ232 RFC Login succeeded
4 ETQ010 Date & Time: 20170328100942 
1 ETQ233 Calling function module "SUBST_CHECK_BATCHJOB" by RFC
2 ETQ373 parameter "JOBNAME" = "RSFIXUPG2"
2 ETQ373 parameter "JOBCOUNT" = "10093700"
2 ETQ373 parameter "IV_VERIFY" = " "
1 ETQ234 Call of function module "SUBST_CHECK_BATCHJOB" by RFC succeeded
4 ETQ010 Date & Time: 20170328100942 
2 ETQ373 parameter "JOBSTATUS" = "F"
2 ETQ374 parameter "RC_CHECK" = "0"
2 ETQ373 parameter "JOBENDDATE" = "20170328"
2 ETQ373 parameter "JOBENDTIME" = "100938"
4 ETQ263 Batchjob "RSFIXUPG2" finished successfully
2 ETQ399 Phase JOB_RSFIXUPG is now finalizing...
1 ETQ124 Scanned file 'log\RSFIXUPG2.<SID>' from offset 1360 to 2406 for errors.
4EETQ399 Some errors found during the log scan!
2 ETQ399 Phase JOB_RSFIXUPG: Finalize OK
4 ETQ010 Date & Time: 20170328100942 
1EETQ399 Last error code set is: Single errors (code <= 8) found in logfile 'RSFIXUPG.ELG'
1EETQ203 Upgrade phase "JOB_RSFIXUPG" aborted with errors ("20170328100942")

Read more...

SAP system on any OS with Oracle 12c database

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

software update manager , SM50 , work process logs , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , BC-DB-ORA , Oracle , Problem