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

[former_member182657]

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

[sunny_pahuja2 · Accepted solution]

Hello,

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

Thanks,

Sunny

[former_member182657 · Accepted solution]

Hi Sunny,

Thanks for revert.As i checked with SE11 i found only one entry V_DSH_TF_DETAIL not V_DSH_ASSIGNED.Please suggest what i need to do next.

Thanks,

Gaurav

[sunny_pahuja2 · Accepted solution]

Hello,

You need to delete this entry from table DDXTT. But I would suggest to raise an OSS and get confirmation for the same.

Thanks,

Sunny

[former_member188883 · Accepted solution]

Hi Gaurav,

Try to activate the view V_DSH_ASSIGNED using SE14. Once activate resume upgrade.

Hope this helps.

Regards,

Deepak Kori

[former_member182657 · Accepted solution]

Hi Sunny,

As per your recommendations i deleted the respective entry from the table now i successfully passed from showstopper & the issue has been resolved now.

Thanks,

Gaurav Rana

[Former Member · Accepted solution]

Hi Deepak & all,

Is there any significance with deletion of entries from the table?

Thanks,
Henry

[former_member199963 · Accepted solution]

Hi Sunny,

This issue is coming up in the second SP upgrade that I am doing. The issue was fixed when I tried to activate V_DSH_TF_DETAIL and V_DSH_ASSIGNED in se11. It said that the activation failed and when I went in and checked the entries in the table DDXTT, the entries were gone. SP upgrade continued after this.

Thanks,

Asad

[former_member199963 · Accepted solution]

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

[Former Member]

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

[former_member182657]

Hi Rachit,

Have you followed the instructions under this SCN thread.

delete this entry from table DDXTT.

Regards,

Gaurav

[Former Member]

Hi Gaurav,

Thank you for your reply.

Which entry I need to delete from table DDXTT?

Regards,

Rachit.

[former_member182657]

Complete entries

[Former Member]

Hi Gaurav,

Thanks a lot.

I delete all the entries from the table DDXTT, and it worked.

Thanks again.

Regards,

Rachit

[Former Member]

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

[former_member182657]

Hi Mohan,

Here we are not deleting any table,we are just removing the entries from DDXTT table and with removal of these entries there is no inconsistency in the system.

Thanks

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

[Former Member]

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

[former_member189797]

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

Can you check the P* logs to find the DDL statement.

Thanks.

Regards,
Gaurav

[Former Member]

Hi Gaurav,

I have attached the P*Log files below  for more information  but same information returned as above .

Kindly advice

Thanks

Mohan

PMVNTUPG.txt.zip

PL000306.TXT.zip

PA140306.txt.zip

[former_member182657]

Hi Mohan,

Please find the solution as below:

Resolution :

Start the SAP instance with command >startsap r3 and logged on to system with client 000 user DDIC

as in execution phase you'll not be able to logon with other users and get message upgrade still running.

Now run TxSE16n  ---> DDXTT ---> execute ---> If any entry exists here,we need to delete the same and save.

SE16n --->DDXTT---> /H ---->Debug switched on ----> use GD-EDIT & GD-SAPEDIT with value X to edit the table.

Just mark the entry & remove.Click save for changes & after that stop the sap instance.

Now we can re execute the phase again.

Thanks,

Gaurav Rana

[former_member189797]

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