Symptom
- SUM upgrade struck in SUM phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE.
- From the provided DBCLONE.<SID> log files noticed below errors:
EETGCLN Error copying table data
9 ETGCLN CLONING TABLES FAILED
3 ETGCLN ************(111417)************
4 EPU202X====MARK ANALYZED SECTION==== END OF DBCLONE ================= BEGIN OF DBCLONE ===================
3 ETGCLN ************(111540)************
8 ETGCLN START CLONING TABLES
3 ETGCLN Reading /usr/sap/SID/SUM/abap/mem/TAIATRANS.DAT
3 ETGCLN START TMSCTOK -> TMSCTOK~ 20230618091540
3 ETGCLN Primary key strategy for current table is 0
3 ETGCLN DROP TABLE "TMSCTOK~"
3 ETGCLN CREATE TABLE "TMSCTOK~" ("SYSID" varchar(000024) DEFAULT ' ' NOT NULL , "TOKEN" varchar(000300) DEFAULT ' ' NOT NULL , "MODDAT" varchar(000024) DEFAULT '00000000' NOT NULL , "MODTIM" varchar(000018) DEFAULT '000000' NOT NULL ) WITH compression = PAGE, lob_compression = 100, index_compression = PAGE
3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'SYB' AND TABNAME = 'TMSCTOK~' AND INDEXNAME = ' '
3 ETGCLN CREATE UNIQUE INDEX "TMSCTOK^0" ON "TMSCTOK~" ("SYSID", "TOKEN") WITH index_compression = PAGE
3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'SYB' AND TABNAME = 'TMSCTOK~' AND INDEXNAME = '0'
3 ETGCLN alter table "TMSCTOK~" lock datapages
3 ETGCLN insert into "TMSCTOK~" ( "SYSID", "TOKEN", "MODDAT", "MODTIM" ) select "SYSID", "TOKEN", "MODDAT", "MODTIM" from "TMSCTOK"
3 ETGCLN alter table "TMSCTOK~" lock datarows
3 ETGCLN Number of original rows: 1. Number of copied rows: 0.
1EETGCLN Number of copied rows 0 is smaller than expected 1.
1EETGCLN TMSCTOK
1EETGCLN Error copying table data
9 ETGCLN CLONING TABLES FAILED
3 ETGCLN ************(111619)************
4 EPU202X====MARK ANALYZED SECTION==== END OF DBCLONE ================= BEGIN OF DBCLONE ===================
3 ETGCLN ************(112212)************
8 ETGCLN START CLONING TABLES
3 ETGCLN Reading /usr/sap/SID/SUM/abap/mem/TAIATRANS.DAT
3 ETGCLN START TMSCTOK -> TMSCTOK~ 20230618092212
3 ETGCLN Primary key strategy for current table is 0
3 ETGCLN DROP TABLE "TMSCTOK~"
3 ETGCLN CREATE TABLE "TMSCTOK~" ("SYSID" varchar(000024) DEFAULT ' ' NOT NULL , "TOKEN" varchar(000300) DEFAULT ' ' NOT NULL , "MODDAT" varchar(000024) DEFAULT '00000000' NOT NULL , "MODTIM" varchar(000018) DEFAULT '000000' NOT NULL ) WITH compression = PAGE, lob_compression = 100, index_compression = PAGE
3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'SYB' AND TABNAME = 'TMSCTOK~' AND INDEXNAME = ' '
3 ETGCLN CREATE UNIQUE INDEX "TMSCTOK^0" ON "TMSCTOK~" ("SYSID", "TOKEN") WITH index_compression = PAGE
3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'SYB' AND TABNAME = 'TMSCTOK~' AND INDEXNAME = '0'
3 ETGCLN alter table "TMSCTOK~" lock datapages
3 ETGCLN insert into "TMSCTOK~" ( "SYSID", "TOKEN", "MODDAT", "MODTIM" ) select "SYSID", "TOKEN", "MODDAT", "MODTIM" from "TMSCTOK"
3 ETGCLN alter table "TMSCTOK~" lock datarows
3 ETGCLN Number of original rows: 1. Number of copied rows: 0.
1EETGCLN Number of copied rows 0 is smaller than expected 1.
1EETGCLN TMSCTOK
1EETGCLN Error copying table data
9 ETGCLN CLONING TABLES FAILED
Read more...
Environment
- SAP Adaptive Server Enterprise16.0 SP03 PL11 HF1
- SLES 11.4
Keywords
DBclone, Error copying table data,CLONING TABLES FAILED , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.