2464079 - SUM errors in MAIN_POSTPROC/JOB_RSFIXUPG -ORA-00922 error while executing DDL in database oracle 12c | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2464079 - SUM errors in MAIN_POSTPROC/JOB_RSFIXUPG -ORA-00922 error while executing DDL in database oracle 12c

Symptom

During update/upgrade of the system with Oracle database version 12c, using SUM tool, following error is displayed in MAIN_POSTPROC/JOB_RSFIXUPG phase ,

SUM error.png

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

4-27-2017 12-13-32 AM.png

----Trouble Ticket ----

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...

Environment

SAP system on any OS with Oracle 12c database

Product

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

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.