SAP Knowledge Base Article - Preview

2278201 - DBCLONE* phase: Cannot use duplicate column names in index

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

SAP ERP 6.0

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.