Error during DBCLONE in Preprocessing Phase

[Former Member]

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

[former_member182967 · Accepted solution]

Hi Peter,

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

Regards,

Ning Tong

[Former Member · Accepted solution]

Thanks Ning,

Please find the memory details as below.

SAP HANA Used Memory

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

Used Memory     : 48.44 GB

Peak Used Mem : 49.87 GB

Allocation Limit   : 60:00 GB

Regards,

MPeter

[former_member182967 · Accepted solution]

Hi Peter,

Can you add more memory to HANA host and try again (for example, increase to 96GB)?

Regards,

Ning

[Former Member · Accepted solution]

Hi Ning,

Thanks for the expert advice.

i have increase the memory to 90 GB and it works.

Regards,

MPeter

[JPReyes]

Please see DBCLONE.html for more information.

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

Regards, Juan

[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