on 10-22-2015 10:55 AM
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!
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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have you checked the SAP KBA 1990326 - Error: Retcode 1024: SQL-error "288-cannot use duplicate table name?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.