Skip to Content
avatar image
Former Member

Severe error(s) occurred in phase MAIN_NEWBAS/MVNTAB_UPG!

Hi all,

During SAP upgrade from ECC 5.0 to ECC 6.0 EHP7 on Execution phase i'm getting error:

Severe error(s) occurred in phase MAIN_NEWBAS/MVNTAB_UPG!

Last error code set: Calling '/usr/sap/QTY/DVEBMGS00/exe/tp' failed with return code 8,

check /usr/sap/QTY/SUM/abap/log/TP.ECO for details<br/> Error during &quot;tp mvntabs&quot;-call - check 'TP.ECO'

ERROR: Detected the following errors:

# /usr/sap/QTY/SUM/abap/log/PD050121.QTY:

          3 ETP399 "SHPOSITION", DD30L."AUTOSUGGEST" AS "AUTOSUGGEST" FROM "DD31S"

          3 ETP399 INNER JOIN "DD30L" ON "SHLPNAME" = "SUBSHLP" WHERE "AS4LOCAL" =

          3 ETP399 'A' AND "AS4LOCAL" = 'A' AND "HIDEFLAG" = ' ' AND "AUTOSUGGEST" = 'X'

          3 ETP399 

          2WETP000 01:50:02: Retcode 1: error in DDL statement for "V_DSH_ASSIGNED                " - repeat

          2EETP345 01:50:14: Retcode 1: SQL-error "918-ORA-00918: column ambiguously defined" in DDL statemen

          2EETP345 t for "V_DSH_ASSIGNED                "

          2 ETP399  --------------- DB-ROLLBACK() ---------------

          2EETP334 01:50:14: error in DDL, nametab for "V_DSH_ASSIGNED" not activated

         

          3 ETP399 "TABCLASS", DD03L."SHLPORIGIN" AS "SHLPORIGIN" FROM "DD02L" INNER

          3 ETP399 JOIN "DD03L" ON "TABNAME" = "TABNAME" WHERE "AS4LOCAL" = 'A' AND

          3 ETP399 "AS4LOCAL" = 'A'

          3 ETP399 

          

...skipped 5 more lines. Please see PMVNTUPG.html for more information.

This error is bit similar with thread and i followed  http://scn.sap.com/thread/3482964

But still getting the same error.

Please help me to resolve the same.

Thanks,

