Error During Upgrade from ecc6.0 to ehp7 in phase MAIN_SHDCRE/SUBMOD_SHDDBCLONE/DBCLONE

[Former Member]

Dear all,

Please give me the solution as soon as possible working in down time.

3 ETGCLN VARI : only client 000 will be copied
3 ETGCLN insert into "VARI~" ( "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" ) select "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" from "VARI" WHERE ( "MANDT" = '000' AND "RELID" = 'VB' AND "REPORT" = 'RSICFDLT' AND "VARIANT" >= '&0000000099527' OR "MANDT" = '000' AND "RELID" = 'VB' AND "REPORT" > 'RSICFDLT' OR "MANDT" = '000' AND "RELID" > 'VB' OR "MANDT" > '000' ) AND "MANDT"='000'
3 ETGCLN ALTER TABLE "VARI~" APPEND OFF
3 ETGCLN ALTER TABLE "VARI~" LOCKSIZE ROW
3 ETGCLN Number of original rows: 343383. Number of copied rows: 336038.
1EETGCLN Number of copied rows 336038 is smaller than expected 343383.
1EETGCLN VARI
1EETGCLN Error copying table data

[premsukh_bishnoi]

Hi,

Please attach logs files of SAPupConsole.log and ELG and other logs file to thread.

Regards, Prem

[Former Member]

Dear Prem,

This trouble ticket was created by SAPup on 20150920061001

-------------------------------------------------------------

SAPup broke during phase SUBMOD_SHDDBCLONE/DBCLONE in module MAIN_SHDCRE / Import and Modification Transfer

