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.
SAP Knowledge Base Article - Preview