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 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.