Error in phase MAIN_SHDRUN/SUBMOD_FDC_RUN/PARMVNT_FDC - EHP3 upgrade

[Former Member]

Hello all,

Using SUM while running SCM 7.0 EHP3 upgrade I am getting error in phase MAIN_SHDRUN/SUBMOD_FDC_RUN/PARMVNT_FDC:

Checks after phase MAIN_SHDRUN/SUBMOD_FDC_RUN/PARMVNT_FDC were negative!

Last error code set: Single errors (code &gt; 😎 found in logfile 'MVNTFDC.ELG'<br/> 1 tp processes returned errors. View latest 'TP*.ECO' files in log-directory for details

ERROR: Detected the following errors:

# D:\SUM\abap\log\PD000203.SCD:

3 ETP000 NOT NULL )

3 ETP000 ON [/BIC/FZT_DEL_C1_PSCH000]

3 ETP000 WITH ( DATA_COMPRESSION = PAGE )

3 ETP000

2WETP000 11:10:14: Retcode 1: error in DDL statement for "/1CRR/TG00003781 " - repeat

2EETP345 11:10:26: Retcode 1: SQL-error "2726-Partition function '/BIC/FZT_DEL_C1_PFUN000' uses 1 c

2EETP345 olumns which does not match with the number of partition columns used to partition the tab

2EETP345 le or index." in DDL statement for "/1CRR/TG00003781 "

2 ETP000 --------------- DB-ROLLBACK() ---------------

2EETP334 11:10:26: error in DDL, nametab for "/1CRR/TG00003781" not activated

3 ETP000 NOT NULL )

3 ETP000 ON [/BIC/FZT_DEL_C2_PSCH000]

3 ETP000 WITH ( DATA_COMPRESSION = PAGE )

...skipped 18 more lines. Please see MVNTFDC.html for more information.

I checked some other log files:

MVNTFDC

1 ETQ201 Entering upgrade-phase "MAIN_SHDRUN/SUBMOD_FDC_RUN/PARMVNT_FDC" ("20150203110951")

2 ETQ367 Connect variables are set for standard instance access

4 ETQ399 System-nr = '00', GwService = 'sapgw00' Client = '000'

1 ETQ206 Executing pre-phase DB specific actions.

1 ETQ200 Executing actual phase 'MAIN_SHDRUN/SUBMOD_FDC_RUN/PARMVNT_FDC'.

1 ETQ399 Phase arguments:

2 ETQ399 Arg[0] = 'TP_MOVENTABS_SHD'

2 ETQ399 Arg[1] = 'INTDEL;INTACT;NOBUFFRESET;SHADOW_ONLY'

2 ETQ399 Arg[2] = 'MF=F,STEP=T,RANGE-TS'

2 ETQ399 Arg[3] = 'MVNTFDC.TP0'

1 ETQ399 Using error summary log 'MVNTFDC.ELG'.

1 ETQ399 Using 8 parallel processes

2 ETQ399 Empty putsteps - configuring at least parallel batches and main import processes.

2 ETQ399 Distribute 8 parallel processes to 2 tp and 4 R3trans.

4 ETQ380 computing toolpath for request "TP_MOVENTABS_SHD"

4 ETQ381 request "TP_MOVENTABS_SHD" means "tp mvntabs for shadow tables"

4 ETQ382 translates to group "R3UP_TOOL_GROUP_SHD"

4 ETQ399 Requirement for tp maps to 'exe'

4 ETQ383 translates to path "D:\SUM\abap\exe"

2 ETQ399 Starting 8 tp processes:

4 ETQ010 Starting: tp ddlntabs operation

3 ETQ121 20150203110952: PID 7444 execute 'D:\SUM\abap\exe\tp "pf=D:\SUM\abap\var\MVNTFDC.TPP" ddlntabs SCD "ddlmode=F" "step=T" "protyear=00" "seltsize=0" shadow_only "strel=701" "substext=4G" "-Dbuffreset=no"' in background, output written to 'D:\SUM\abap\log\TP00.ECO'.

2 ETQ399 Started tp ddlntabs with pid 7444

4 ETQ010 Starting: tp ddlntabs operation

3 ETQ121 20150203110952: PID 4888 execute 'D:\SUM\abap\exe\tp "pf=D:\SUM\abap\var\MVNTFDC.TPP" ddlntabs SCD "ddlmode=F" "step=T" "protyear=01" "seltsize=1" shadow_only "strel=701" "substext=4G" "-Dbuffreset=no"' in background, output written to 'D:\SUM\abap\log\TP01.ECO'.

