cancel
Showing results for 
Search instead for 
Did you mean: 

MAIN_SHDIMP/PARMVNT_SHD 288-cannot use duplicate table name

Former Member
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Reagan
Advisor
Advisor
0 Kudos
Former Member
0 Kudos

Hi Reagan, Is this only for Oracle database? I am unable to execute it in HANA database... seems I am not authorized.