Skip to Content
avatar image
Former Member

Error during DBCLONE in Preprocessing Phase

Hi Experts,

During Patch upgrade through SUM we are facing the below error in DBclone phase.

so please assist us.

===================================================================================================

  

ERROR:

Detected the following errors:

# /usr/sap/SUM/SUM/abap/log/DBCLONE02.CEI:

3 ETGCLN START REPOSRC -> REPOSRC~ 20151019120319

3 ETGCLN Primary key strategy for current table is 0

3 ETGCLN DROP TABLE "REPOSRC~"

3 ETGCLN CREATE COLUMN TABLE "REPOSRC~" ("PROGNAME" NVARCHAR (000040) DEFAULT '' NOT NULL, "R3STATE" NVARCHAR (000001) DEFAULT '' NOT NULL, "SQLX" NVARCHAR (000001) DEFAULT '' NOT NULL, "EDTX" NVARCHAR (000001) DEFAULT '' NOT NULL, "DBNA" NVARCHAR (000002) DEFAULT '' NOT NULL, "CLAS" NVARCHAR (000004) DEFAULT '' NOT NULL, "TYPE" NVARCHAR (000003) DEFAULT '' NOT NULL, "OCCURS" NVARCHAR (000001) DEFAULT '' NOT NULL, "SUBC" NVARCHAR (000001) DEFAULT '' NOT NULL, "APPL" NVARCHAR (000001) DEFAULT '' NOT NULL, "SECU" NVARCHAR (000008) DEFAULT '' NOT NULL, "CNAM" NVARCHAR (000012) DEFAULT '' NOT NULL, "CDAT" NVARCHAR (000008) DEFAULT '00000000' NOT NULL, "VERN" NVARCHAR (000006) DEFAULT '' NOT NULL, "LEVL" NVARCHAR (000004) DEFAULT '' NOT NULL, "RSTAT" NVARCHAR (000001) DEFAULT '' NOT NULL, "RMAND" NVARCHAR (000003) DEFAULT '' NOT NULL, "RLOAD" NVARCHAR (000001) DEFAULT '' NOT NULL, "UNAM" NVARCHAR (000012) DEFAULT '' NOT NULL, "UDAT" NVARCHAR (000008) DEFAULT '00000000' NOT NULL, "UTIME" NVARCHAR (000006) DEFAULT '000000' NOT NULL, "DATALG" INTEGER DEFAULT 0 NOT NULL, "VARCL" NVARCHAR (000001) DEFAULT '' NOT NULL, "DBAPL" NVARCHAR (000001) DEFAULT '' NOT NULL, "FIXPT" NVARCHAR (000001) DEFAULT '' NOT NULL, "SSET" NVARCHAR (000001) DEFAULT '' NOT NULL, "SDATE" NVARCHAR (000008) DEFAULT '00000000' NOT NULL, "STIME" NVARCHAR (000006) DEFAULT '' NOT NULL, "IDATE" NVARCHAR (000008) DEFAULT '00000000' NOT NULL, "ITIME" NVARCHAR (000006) DEFAULT '' NOT NULL, "LDBNAME" NVARCHAR (000020) DEFAULT '' NOT NULL, "UCCHECK" NVARCHAR (000001) DEFAULT '' NOT NULL, "MAXLINELN" SMALLINT DEFAULT 0 NOT NULL, "DATA" BLOB , PRIMARY KEY ("PROGNAME", "R3STATE") ) UNLOAD PRIORITY 5 WITH PARAMETERS( 'EXTKEY_VID_COMPRESSED'= 'OFF' ) 3 ETGCLN insert into "REPOSRC~" ( "PROGNAME", "R3STATE", "SQLX", "EDTX", "DBNA", "CLAS", "TYPE", "OCCURS", "SUBC", "APPL", "SECU", "CNAM", "CDAT", "VERN", "LEVL", "RSTAT", "RMAND", "RLOAD", "UNAM", "UDAT", "UTIME", "DATALG", "VARCL", "DBAPL", "FIXPT", "SSET", "SDATE", "STIME", "IDATE", "ITIME", "LDBNAME", "UCCHECK", "MAXLINELN", "DATA" ) select "PROGNAME", "R3STATE", "SQLX", "EDTX", "DBNA", "CLAS", "TYPE", "OCCURS", "SUBC", "APPL", "SECU", "CNAM", "CDAT", "VERN", "LEVL", "RSTAT", "RMAND", "RLOAD", "UNAM", "UDAT", "UTIME", "DATALG", "VARCL", "DBAPL", "FIXPT", "SSET", "SDATE", "STIME", "IDATE", "ITIME", "LDBNAME", "UCCHECK", "MAXLINELN", "DATA" from "REPOSRC" 1EETGCLN transaction rolled back by an internal error:

exception 1000002: Allocation failed ; $size$=13623056; $name$=itab; $type$=pool; $inuse_count$=1951; $allocated_size$=277051736

exception 1000002: Allocation failed ; $size$=13623056; $name$=itab; $type$=pool; $inuse_count$=1951; $allocated_size$=277051736

