Skip to Content
avatar image
Former Member

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 17, 2015 at 03:16 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 22, 2015 at 11:24 AM
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

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