2 ETQ399 Started tp ddlntabs with pid 4888

4 ETQ010 Starting: tp ddlntabs operation

3 ETQ121 20150203110952: PID 9100 execute 'D:\SUM\abap\exe\tp "pf=D:\SUM\abap\var\MVNTFDC.TPP" ddlntabs SCD "ddlmode=F" "step=T" "protyear=02" "seltsize=2" shadow_only "strel=701" "substext=4G" "-Dbuffreset=no"' in background, output written to 'D:\SUM\abap\log\TP02.ECO'.

2 ETQ399 Started tp ddlntabs with pid 9100

4 ETQ010 Starting: tp ddlntabs operation

3 ETQ121 20150203110952: PID 736 execute 'D:\SUM\abap\exe\tp "pf=D:\SUM\abap\var\MVNTFDC.TPP" ddlntabs SCD "ddlmode=F" "step=T" "protyear=03" "seltsize=3" shadow_only "strel=701" "substext=4G" "-Dbuffreset=no"' in background, output written to 'D:\SUM\abap\log\TP03.ECO'.

2 ETQ399 Started tp ddlntabs with pid 736

4 ETQ010 Starting: tp ddlntabs operation

3 ETQ121 20150203110952: PID 8864 execute 'D:\SUM\abap\exe\tp "pf=D:\SUM\abap\var\MVNTFDC.TPP" ddlntabs SCD "ddlmode=F" "step=T" "protyear=04" "seltsize=4" shadow_only "strel=701" "substext=4G" "-Dbuffreset=no"' in background, output written to 'D:\SUM\abap\log\TP04.ECO'.

2 ETQ399 Started tp ddlntabs with pid 8864

4 ETQ010 Starting: tp ddlntabs operation

3 ETQ121 20150203110952: PID 9264 execute 'D:\SUM\abap\exe\tp "pf=D:\SUM\abap\var\MVNTFDC.TPP" ddlntabs SCD "ddlmode=F" "step=T" "protyear=05" "seltsize=5" shadow_only "strel=701" "substext=4G" "-Dbuffreset=no"' in background, output written to 'D:\SUM\abap\log\TP05.ECO'.

2 ETQ399 Started tp ddlntabs with pid 9264

4 ETQ010 Starting: tp ddlntabs operation

3 ETQ121 20150203110952: PID 9732 execute 'D:\SUM\abap\exe\tp "pf=D:\SUM\abap\var\MVNTFDC.TPP" ddlntabs SCD "ddlmode=F" "step=T" "protyear=06" "seltsize=6" shadow_only "strel=701" "substext=4G" "-Dbuffreset=no"' in background, output written to 'D:\SUM\abap\log\TP06.ECO'.

2 ETQ399 Started tp ddlntabs with pid 9732

4 ETQ010 Starting: tp ddlntabs operation

3 ETQ121 20150203110952: PID 11492 execute 'D:\SUM\abap\exe\tp "pf=D:\SUM\abap\var\MVNTFDC.TPP" ddlntabs SCD "ddlmode=F" "step=T" "protyear=07" "seltsize=7" shadow_only "strel=701" "substext=4G" "-Dbuffreset=no"' in background, output written to 'D:\SUM\abap\log\TP07.ECO'.

2 ETQ399 Started tp ddlntabs with pid 11492

3 ETQ123 20150203110954: PID 9264 exited with status 0 (time 0.000 real)

2 ETQ399 tp ddlntabs finished with exit code 0.

3 ETQ123 20150203110954: PID 7444 exited with status 0 (time 0.000 real)

2 ETQ399 tp ddlntabs finished with exit code 0.

3 ETQ123 20150203110954: PID 4888 exited with status 0 (time 0.000 real)

2 ETQ399 tp ddlntabs finished with exit code 0.

3 ETQ123 20150203110954: PID 736 exited with status 0 (time 0.000 real)

2 ETQ399 tp ddlntabs finished with exit code 0.

3 ETQ123 20150203110954: PID 9732 exited with status 0 (time 0.000 real)

2 ETQ399 tp ddlntabs finished with exit code 0.

3 ETQ123 20150203110956: PID 11492 exited with status 0 (time 0.000 real)

2 ETQ399 tp ddlntabs finished with exit code 0.

3 ETQ123 20150203110956: PID 9100 exited with status 0 (time 0.000 real)

