Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 19, 2015 at 07:25 AM

    Hi,

    Could you share complete error log file for further suggestions.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Sep 19, 2015 at 09:22 PM

    Hi,

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

    Regards, Prem

    Add comment
    10|10000 characters needed characters exceeded