exception 1000002: Allocation failed ; $size$=13623056; $name$=itab; $type$=pool; $inuse_count$=1951; $allocated_size$=277051736

exception 1000002: Allocation failed ; $size$=13623056; $name$=itab; $type$=pool; $inuse_count$=1951; $allocated_size$=277051736

exception 1000002: Allocation failed ; $size$=13623056; $name$=itab; $type$=pool; $inuse_count$=1951; $allocated_size$=277051736

exception 1000002: Allocation failed ; $size$=13623056; $name$=itab; $type$=pool; $inuse_count$=1951; $allocated_size$=277051736

exception 1000002: Allocation failed ; $size$=13623056; $name$=itab; $type$=pool; $inuse_count$=1951; $allocated_size$=277051736

exception 1000002: Allocation failed ; $size$=13623 1EETGCLN REPOSRC


...skipped 15 more lines.

Please see DBCLONE.html for more information.

Trouble Ticket Generation


A trouble ticket and an archive with all relevant log files have been generated.

Trouble ticket: "/usr/sap/SUM/SUM/abap/log/SAPup_troubleticket.log"

Log archive: "/usr/sap/SUM/SUM/abap/log/SAPup_troubleticket_logs.sar"

=====================================================================================================

System details:

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

NW 7.4

DB - HANA (1.00.094.00.1427101515)