2 ETQ399 tp ddlntabs finished with exit code 0.

3 ETQ123 20150203110956: PID 8864 exited with status 0 (time 0.000 real)

2 ETQ399 tp ddlntabs finished with exit code 0.

2 ETQ399 Looking for pattern 'PD00....\.SCD'

2 ETQ399 Wasting log file 'D:\SUM\abap\log\PD000203.SCD'.

1 ETQ124 Scanned file 'log\PD000203.SCD' from offset 9525 to 12695 for errors.

2 ETQ399 Operation 'ddlntabs' looking for pattern 'PD00....\.SCD'

2 ETQ399 Looking for pattern 'PD01....\.SCD'

2 ETQ399 Wasting log file 'D:\SUM\abap\log\PD010203.SCD'.

1 ETQ124 Scanned file 'log\PD010203.SCD' from offset 3394 to 6564 for errors.

2 ETQ399 Operation 'ddlntabs' looking for pattern 'PD01....\.SCD'

2 ETQ399 Looking for pattern 'PD02....\.SCD'

2 ETQ399 Wasting log file 'D:\SUM\abap\log\PD020203.SCD'.

1 ETQ124 Scanned file 'log\PD020203.SCD' from offset 3394 to 6564 for errors.

2 ETQ399 Operation 'ddlntabs' looking for pattern 'PD02....\.SCD'

2 ETQ399 Looking for pattern 'PD03....\.SCD'

2 ETQ399 Wasting log file 'D:\SUM\abap\log\PD030203.SCD'.

1 ETQ124 Scanned file 'log\PD030203.SCD' from offset 3394 to 6564 for errors.

2 ETQ399 Operation 'ddlntabs' looking for pattern 'PD03....\.SCD'

2 ETQ399 Looking for pattern 'PD04....\.SCD'

2 ETQ399 Wasting log file 'D:\SUM\abap\log\PD040203.SCD'.

1 ETQ124 Scanned file 'log\PD040203.SCD' from offset 3394 to 6564 for errors.

2 ETQ399 Operation 'ddlntabs' looking for pattern 'PD04....\.SCD'

2 ETQ399 Looking for pattern 'PD05....\.SCD'

2 ETQ399 Wasting log file 'D:\SUM\abap\log\PD050203.SCD'.

1 ETQ124 Scanned file 'log\PD050203.SCD' from offset 3394 to 6564 for errors.

2 ETQ399 Operation 'ddlntabs' looking for pattern 'PD05....\.SCD'

2 ETQ399 Looking for pattern 'PD06....\.SCD'

2 ETQ399 Wasting log file 'D:\SUM\abap\log\PD060203.SCD'.

1 ETQ124 Scanned file 'log\PD060203.SCD' from offset 3394 to 6564 for errors.

2 ETQ399 Operation 'ddlntabs' looking for pattern 'PD06....\.SCD'

2 ETQ399 Looking for pattern 'PD07....\.SCD'

2 ETQ399 Wasting log file 'D:\SUM\abap\log\PD070203.SCD'.

1 ETQ124 Scanned file 'log\PD070203.SCD' from offset 3394 to 6564 for errors.

2 ETQ399 Operation 'ddlntabs' looking for pattern 'PD07....\.SCD'

2 ETQ399 Starting 1 tp processes:

4 ETQ010 Starting: tp ddlntabs operation

3 ETQ121 20150203111013: PID 8692 execute 'D:\SUM\abap\exe\tp "pf=D:\SUM\abap\var\MVNTFDC.TPP" ddlntabs SCD "ddlmode=F" "step=T" "protyear=00" shadow_only "strel=701" "substext=4G" "-Dbuffreset=no"' in background, output written to 'D:\SUM\abap\log\TP00.ECO'.

2 ETQ399 Started tp ddlntabs with pid 8692

3 ETQ123 20150203111050: PID 8692 exited with status 8 (time 0.000 real)

2EETQ399 tp ddlntabs failed with exit code 8.

2 ETQ399 Operation 'ddlntabs' looking for pattern 'PD00....\.SCD'

1 ETQ124 Scanned file 'log\PD000203.SCD' from offset 12805 to 18826 for errors.

4 ETQ399 html file conversion from 'D:\SUM\abap\log\MVNTFDC.ELG' to 'MVNTFDC.html' succeeded.

4 ETQ010 Date & Time: 20150203111051 

