SAP Knowledge Base Article - Preview

3345953 - SPS upgrade failed with error in SUM phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE - SAP ASE BS

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.