Many Thanks!!
Mpeter

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 20, 2015 at 06:28 AM

    Hi Peter,

    What is your HANA memory size? Maybe the memory size is too small.

    Regards,

    Ning Tong

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2015 at 02:51 PM

    Please see DBCLONE.html for more information.

    Did you?... if so, can you post the errors?

    Regards, Juan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Juan,

      please find the attached DBCLONE.HTML file also it details below.

      ==========================================================================================================

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

      CLONING ERRORS and RETURN CODE in DBCLONE02.CEI

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

      3 ETGCLN START REPOSRC -> REPOSRC~ 20151019101705

      3 ETGCLN Primary key strategy for current table is 0

      3 ETGCLN DROP TABLE "REPOSRC~"

      3 ETGCLN CREATE COLUMN TABLE "REPOSRC~" ("PROGNAME" NVARCHAR (000040) DEFAULT '' NOT NULL, "R3STATE" NVARCHAR (000001) DEFAULT '' NOT NULL, "SQLX" NVARCHAR (000001) DEFAULT '' NOT NULL, "EDTX" NVARCHAR (000001) DEFAULT '' NOT NULL, "DBNA" NVARCHAR (000002) DEFAULT '' NOT NULL, "CLAS" NVARCHAR (000004) DEFAULT '' NOT NULL, "TYPE" NVARCHAR (000003) DEFAULT '' NOT NULL, "OCCURS" NVARCHAR (000001) DEFAULT '' NOT NULL, "SUBC" NVARCHAR (000001) DEFAULT '' NOT NULL, "APPL" NVARCHAR (000001) DEFAULT '' NOT NULL, "SECU" NVARCHAR (000008) DEFAULT '' NOT NULL, "CNAM" NVARCHAR (000012) DEFAULT '' NOT NULL, "CDAT" NVARCHAR (000008) DEFAULT '00000000' NOT NULL, "VERN" NVARCHAR (000006) DEFAULT '' NOT NULL, "LEVL" NVARCHAR (000004) DEFAULT '' NOT NULL, "RSTAT" NVARCHAR (000001) DEFAULT '' NOT NULL, "RMAND" NVARCHAR (000003) DEFAULT '' NOT NULL, "RLOAD" NVARCHAR (000001) DEFAULT '' NOT NULL, "UNAM" NVARCHAR (000012) DEFAULT '' NOT NULL, "UDAT" NVARCHAR (000008) DEFAULT '00000000' NOT NULL, "UTIME" NVARCHAR (000006) DEFAULT '000000' NOT NULL, "DATALG" INTEGER DEFAULT 0 NOT NULL, "VARCL" NVARCHAR (000001) DEFAULT '' NOT NULL, "DBAPL" NVARCHAR (000001) DEFAULT '' NOT NULL, "FIXPT" NVARCHAR (000001) DEFAULT '' NOT NULL, "SSET" NVARCHAR (000001) DEFAULT '' NOT NULL, "SDATE" NVARCHAR (000008) DEFAULT '00000000' NOT NULL, "STIME" NVARCHAR (000006) DEFAULT '' NOT NULL, "IDATE" NVARCHAR (000008) DEFAULT '00000000' NOT NULL, "ITIME" NVARCHAR (000006) DEFAULT '' NOT NULL, "LDBNAME" NVARCHAR (000020) DEFAULT '' NOT NULL, "UCCHECK" NVARCHAR (000001) DEFAULT '' NOT NULL, "MAXLINELN" SMALLINT DEFAULT 0 NOT NULL, "DATA" BLOB , PRIMARY KEY ("PROGNAME", "R3STATE") ) UNLOAD PRIORITY 5 WITH PARAMETERS( 'EXTKEY_VID_COMPRESSED'= 'OFF' )

      3 ETGCLN insert into "REPOSRC~" ( "PROGNAME", "R3STATE", "SQLX", "EDTX", "DBNA", "CLAS", "TYPE", "OCCURS", "SUBC", "APPL", "SECU", "CNAM", "CDAT", "VERN", "LEVL", "RSTAT", "RMAND", "RLOAD", "UNAM", "UDAT", "UTIME", "DATALG", "VARCL", "DBAPL", "FIXPT", "SSET", "SDATE", "STIME", "IDATE", "ITIME", "LDBNAME", "UCCHECK", "MAXLINELN", "DATA" ) select "PROGNAME", "R3STATE", "SQLX", "EDTX", "DBNA", "CLAS", "TYPE", "OCCURS", "SUBC", "APPL", "SECU", "CNAM", "CDAT", "VERN", "LEVL", "RSTAT", "RMAND", "RLOAD", "UNAM", "UDAT", "UTIME", "DATALG", "VARCL", "DBAPL", "FIXPT", "SSET", "SDATE", "STIME", "IDATE", "ITIME", "LDBNAME", "UCCHECK", "MAXLINELN", "DATA" from "REPOSRC"

      1EETGCLN transaction rolled back by an internal error: exception 1000002: Allocation failed ; $size$=65536; $name$=itab; $type$=pool; $inuse_count$=4127; $allocated_size$=781443746

      exception 1000002: Allocation failed ; $size$=65536; $name$=itab; $type$=pool; $inuse_count$=4127; $allocated_size$=781443746

      exception 1000002: Allocation failed ; $size$=65536; $name$=itab; $type$=pool; $inuse_count$=4127; $allocated_size$=781443746

      exception 1000002: Allocation failed ; $size$=65536; $name$=itab; $type$=pool; $inuse_count$=4127; $allocated_size$=781443746

      exception 1000002: Allocation failed ; $size$=65536; $name$=itab; $type$=pool; $inuse_count$=4127; $allocated_size$=781443746

      exception 1000002: Allocation failed ; $size$=65536; $name$=itab; $type$=pool; $inuse_count$=4127; $allocated_size$=781443746

      exception 1000002: Allocation failed ; $size$=65536; $name$=itab; $type$=pool; $inuse_count$=4127; $allocated_size$=781443746

      exception 1000002: Allocation failed ; $size$=65536; $name$=itab; $type$

      1EETGCLN REPOSRC

      1EETGCLN Error copying table data

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

      CLONING ERRORS and RETURN CODE in DBCLONE03.CEI

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

      3 ETGCLN START TFO04 -> TFO04~ 20151019101705

      3 ETGCLN Primary key strategy for current table is 0

      3 ETGCLN DROP TABLE "TFO04~"

      3 ETGCLN CREATE COLUMN TABLE "TFO04~" ("TDPRINTER" NVARCHAR (000008) DEFAULT '' NOT NULL, "TDFAMILY" NVARCHAR (000008) DEFAULT '' NOT NULL, "TDFONTSIZE" NVARCHAR (000003) DEFAULT '000' NOT NULL, "TDBOLD" NVARCHAR (000001) DEFAULT '' NOT NULL, "TDITALIC" NVARCHAR (000001) DEFAULT '' NOT NULL, "TDLINENO" NVARCHAR (000003) DEFAULT '000' NOT NULL, "TDAFMLINE" NVARCHAR (000072) DEFAULT '' NOT NULL , PRIMARY KEY ("TDPRINTER", "TDFAMILY", "TDFONTSIZE", "TDBOLD", "TDITALIC", "TDLINENO") ) UNLOAD PRIORITY 5 WITH PARAMETERS( 'EXTKEY_VID_COMPRESSED'= 'OFF' )

      3 ETGCLN insert into "TFO04~" ( "TDPRINTER", "TDFAMILY", "TDFONTSIZE", "TDBOLD", "TDITALIC", "TDLINENO", "TDAFMLINE" ) select "TDPRINTER", "TDFAMILY", "TDFONTSIZE", "TDBOLD", "TDITALIC", "TDLINENO", "TDAFMLINE" from "TFO04"

      1EETGCLN transaction rolled back by an internal error: exception 1000002: Allocation failed ; $size$=15067192; $name$=itab; $type$=pool; $inuse_count$=4127; $allocated_size$=781443746

      exception 1000002: Allocation failed ; $size$=15067192; $name$=itab; $type$=pool; $inuse_count$=4127; $allocated_size$=781443746

      exception 1000002: Allocation failed ; $size$=15067192; $name$=itab; $type$=pool; $inuse_count$=4127; $allocated_size$=781443746

      exception 1000002: Allocation failed ; $size$=65536; $name$=itab; $type$=pool; $inuse_count$=4127; $allocated_size$=781443746

      exception 1000002: Allocation failed ; $size$=65536; $name$=itab; $type$=pool; $inuse_count$=4127; $allocated_size$=781443746

      1EETGCLN TFO04

      1EETGCLN Error copying table data

      =============================================================================================================

      Regards,

      MPeter