SUM Upgrade Error: MAIN_NEWBAS/PARCONV_UPG

[tan_michael]

Hi Experts,

We are installing EHP7 to our SAP System ECC 6.0 using SUM, it went well until in 78% of process under phase MAIN_NEWBAS/PARCONV_UPG I got the below errors:

PARCONV logs...

ERROR:
Detected the following errors:

# G:\SUM\abap\log\NCONV00.P18: 4 EGT281 sql: 4 ED0314 DROP TABLE "QCM8BTXRATE" 2 ED0313 SQL error 942: ORA-00942: table or view does not exist 4 EDA093 "DDL Time(___1):" ".........2" milliseconds 4 EGT247 .... "QCM8BTXRATE" was already removed 2EEGT207 Creation of table "BTXRATE" or primary index in DB failed 2EEGT239 Error in step "BTXRATE-STEP5" 4 EGT253XTotal time for table "BTXRATE": "000:00:01" 2EEGT094 Conversion could not be restarted 4 EGT281 sql: 4 ED0314 DROP TABLE "QCM8DRVLOG_FIELD" 2 ED0313 SQL error 942: ORA-00942: table or view does not exist 4 EDA093 "DDL Time(___1):" ".........2" milliseconds.....

.....

..

3 ETP000 MAXEXTENTS UNLIMITED
3 ETP000 PCTINCREASE 0000
3 ETP000 FREELISTS 001
3 ETP000 FREELIST GROUPS 01)
3 ETP000
2EETP345 10:14:33: Retcode 1: SQL-error "922-ORA-00922: missing or invalid option" in DDL statement
2EETP345 for "WCAMI "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 10:14:33: error in DDL, nametab for "WCAMI" not activated
1 ETP111 exit code : "8"

•••

I checked https://wiki.scn.sap.com/wiki/display/SL/PARCONV_UPG+or+PARCONV_UPG_DS+or+PARCONV_TRANS++phase

and found the same error when I tried to click the KBA solution unfortunately the sap note is currently updated and can't access it.

•••

I checked the tablespace and there is enough space.

•••

I also noticed those tabnames are existing in se14 but there's a message that say it does not exist in database.

•••

Additional Details:

OS: WS2012R2 , DB: Oracle12c

Is there anyone encountered the same error during EHP upgrade? please help me.

[tan_michael]

Hi Experts,

I have found this sap note

SNOTE 2064052 - "ORA-00922: missing or invalid option" error in phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/...

and it says that I need to update my initSID.ora parameter according to 1888485 - Database Parameter for 12.1.0.2. and try again.

After running again the error changed(I think it work?) but still in parconv phase.

please see below for new error logs:

Last error code set: Unhandled tables found in inactive nametab

2 ETQ399 Requested task ID is 'COUNT_MODEFLAGS'.
3 ETQ399 Generated TQL file 'DDXTTCNT.XQL' with 1 SQL statements, log file 'DDXTTCNT.LOG'.
2 ETQ399 Distributed 0 statements, 1 actual ones are written to TQL files.
4 ETQ276 Executing SQL-script "DDXTTCNT.XQL"
3 ETQ120 20180607140805: PID 11884 execute '~\bin_749\SAPuptool execdb ..\var\DDXTTCNT.XQL', output written to 'G:\SUM\abap\log\SQLSTMTSTD.OUT'.
3 ETQ123 20180607140805: PID 11884 exited with status 0 (time 0.00 real)
3 ETQ399 Reading selections from 'DDXTTCNT.LOG'.
4 ETQ399 Read 3 entries for table 'LIST'.
1EETQ399 Unhandled entries found in inactive nametab:
2EETQ399 Modeflag 'U' appears 3 times
2 ETQ399 Requested task ID is 'PRINT_MODEFLAGS'.
3 ETQ399 'LIST': Distributed 5 statements.
3 ETQ399 Generated TQL file 'DDXTTPRINT.XQL' with 1 SQL statements, log file 'DDXTTPRINT.LOG'.
2 ETQ399 Distributed 5 statements, 1 actual ones are written to TQL files.
4 ETQ276 Executing SQL-script "DDXTTPRINT.XQL"
3 ETQ120 20180607140805: PID 14420 execute '~\bin_749\SAPuptool execdb ..\var\DDXTTPRINT.XQL', output written to 'G:\SUM\abap\log\SQLSTMTSTD.OUT'.
3 ETQ123 20180607140806: PID 14420 exited with status 0 (time 0.00 real)
3 ETQ399 Reading selections from 'DDXTTPRINT.LOG'.
4 ETQ399 Read 3 entries for table 'TABLIST'.
3EETQ399 Found entry VER_CLUSTR with mode flag 'U' in inactive nametab
3EETQ399 Found entry CLU4 with mode flag 'U' in inactive nametab
3EETQ399 Found entry AT30 with mode flag 'U' in inactive nametab
4 ETQ010 Date & Time: 20180607140806
1EETQ399 Last error code set is: Unhandled tables found in inactive nametab
1EETQ203 Upgrade phase "PARCONV_UPG" aborted with errors ("20180607140806")

[tan_michael · Accepted solution]

Hi All,

I have solved my own Q&A *facepalm* XD

This just to share the solution...

Activity: Installing EHP7 to our SAP ECC 6.0 Oracle 12c using SUM

Error Encountered in phase: MAIN_NEWBAS/PARCONV_UPG

Cause: The ORACLE parameter COMPATIBLE is set with incorrect value.

Solution: Update initSID.ora based on SNOTE 1888485 ( Please read SNOTE 2064052 ) after updating the initsid.ora perform below sql command

SQL> shutdown immediate *need to shutdown the db*

SQL> create spfile from pfile='<oracle home path>/initSID.ora';

SQL> startup

then rerun the SUM; now the sum process will proceed.

--> In my case there is a follow up error then we should check the parconv.log

4 ETQ399 Read 3 entries for table 'TABLIST'.
3EETQ399 Found entry VER_CLUSTR with mode flag 'U' in inactive nametab
3EETQ399 Found entry CLU4 with mode flag 'U' in inactive nametab
3EETQ399 Found entry AT30 with mode flag 'U' in inactive nametab
4 ETQ010 Date & Time: 20180607140806
1EETQ399 Last error code set is: Unhandled tables found in inactive nametab

---> above tables entries that are inactive nametab must be activated manually using tcode SE14, once activated try again the SUM!

^___^

[daniel_kovacs]

Hi,

The Conversion steps are described in:

https://help.sap.com/saphelp_nwpi71/helpdata/en/cf/21f1b8446011d189700000e8322d00/content.htm?no_cac...

It is normal that in STEP5 the QCM table will be dropped , please try to activate table in SE11 "WCAMI" after this please repeat the phase.

Best regards,

Daniel

[tan_michael]

Hi Daniel,

Thanks for your answer but WCAMI was already activated and the error persist.