Error Message: Single errors (code <= 😎 found in logfile 'DBCLONE.ELG'

-------------------------------------------------------------

-------------------------------------------------------------

Summary of SAPup:

-------------------------------------------------------------

SAPehpi Release: lmt_004

SAPehpi Version: SAPup release lmt_004 version 58.000

Start Release: 700

Target Release: 740

-------------------------------------------------------------

Summary of host system details:

-------------------------------------------------------------

SID: PRO

Host: lhpnewprd

MS Host: lhpnewprd

GW Host: lhpnewprd

Start Path: E:\usr\sap\PRO\DVEBMGS00\exe

Kernel Path: E:\usr\sap\PRO\DVEBMGS00\exe

-------------------------------------------------------------

Summary of operating system details:

-------------------------------------------------------------

OS Type: Windows NT X86_64

OS Version: 6.2

-------------------------------------------------------------

Summary of database details:

-------------------------------------------------------------

Database Type: db6

Database Version: 10.05.0003

-------------------------------------------------------------

Summary of RFC details:

-------------------------------------------------------------

Host: lhpnewprd

GW Host: lhpnewprd

Client: 000

Destination: PRO

Language: E

System No.: 00

-------------------------------------------------------------

-------------------------------------------------------------

DBCLONE.ELG

CLONING ERRORS and RETURN CODE in DBCLONE07.PRO

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

3 ETGCLN VARI : only client 000 will be copied

3 ETGCLN insert into "VARI~" (  "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" ) select  "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" from "VARI" WHERE (  "MANDT" = '000' AND  "RELID" = 'VB' AND  "REPORT" = 'RSICFDLT' AND  "VARIANT" >= '&0000000099499'  OR  "MANDT" = '000' AND  "RELID" = 'VB' AND  "REPORT" > 'RSICFDLT'  OR  "MANDT" = '000' AND  "RELID" > 'VB'  OR  "MANDT" > '000' ) AND "MANDT"='000'

3 ETGCLN ALTER TABLE "VARI~" APPEND OFF

3 ETGCLN ALTER TABLE "VARI~" LOCKSIZE ROW

3 ETGCLN Number of original rows: 343431. Number of copied rows: 336086.

1EETGCLN Number of copied rows 336086 is smaller than expected 343431.

1EETGCLN VARI

1EETGCLN Error copying table data

[anandkarthik_raja]

Dear Sagar,

Please attach us the complete SAPupConsole.log

Regards,
Anand.

[former_member182657]

Hi,

Could you share complete error log file for further suggestions.

Regards,

[Former Member]

Thanks for the Urgent reply

ETGCLN START VARI -> VARI~ 20150919065130

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "VARI~" ("MANDT" SAPDB6CHAR(000003) DEFAULT '000' NOT NULL, "RELID" SAPDB6CHAR(000002) DEFAULT ' ' NOT NULL, "REPORT" SAPDB6CHAR(000040) DEFAULT ' ' NOT NULL, "VARIANT" SAPDB6CHAR(000014) DEFAULT ' ' NOT NULL, "SRTF2" INTEGER DEFAULT 0 NOT NULL, "VDATE" SAPDB6CHAR(000008) DEFAULT '00000000' NOT NULL, "VTIME" SAPDB6CHAR(000006) DEFAULT '000000' NOT NULL, "VERNR" SAPDB6CHAR(000006) DEFAULT ' ' NOT NULL, "CLUSTR" SMALLINT DEFAULT 0 NOT NULL, "CLUSTD" SAPDB6RAW(002886) FOR BIT DATA) IN "PRO#POOLD" INDEX IN "PRO#POOLI" LONG IN "PRO#POOLD" COMPRESS YES ADAPTIVE

3 ETGCLN ALTER TABLE "VARI~" LOCKSIZE ROW

3 ETGCLN CREATE UNIQUE INDEX "VARI^0" ON "VARI~" ("MANDT", "RELID", "REPORT", "VARIANT", "SRTF2") COMPRESS YES ALLOW REVERSE SCANS

3 ETGCLN ALTER TABLE "VARI~" ADD CONSTRAINT "VARI^0" PRIMARY KEY ("MANDT", "RELID", "REPORT", "VARIANT", "SRTF2")

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'DB6' AND TABNAME = 'VARI~' AND INDEXNAME = ' '

3 ETGCLN COMMIT

3 ETGCLN ALTER TABLE "VARI~" LOCKSIZE TABLE

3 ETGCLN ALTER TABLE "VARI~" APPEND ON

3 ETGCLN VARI : only client 000 will be copied

3 ETGCLN insert into "VARI~" (  "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" ) select  "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" from "VARI" WHERE  "MANDT" >= '000'  AND (  "MANDT" = '000' AND  "RELID" = 'VA' AND  "REPORT" < 'RSDB6COLL'  OR  "MANDT" = '000' AND  "RELID" < 'VA' ) AND "MANDT"='000'

3 ETGCLN VARI : only client 000 will be copied

3 ETGCLN insert into "VARI~" (  "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" ) select  "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" from "VARI" WHERE  "MANDT" = '000' AND  "RELID" = 'VA' AND  "REPORT" >= 'RSDB6COLL'  AND (  "MANDT" = '000' AND  "RELID" = 'VA' AND  "REPORT" = 'RSDB6COLL' AND  "VARIANT" < '&0000000093832' ) AND "MANDT"='000'

3 ETGCLN VARI : only client 000 will be copied

3 ETGCLN insert into "VARI~" (  "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" ) select  "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" from "VARI" WHERE (  "MANDT" = '000' AND  "RELID" = 'VA' AND  "REPORT" = 'RSDB6COLL' AND  "VARIANT" >= '&0000000093832'  OR  "RELID" = 'VA' AND  "REPORT" > 'RSDB6COLL'  OR  "RELID" > 'VA' )  AND  "MANDT" = '000' AND  "RELID" < 'VB' AND "MANDT"='000'

3 ETGCLN VARI : only client 000 will be copied

3 ETGCLN insert into "VARI~" (  "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" ) select  "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" from "VARI" WHERE  "MANDT" = '000' AND  "RELID" >= 'VB'  AND (  "MANDT" = '000' AND  "RELID" = 'VB' AND  "REPORT" = 'RSDB6COLL' AND  "VARIANT" < '&0000000090775'  OR  "RELID" = 'VB' AND  "REPORT" < 'RSDB6COLL' ) AND "MANDT"='000'

3 ETGCLN VARI : only client 000 will be copied

3 ETGCLN insert into "VARI~" (  "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" ) select  "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" from "VARI" WHERE (  "MANDT" = '000' AND  "RELID" = 'VB' AND  "REPORT" = 'RSDB6COLL' AND  "VARIANT" >= '&0000000090775'  OR  "REPORT" > 'RSDB6COLL' )  AND  "MANDT" = '000' AND  "RELID" = 'VB' AND  "REPORT" < 'RSICFDLT' AND "MANDT"='000'

3 ETGCLN VARI : only client 000 will be copied

3 ETGCLN insert into "VARI~" (  "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" ) select  "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" from "VARI" WHERE  "MANDT" = '000' AND  "RELID" = 'VB' AND  "REPORT" >= 'RSICFDLT'  AND (  "MANDT" = '000' AND  "RELID" = 'VB' AND  "REPORT" = 'RSICFDLT' AND  "VARIANT" < '&0000000099527' ) AND "MANDT"='000'

3 ETGCLN VARI : only client 000 will be copied

3 ETGCLN insert into "VARI~" (  "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" ) select  "MANDT", "RELID", "REPORT", "VARIANT", "SRTF2", "VDATE", "VTIME", "VERNR", "CLUSTR", "CLUSTD" from "VARI" WHERE (  "MANDT" = '000' AND  "RELID" = 'VB' AND  "REPORT" = 'RSICFDLT' AND  "VARIANT" >= '&0000000099527'  OR  "MANDT" = '000' AND  "RELID" = 'VB' AND  "REPORT" > 'RSICFDLT'  OR  "MANDT" = '000' AND  "RELID" > 'VB'  OR  "MANDT" > '000' ) AND "MANDT"='000'

3 ETGCLN ALTER TABLE "VARI~" APPEND OFF

3 ETGCLN ALTER TABLE "VARI~" LOCKSIZE ROW

3 ETGCLN Number of original rows: 343383. Number of copied rows: 336038.

1EETGCLN Number of copied rows 336038 is smaller than expected 343383.

1EETGCLN VARI

1EETGCLN Error copying table data

3 ETGCLN START VARICONCI -> VARICONCI~ 20150919065155

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN CREATE TABLE "VARICONCI~" ("REPORT" SAPDB6CHAR(000040) DEFAULT ' ' NOT NULL, "SVARIANT" SAPDB6CHAR(000014) DEFAULT ' ' NOT NULL, "FIELDNAME" SAPDB6CHAR(000008) DEFAULT ' ' NOT NULL, "FTABNAME" SAPDB6CHAR(000030) DEFAULT ' ' NOT NULL, "FINDEX" SAPDB6CHAR(000004) DEFAULT '0000' NOT NULL, "SPATTERN" SAPDB6CHAR(000001) DEFAULT ' ' NOT NULL, "FROM_INDX" INTEGER DEFAULT 0 NOT NULL, "TO_INDX" INTEGER DEFAULT 0 NOT NULL, "SIGN" SAPDB6CHAR(000001) DEFAULT ' ' NOT NULL, "OPTI" SAPDB6CHAR(000002) DEFAULT ' ' NOT NULL, "LOW" SAPDB6CHAR(000132) DEFAULT ' ' NOT NULL, "HIGH" SAPDB6CHAR(000132) DEFAULT ' ' NOT NULL, "DSLOGOP" SAPDB6CHAR(000003) DEFAULT ' ' NOT NULL, "DSARITY" INTEGER DEFAULT 0 NOT NULL) IN "PRO#POOLD" INDEX IN "PRO#POOLI" LONG IN "PRO#POOLD" COMPRESS YES ADAPTIVE

3 ETGCLN ALTER TABLE "VARICONCI~" LOCKSIZE ROW

3 ETGCLN CREATE UNIQUE INDEX "VARICONCI^0" ON "VARICONCI~" ("REPORT", "SVARIANT", "FIELDNAME", "FTABNAME", "FINDEX", "SPATTERN") COMPRESS YES ALLOW REVERSE SCANS

3 ETGCLN ALTER TABLE "VARICONCI~" ADD CONSTRAINT "VARICONCI^0" PRIMARY KEY ("REPORT", "SVARIANT", "FIELDNAME", "FTABNAME", "FINDEX", "SPATTERN")

3 ETGCLN DELETE FROM DDSTORAGE WHERE DBSYSABBR = 'DB6' AND TABNAME = 'VARICONCI~' AND INDEXNAME = ' '

3 ETGCLN COMMIT