Symptom
During an upgrade using the SUM tool with DMO, it stops in phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE with following error:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ CLONING ERRORS and RETURN CODE in DBCLONE07.<SID>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'DB02_COLL_LOG~' AND INDEXNAME = ' '
3 ETGCLN CREATE UNIQUE INDEX "DB02_COLL_LOG^0" ON "DB02_COLL_LOG~" ("COLL_DATE", "COLL_TIME", "CON_NAME", "SMON_ID") PCTFREE 10 INITRANS 002
TABLESPACE PSAPSR3 STORAGE (INITIAL 0000000016 K NEXT 0000000040 K MINEXTENTS 0000000001 MAXEXTENTS UNLIMITED PCTINCREASE 0000 FREELISTS 001)
3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'ORA' AND TABNAME = 'DB02_COLL_LOG~' AND INDEXNAME = '0'
3 ETGCLN insert /*+APPEND */ into "DB02_COLL_LOG~" ( "COLL_DATE", "COLL_TIME", "CON_NAME", "SMON_ID", "SMON_NAME", "MONIFILL", "RCODE", "UPLOAD", "DURATION" )
select /*+PARALLEL( DB02_COLL_LOG )*/ "COLL_DATE", "COLL_TIME", "CON_NAME", "SMON_ID", "SMON_NAME", "MONIFILL", "RCODE", "UPLOAD", "DURATION" from "DB02_COLL_LOG"
3 ETGCLN Number of original rows: 11796. Number of copied rows: 11721. 1EETGCLN Number of copied rows 11721 is smaller than expected 11796.
1EETGCLN DB02_COLL_LOG 1EETGCLN Error copying table data
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ CLONING ERRORS and RETURN CODE in DBCLONE07.<SID>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Read more...
Environment
Update of Netweaver based ABAP system
Scenario 1: Database is Oracle
Scenario 2: Database is HANA
Product
Keywords
DBCLONE, Number of original rows, is smaller than expected, Error copying table data , KBA , 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.
SAP Knowledge Base Article - Preview