Gaurav Rana

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 21, 2014 at 06:04 AM

    Hello,

    Could you please check if there is entry corresponding to view- V_DSH_ASSIGNED in table DDXTT?

    Thanks,

    Sunny

    Add comment
    10|10000 characters needed characters exceeded

    • We have discovered the reason for this issue, we were using the import of rfc's from version 731 while doing a fresh install of NW741, version difference was causing the issue.

      Thanks,

      Asad

  • avatar image
    Former Member
    Mar 05, 2014 at 05:26 PM

    Hi Gaurav ,

    I faced same kind f issue while upgrading to EHP7 ,in Execution phase .

    Kindly advice how to fix this in detail because i can't login to system to delete .

    below is the error log ....

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    (null) and RETURN CODE in PD070305.DEC
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    3 ETP399 "SHPOSITION", DD30L."AUTOSUGGEST" AS "AUTOSUGGEST" FROM "DD31S"

    3 ETP399 INNER JOIN "DD30L" ON "SHLPNAME" = "SUBSHLP" WHERE "AS4LOCAL" =

    3 ETP399 'A' AND "AS4LOCAL" = 'A' AND "HIDEFLAG" = ' ' AND "AUTOSUGGEST" = 'X'

    3 ETP399

    2WETP000 23:44:05: Retcode 1: error in DDL statement for "V_DSH_ASSIGNED " - repeat

    2EETP345 23:44:17: Retcode 1: SQL-error "918-ORA-00918: column ambiguously defined" in DDL statemen

    2EETP345 t for "V_DSH_ASSIGNED "

    2 ETP399 --------------- DB-ROLLBACK() ---------------

    2EETP334 23:44:17: error in DDL, nametab for "V_DSH_ASSIGNED" not activated

    3 ETP399 "TABCLASS", DD03L."SHLPORIGIN" AS "SHLPORIGIN" FROM "DD02L" INNER

    3 ETP399 JOIN "DD03L" ON "TABNAME" = "TABNAME" WHERE "AS4LOCAL" = 'A' AND

    3 ETP399 "AS4LOCAL" = 'A'

    3 ETP399

    2WETP000 23:44:17: Retcode 1: error in DDL statement for "V_DSH_TF_DETAIL " - repeat

    2EETP345 23:44:29: Retcode 1: SQL-error "918-ORA-00918: column ambiguously defined" in DDL statemen

    2EETP345 t for "V_DSH_TF_DETAIL "

    2 ETP399 --------------- DB-ROLLBACK() ---------------

    2EETP334 23:44:29: error in DDL, nametab for "V_DSH_TF_DETAIL" not activated

    1 ETP111 exit code : "8"

    Thanks

    Mohan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Reason why statement is failing because the syntax is not correct.

      3 ETP399 "TABCLASS", DD03L."SHLPORIGIN" AS "SHLPORIGIN" FROM "DD02L" INNER

      3 ETP399 JOIN "DD03L" ON "TABNAME" = "TABNAME" WHERE "AS4LOCAL" = 'A' AND

      3 ETP399 "AS4LOCAL" = 'A'

      Where clause does not seem to be correct. Seems to be bug or something.

      What is the version of the SUM tool you are using?

      Thanks.

      Regards,
      Gaurav

  • avatar image
    Former Member
    Mar 06, 2014 at 08:51 AM

    Hi Gaurav,

    What will be the implication if we delete  the standard table entries  any inconsistency in the system ?

    Is the above method sap recommended one .

    Kindly suggest this issue is the showstopper now .

    Thanks

    Mohan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Mohan,

      Just would like to share that in one of our customer's system, we experienced the same issue. They have raised an OSS message, and SAP has recommended the same i.e. removing the entries from table DDXTT.  😊


      Thanks.

  • avatar image
    Former Member
    Sep 18, 2014 at 05:57 AM

    Hi,

    I am getting similar error during Execution phase (upgrading EHP5 to EHP7).

    Severe error(s) occurred in phase MAIN_NEWBAS/MVNTAB_UPG!

    Last error code set: Calling '/usr/sap/EC1/DVEBMGS00/exe/tp' failed with return code 8, check /usr/sap/EC1/SUM/abap/log/TP.ECO for details<br/> Error during &quot;tp mvntabs&quot;-call - check 'TP.ECO'    

    ERROR:
    Detected the following errors:

    # /usr/sap/EC1/SUM/abap/log/PD000918.EC1:

    3 ETP000 "CI_EKAB"."EBELN" AND "EKPO"."EBELP" = "CI_EKAB"."EBELP" AND

    3 ETP000 "EKPO"."MANDT" = "CI_EKAB"."MANDT" ) WHERE "EKPO"."BSTYP" = 'K'

    3 ETP000

    2WETP000 10:06:31: Retcode 512: error in DDL statement for "CDS_M_CT_I_STAT " - repea

    2WETP000 t

    2EETP345 10:06:43: Retcode 512: SQL-error "942-ORA-00942: table or view does not exist" in DDL stat

    2EETP345 ement for "CDS_M_CT_I_STAT "

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

    2EETP334 10:06:43: error in DDL, nametab for "CDS_M_CT_I_STAT" not activated

    3 ETP000 = "PDI_CALC"."EBELN" AND "EKPO"."EBELP" = "PDI_CALC"."EBELP" AND

    3 ETP000 "EKPO"."MANDT" = "PDI_CALC"."MANDT" )

    3 ETP000

    2WETP000 10:06:43: Retcode 512: error in DDL statement for "CDS_M_M2S_PD_ITM " - repea

    2WETP000 t

    2EETP345 10:06:55: Retcode 512: SQL-error "942-ORA-00942: table or view does not exist" in DDL stat

    2EETP345 ement for "CDS_M_M2S_PD_ITM "

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

    2EETP334 10:06:55: error in DDL, nametab for "CDS_M_M2S_PD_ITM" not activated.

    Please help.

    Regards,

    Rachit

    Add comment
    10|10000 characters needed characters exceeded