1EETQ399 Last error code set is: Single errors (code > 😎 found in logfile 'MVNTFDC.ELG'

1 tp processes returned errors. View latest 'TP*.ECO' files in log-directory for details

1EETQ203 Upgrade phase "PARMVNT_FDC" aborted with errors ("20150203111051")

TP00.ECO

SAPup> Starting subprocess in phase 'TP_ACTION_CP2SINI' at 20150202112054
    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
    ENV: PATH=D:\SUM\abap\exe;D:\sapdb\programs\bin;D:\sapdb\programs\pgm;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Imaging\;C:\Program Files\System Center Operations Manager 2007\;D:\Program Files\Microsoft SQL Server\100\Tools\Binn;D:\usr\sap\SCD\SYS\exe\uc\NTAMD64
    ENV: SAPSYSTEMNAME=SCD
    ENV: dbms_type=mss
    ENV: dbs_mss_schema=scd
    PWD: D:\SUM\abap\tmp

EXECUTING D:\SUM\abap\exe\tp.EXE "pf=D:\SUM\abap\var\CP2SHDI.TPP" r3e SAPKBBF740 -s SCD u18
This is D:\SUM\abap\exe\tp.EXE version 380.27.37 (release 741, unicode enabled)
This is D:\SUM\abap\exe\R3trans.exe version 6.24 (release 741 - 11.08.14 - 17:21:00).
unicode enabled version
D:\SUM\abap\exe\R3trans.exe finished (0004).
INFO: No client specified on command line. Taking client 0 from E070C.
tp finished with return code: 4
meaning:
  A tool used by tp produced warnings
SAPup> Process with PID 7592 terminated with status 4 at 20150202112055!
SAPup> Starting subprocess in phase 'PARMVNT_FDC' at 20150202213004
    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
    ENV: PATH=D:\SUM\abap\exe;D:\sapdb\programs\bin;D:\sapdb\programs\pgm;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Imaging\;C:\Program Files\System Center Operations Manager 2007\;D:\Program Files\Microsoft SQL Server\100\Tools\Binn;D:\usr\sap\SCD\SYS\exe\uc\NTAMD64
    ENV: SAPSYSTEMNAME=SCD
    ENV: dbms_type=mss
    ENV: dbs_mss_schema=scd
    PWD: D:\SUM\abap\tmp

EXECUTING D:\SUM\abap\exe\tp.EXE "pf=D:\SUM\abap\var\MVNTFDC.TPP" ddlntabs SCD "ddlmode=F" "step=T" "protyear=00" "seltsize=0" shadow_only "strel=701" "substext=4G" "-Dbuffreset=no"
This is D:\SUM\abap\exe\tp.EXE version 380.27.37 (release 741, unicode enabled)
tp finished with return code: 0
meaning:
  Everything OK
SAPup> Starting subprocess in phase 'PARMVNT_FDC' at 20150202213118
    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
    ENV: PATH=D:\SUM\abap\exe;D:\sapdb\programs\bin;D:\sapdb\programs\pgm;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Imaging\;C:\Program Files\System Center Operations Manager 2007\;D:\Program Files\Microsoft SQL Server\100\Tools\Binn;D:\usr\sap\SCD\SYS\exe\uc\NTAMD64
    ENV: SAPSYSTEMNAME=SCD
    ENV: dbms_type=mss
    ENV: dbs_mss_schema=scd
    PWD: D:\SUM\abap\tmp

EXECUTING D:\SUM\abap\exe\tp.EXE "pf=D:\SUM\abap\var\MVNTFDC.TPP" ddlntabs SCD "ddlmode=F" "step=T" "protyear=00" shadow_only "strel=701" "substext=4G" "-Dbuffreset=no"
This is D:\SUM\abap\exe\tp.EXE version 380.27.37 (release 741, unicode enabled)
tp finished with return code: 8
meaning:
  A tool used by tp produced errors
SAPup> Process with PID 5336 terminated with status 8 at 20150202213638!
SAPup> Starting subprocess in phase 'PARMVNT_FDC' at 20150203102328
    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
    ENV: PATH=D:\SUM\abap\exe;D:\sapdb\programs\bin;D:\sapdb\programs\pgm;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Imaging\;C:\Program Files\System Center Operations Manager 2007\;D:\Program Files\Microsoft SQL Server\100\Tools\Binn;D:\usr\sap\SCD\SYS\exe\uc\NTAMD64
    ENV: SAPSYSTEMNAME=SCD
    ENV: dbms_type=mss
    ENV: dbs_mss_schema=scd
    PWD: D:\SUM\abap\tmp

EXECUTING D:\SUM\abap\exe\tp.EXE "pf=D:\SUM\abap\var\MVNTFDC.TPP" ddlntabs SCD "ddlmode=F" "step=T" "protyear=00" "seltsize=0" shadow_only "strel=701" "substext=4G" "-Dbuffreset=no"
This is D:\SUM\abap\exe\tp.EXE version 380.27.37 (release 741, unicode enabled)
tp finished with return code: 0
meaning:
  Everything OK
SAPup> Starting subprocess in phase 'PARMVNT_FDC' at 20150203102350
    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
    ENV: PATH=D:\SUM\abap\exe;D:\sapdb\programs\bin;D:\sapdb\programs\pgm;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Imaging\;C:\Program Files\System Center Operations Manager 2007\;D:\Program Files\Microsoft SQL Server\100\Tools\Binn;D:\usr\sap\SCD\SYS\exe\uc\NTAMD64
    ENV: SAPSYSTEMNAME=SCD
    ENV: dbms_type=mss
    ENV: dbs_mss_schema=scd
    PWD: D:\SUM\abap\tmp

EXECUTING D:\SUM\abap\exe\tp.EXE "pf=D:\SUM\abap\var\MVNTFDC.TPP" ddlntabs SCD "ddlmode=F" "step=T" "protyear=00" shadow_only "strel=701" "substext=4G" "-Dbuffreset=no"
This is D:\SUM\abap\exe\tp.EXE version 380.27.37 (release 741, unicode enabled)
tp finished with return code: 8
meaning:
  A tool used by tp produced errors
SAPup> Process with PID 10396 terminated with status 8 at 20150203102427!
SAPup> Starting subprocess in phase 'PARMVNT_FDC' at 20150203110952
    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
    ENV: PATH=D:\SUM\abap\exe;D:\sapdb\programs\bin;D:\sapdb\programs\pgm;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Imaging\;C:\Program Files\System Center Operations Manager 2007\;D:\Program Files\Microsoft SQL Server\100\Tools\Binn;D:\usr\sap\SCD\SYS\exe\uc\NTAMD64
    ENV: SAPSYSTEMNAME=SCD
    ENV: dbms_type=mss
    ENV: dbs_mss_schema=scd
    PWD: D:\SUM\abap\tmp

EXECUTING D:\SUM\abap\exe\tp.EXE "pf=D:\SUM\abap\var\MVNTFDC.TPP" ddlntabs SCD "ddlmode=F" "step=T" "protyear=00" "seltsize=0" shadow_only "strel=701" "substext=4G" "-Dbuffreset=no"
This is D:\SUM\abap\exe\tp.EXE version 380.27.37 (release 741, unicode enabled)
tp finished with return code: 0
meaning:
  Everything OK
SAPup> Starting subprocess in phase 'PARMVNT_FDC' at 20150203111013
    ENV: PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
    ENV: PATH=D:\SUM\abap\exe;D:\sapdb\programs\bin;D:\sapdb\programs\pgm;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Imaging\;C:\Program Files\System Center Operations Manager 2007\;D:\Program Files\Microsoft SQL Server\100\Tools\Binn;D:\usr\sap\SCD\SYS\exe\uc\NTAMD64
    ENV: SAPSYSTEMNAME=SCD
    ENV: dbms_type=mss
    ENV: dbs_mss_schema=scd
    PWD: D:\SUM\abap\tmp

EXECUTING D:\SUM\abap\exe\tp.EXE "pf=D:\SUM\abap\var\MVNTFDC.TPP" ddlntabs SCD "ddlmode=F" "step=T" "protyear=00" shadow_only "strel=701" "substext=4G" "-Dbuffreset=no"
This is D:\SUM\abap\exe\tp.EXE version 380.27.37 (release 741, unicode enabled)
tp finished with return code: 8
meaning:
  A tool used by tp produced errors
SAPup> Process with PID 8692 terminated with status 8 at 20150203111050!

Can someone please help ?

[Former Member · Accepted solution]

This issue will not occur in SUM SP13, you should reset the upgrade and avoid the  nZDM option if not using SUM SP 13, or use SUM SP13.

[Former Member]

Hi Pankaj,

did you get any solution for this issue ? I am also facing the same error in my BW upgrade to EHP3.

Please share the solution if you get any.

Regards,