Symptom
A similar error can be found in the file DBCLONE.ELG:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CLONING ERRORS and RETURN CODE in DBCLONE01.D02
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3 ETGCLN ALTER TABLE [DDNTT~] ADD CONSTRAINT [DDNTT~0] PRIMARY KEY CLUSTERED ( [TABNAME] ) ON [PRIMARY];
3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'MSS' AND TABNAME = 'DDNTT~' AND INDEXNAME = '0';
3 ETGCLN insert into [DDNTT~] ( [TABNAME], [VERSION], [UUID], [CRTIMESTMP], [ABTIMESTMP], [DYTIMESTMP], [FLDCNT], [TABLENGTH], [KEYCNT], [KEYLENGTH], [CLIENTPOS], [TABTYPE], [TABFORM], [REFNAME], [HFLAG], [BUFSTATE], [BUFPARM], [ALIGN], [POINTERLG], [UNICODELG], [COMPCNT], [LEAFCNT] ) select [TABNAME], [VERSION], [UUID], [CRTIMESTMP], [ABTIMESTMP], [DYTIMESTMP], [FLDCNT], [TABLENGTH], [KEYCNT], [KEYLENGTH], [CLIENTPOS], [TABTYPE], [TABFORM], [REFNAME], [HFLAG], [BUFSTATE], [BUFPARM], [ALIGN], [POINTERLG], [UNICODELG], [COMPCNT], [LEAFCNT] from [DDNTT]
3 ETGCLN Number of original rows: 1034727. Number of copied rows: 1034727.
3 ETGCLN CREATE INDEX [_dta_index_DDNTT_5] ON [DDNTT~] ( [TABFORM] , [TABFORM] , [UNICODELG] , [UNICODELG] , [TABNAME] , [TABFORM] , [REFNAME] ) WITH ( PAD_INDEX = OFF , ONLINE = OFF , DATA_COMPRESSION = NONE );
1EETGCLN Cannot use duplicate column names in index. Column name 'TABFORM' listed more than once.
1EETGCLN DDNTT
1EETGCLN Error when cloning table indexes
...
...
Read more...
Environment
- SAP NetWeaver 7.0 Application Server for ABAP or Higher
- SQL Server 2000 or Higher
Product
Keywords
KBA , BW-SYS-DB-MSS , BW on Microsoft SQL Server , BC-UPG-TLS-TLA , Upgrade tools for ABAP , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview