Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

MAIN_SHDIMP/PARMVNT_SHD 288-cannot use duplicate table name

Hello all,

I am encountering below issue on MAIN_SHDIMP/PARMVNT_SHD of my upgrade. Below is the log:

2WETP000 10:06:29: Retcode 1024: error in DDL statement for "CECOEP                        " - repe

2WETP000 at

2EETP345 10:06:41: Retcode 1024: SQL-error "288-cannot use duplicate table name: CECOEP: line 1 col

2EETP345  21 (at pos 20)" in DDL statement for "CECOEP                        "

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

2EETP334 10:06:41: error in DDL, nametab for "CECOEP" not activated

2 ETP301 ----------------------------------------------------------------------

3 ETP361 "0" Shadow-Nametabs activated, DDL executed

2 ETP362 "2" Shadow-Nametab activations failed

2 ETP360 Begin: Act. of Shadow-Nametabs with DDL ("2015/10/22 10:06:17")

2 ETP363 End  : Act. of Shadow-Nametabs with DDL ("2015/10/22 10:06:41")

2 ETP301 ----------------------------------------------------------------------

1 ETP180 UNKNOWN ACTION

1 ETP110 end date and time   : "20151022100641"

1 ETP111 exit code           : "8"

1 ETP199 ######################################

Please help advice how to solve this. Thank you very much!

Former Member
Former Member replied

1. Check the modeflag for that table. If it's F, it must be updated to A.

select MODEFLAG from <schema>."DDXTT~" where tabname='<table_name>';

2. If it's F, Update the modeflag for the concerned table from F to A.

update <schema>."DDXTT~" set MODEFLAG = 'A' where tabname = '<table_name>';

Rerun the phase.

For more info please check below Note:

http://service.sap.com/sap/support/notes/589296

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question