cancel
Showing results for 
Search instead for 
Did you mean: 

Error in ABAP Import Phase - 3 jobs failed

Former Member
0 Kudos

Hi,

My installation of ECC IDES has failed in ABAP Import phase.

3 jobs has failed.

I figured out from the logs that there are 3 loads that has failed.

Failed loads are SAPPOOL, SAP0000 and SAPSLEXC.

The prominant error in them are as below. Please assist to relsove

these errors.

SAPPOOL.log

(DB) ERROR: DDL statement failed with SQL error

( CREATE TABLE "DVPOOLTEXT" ( "TABNAME" SAPDB6CHAR(10) DEFAULT ' ' NOT

NULL , "VARKEY" SAPDB6CHAR(110) DEFAULT ' ' NOT NULL , "DATALN"

SMALLINT DEFAULT 0 NOT NULL , "VARDATA" VARCHAR(16384) FOR BIT DATA )

IN DGS#POOLD INDEX IN DGS#POOLI LONG IN DGS#POOLD )

(SQL error -670)

error message returned by dsql:

SQL0670N The row length of the table exceeded a limit of "16293"

bytes. (Table space "DGS#POOLD".) SQLSTATE=54010

(DB) INFO: disconnected from DB

SAP0000.log

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( CREATE TABLE "REPOLOAD" ( "PROGNAME" SAPDB6CHAR(40) DEFAULT ' ' NOT

NULL , "R3STATE" SAPDB6FIXCHAR(1) DEFAULT ' ' NOT NULL , "MACH"

SMALLINT DEFAULT 0 NOT NULL , "UNAM" SAPDB6CHAR(12) DEFAULT ' ' NOT

NULL , "UDAT" SAPDB6CHAR(8) DEFAULT '00000000' NOT NULL , "UTIME"

SAPDB6CHAR(6) DEFAULT '000000' NOT NULL , "L_DATALG" INTEGER DEFAULT 0

NOT NULL , "Q_DATALG" INTEGER DEFAULT 0 NOT NULL , "SDAT" SAPDB6CHAR(8)

DEFAULT '00000000' NOT NULL , "STIME" SAPDB6CHAR(6) DEFAULT '000000'

NOT NULL , "MINOR_VERS" SMALLINT DEFAULT 0 NOT NULL , "MAJOR_VERS"

INTEGER DEFAULT 0 NOT NULL , "LDATA" BLOB(1G)LOGGED , "QDATA" BLOB(1G)

LOGGED ) IN DGS#EL700D INDEX IN DGS#EL700I LONG IN DGS#EL700D )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

SAPSLEXC.log

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( CREATE TABLE "CO2MAP" ( "ID" INTEGER DEFAULT 0 NOT NULL , "SRCLINE"

INTEGER DEFAULT 0 NOT NULL , "PAGELINE" INTEGER DEFAULT 0 NOT

NULL , "IDINCL" INTEGER DEFAULT 0 NOT NULL , "SRCOFF" SMALLINT DEFAULT

0 NOT NULL , "PAGEOFF" SMALLINT DEFAULT 0 NOT NULL ) IN DGS#EL700D

INDEX IN DGS#EL700I LONG IN DGS#EL700D )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

Thanks and Regards,

Hussian Sehorewala

Edited by: Hussain Sehorewala on May 5, 2011 1:28 PM

Accepted Solutions (1)

Accepted Solutions (1)

former_member185031
Active Contributor
0 Kudos

Check this Sap Note 1099936 - DB6: SQL0670N The row length of a table exceeds 4005

Regards,

Subhash

Answers (1)

Answers (1)

Former Member
0 Kudos

I found 3 errors in import_monitor.log

Find them below.

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

ERROR: 2011-05-05 11:38:15 com.sap.inst.migmon.LoadTask run

Loading of 'SAPSLEXC' import package is interrupted with R3load error.

Process 'Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSLEXC.cmd -

dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAPSLEXC.log -

stop_on_error -loadprocedure fast LOAD' exited with return code 2.

For mode details see 'SAPSLEXC.log' file.

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

ERROR: 2011-05-05 11:38:15 com.sap.inst.migmon.LoadTask run

Loading of 'SAPPOOL' import package is interrupted with R3load error.

Process 'Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPPOOL.cmd -

dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAPPOOL.log -

stop_on_error -loadprocedure fast LOAD' exited with return code 2.

For mode details see 'SAPPOOL.log' file.

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

ERROR: 2011-05-05 11:38:15 com.sap.inst.migmon.LoadTask run

Loading of 'SAPSSEXC' import package is interrupted with R3load error.

Process 'Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSSEXC.cmd -

dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAPSSEXC.log -

stop_on_error -loadprocedure fast LOAD' exited with return code 2.

For mode details see 'SAPSSEXC.log' file.

Standard error output:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

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

Thanks and Regards,

Hussian Sehorewala

sivakumar_kilari3
Active Contributor
0 Kudos

Hi,

Can you paste these SAPPOOL.log, SAP0000.log and SAPSLEXC.log files

Thanks

Siva

Former Member
0 Kudos

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110504190548

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -ctf I Q:\1000082149\1\ABAP\DATA\SAPSLEXC.STR C:\Program Files\sapinst_instdir\CRM70\LM\COPY\DB6\SYSTEM\CENTRAL\AS-ABAP\DDLDB6.TPL SAPSLEXC.TSK DB6 -l SAPSLEXC.log

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job completed

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110504190548

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110504190548

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSLEXC.cmd -dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAPSLEXC.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( CREATE TABLE "CO2MAP" ( "ID" INTEGER DEFAULT 0 NOT NULL , "SRCLINE" INTEGER DEFAULT 0 NOT NULL , "PAGELINE" INTEGER DEFAULT 0 NOT NULL , "IDINCL" INTEGER DEFAULT 0 NOT NULL , "SRCOFF" SMALLINT DEFAULT 0 NOT NULL , "PAGEOFF" SMALLINT DEFAULT 0 NOT NULL ) IN DGS#EL700D INDEX IN DGS#EL700I LONG IN DGS#EL700D )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110504190549

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110505112616

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSLEXC.cmd -dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAPSLEXC.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( DROP TABLE "CO2MAP" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

( CREATE TABLE "CO2MAP" ( "ID" INTEGER DEFAULT 0 NOT NULL , "SRCLINE" INTEGER DEFAULT 0 NOT NULL , "PAGELINE" INTEGER DEFAULT 0 NOT NULL , "IDINCL" INTEGER DEFAULT 0 NOT NULL , "SRCOFF" SMALLINT DEFAULT 0 NOT NULL , "PAGEOFF" SMALLINT DEFAULT 0 NOT NULL ) IN DGS#EL700D INDEX IN DGS#EL700I LONG IN DGS#EL700D )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110505112617

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110505113814

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSLEXC.cmd -dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAPSLEXC.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( DROP TABLE "CO2MAP" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

( CREATE TABLE "CO2MAP" ( "ID" INTEGER DEFAULT 0 NOT NULL , "SRCLINE" INTEGER DEFAULT 0 NOT NULL , "PAGELINE" INTEGER DEFAULT 0 NOT NULL , "IDINCL" INTEGER DEFAULT 0 NOT NULL , "SRCOFF" SMALLINT DEFAULT 0 NOT NULL , "PAGEOFF" SMALLINT DEFAULT 0 NOT NULL ) IN DGS#EL700D INDEX IN DGS#EL700I LONG IN DGS#EL700D )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110505113815

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110505114629

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSLEXC.cmd -dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAPSLEXC.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( DROP TABLE "CO2MAP" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

( CREATE TABLE "CO2MAP" ( "ID" INTEGER DEFAULT 0 NOT NULL , "SRCLINE" INTEGER DEFAULT 0 NOT NULL , "PAGELINE" INTEGER DEFAULT 0 NOT NULL , "IDINCL" INTEGER DEFAULT 0 NOT NULL , "SRCOFF" SMALLINT DEFAULT 0 NOT NULL , "PAGEOFF" SMALLINT DEFAULT 0 NOT NULL ) IN DGS#EL700D INDEX IN DGS#EL700I LONG IN DGS#EL700D )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110505114629

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110505120819

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPSLEXC.cmd -dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAPSLEXC.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( DROP TABLE "CO2MAP" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

( CREATE TABLE "CO2MAP" ( "ID" INTEGER DEFAULT 0 NOT NULL , "SRCLINE" INTEGER DEFAULT 0 NOT NULL , "PAGELINE" INTEGER DEFAULT 0 NOT NULL , "IDINCL" INTEGER DEFAULT 0 NOT NULL , "SRCOFF" SMALLINT DEFAULT 0 NOT NULL , "PAGEOFF" SMALLINT DEFAULT 0 NOT NULL ) IN DGS#EL700D INDEX IN DGS#EL700I LONG IN DGS#EL700D )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110505120819

Former Member
0 Kudos

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110504191048

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -ctf I Q:\1000082149\1\ABAP\DATA\SAP0000.STR C:\Program Files\sapinst_instdir\CRM70\LM\COPY\DB6\SYSTEM\CENTRAL\AS-ABAP\DDLDB6.TPL SAP0000.TSK DB6 -l SAP0000.log -o D

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job completed

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110504191048

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110504191048

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAP0000.cmd -dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAP0000.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( CREATE TABLE "REPOLOAD" ( "PROGNAME" SAPDB6CHAR(40) DEFAULT ' ' NOT NULL , "R3STATE" SAPDB6FIXCHAR(1) DEFAULT ' ' NOT NULL , "MACH" SMALLINT DEFAULT 0 NOT NULL , "UNAM" SAPDB6CHAR(12) DEFAULT ' ' NOT NULL , "UDAT" SAPDB6CHAR(8) DEFAULT '00000000' NOT NULL , "UTIME" SAPDB6CHAR(6) DEFAULT '000000' NOT NULL , "L_DATALG" INTEGER DEFAULT 0 NOT NULL , "Q_DATALG" INTEGER DEFAULT 0 NOT NULL , "SDAT" SAPDB6CHAR(8) DEFAULT '00000000' NOT NULL , "STIME" SAPDB6CHAR(6) DEFAULT '000000' NOT NULL , "MINOR_VERS" SMALLINT DEFAULT 0 NOT NULL , "MAJOR_VERS" INTEGER DEFAULT 0 NOT NULL , "LDATA" BLOB(1G)LOGGED , "QDATA" BLOB(1G)LOGGED ) IN DGS#EL700D INDEX IN DGS#EL700I LONG IN DGS#EL700D )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110504191048

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110505112646

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAP0000.cmd -dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAP0000.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( DROP TABLE "REPOLOAD" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

( CREATE TABLE "REPOLOAD" ( "PROGNAME" SAPDB6CHAR(40) DEFAULT ' ' NOT NULL , "R3STATE" SAPDB6FIXCHAR(1) DEFAULT ' ' NOT NULL , "MACH" SMALLINT DEFAULT 0 NOT NULL , "UNAM" SAPDB6CHAR(12) DEFAULT ' ' NOT NULL , "UDAT" SAPDB6CHAR(8) DEFAULT '00000000' NOT NULL , "UTIME" SAPDB6CHAR(6) DEFAULT '000000' NOT NULL , "L_DATALG" INTEGER DEFAULT 0 NOT NULL , "Q_DATALG" INTEGER DEFAULT 0 NOT NULL , "SDAT" SAPDB6CHAR(8) DEFAULT '00000000' NOT NULL , "STIME" SAPDB6CHAR(6) DEFAULT '000000' NOT NULL , "MINOR_VERS" SMALLINT DEFAULT 0 NOT NULL , "MAJOR_VERS" INTEGER DEFAULT 0 NOT NULL , "LDATA" BLOB(1G)LOGGED , "QDATA" BLOB(1G)LOGGED ) IN DGS#EL700D INDEX IN DGS#EL700I LONG IN DGS#EL700D )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110505112646

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110505113844

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAP0000.cmd -dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAP0000.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( DROP TABLE "REPOLOAD" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

( CREATE TABLE "REPOLOAD" ( "PROGNAME" SAPDB6CHAR(40) DEFAULT ' ' NOT NULL , "R3STATE" SAPDB6FIXCHAR(1) DEFAULT ' ' NOT NULL , "MACH" SMALLINT DEFAULT 0 NOT NULL , "UNAM" SAPDB6CHAR(12) DEFAULT ' ' NOT NULL , "UDAT" SAPDB6CHAR(8) DEFAULT '00000000' NOT NULL , "UTIME" SAPDB6CHAR(6) DEFAULT '000000' NOT NULL , "L_DATALG" INTEGER DEFAULT 0 NOT NULL , "Q_DATALG" INTEGER DEFAULT 0 NOT NULL , "SDAT" SAPDB6CHAR(8) DEFAULT '00000000' NOT NULL , "STIME" SAPDB6CHAR(6) DEFAULT '000000' NOT NULL , "MINOR_VERS" SMALLINT DEFAULT 0 NOT NULL , "MAJOR_VERS" INTEGER DEFAULT 0 NOT NULL , "LDATA" BLOB(1G)LOGGED , "QDATA" BLOB(1G)LOGGED ) IN DGS#EL700D INDEX IN DGS#EL700I LONG IN DGS#EL700D )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110505113844

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110505114659

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAP0000.cmd -dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAP0000.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( DROP TABLE "REPOLOAD" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

( CREATE TABLE "REPOLOAD" ( "PROGNAME" SAPDB6CHAR(40) DEFAULT ' ' NOT NULL , "R3STATE" SAPDB6FIXCHAR(1) DEFAULT ' ' NOT NULL , "MACH" SMALLINT DEFAULT 0 NOT NULL , "UNAM" SAPDB6CHAR(12) DEFAULT ' ' NOT NULL , "UDAT" SAPDB6CHAR(8) DEFAULT '00000000' NOT NULL , "UTIME" SAPDB6CHAR(6) DEFAULT '000000' NOT NULL , "L_DATALG" INTEGER DEFAULT 0 NOT NULL , "Q_DATALG" INTEGER DEFAULT 0 NOT NULL , "SDAT" SAPDB6CHAR(8) DEFAULT '00000000' NOT NULL , "STIME" SAPDB6CHAR(6) DEFAULT '000000' NOT NULL , "MINOR_VERS" SMALLINT DEFAULT 0 NOT NULL , "MAJOR_VERS" INTEGER DEFAULT 0 NOT NULL , "LDATA" BLOB(1G)LOGGED , "QDATA" BLOB(1G)LOGGED ) IN DGS#EL700D INDEX IN DGS#EL700I LONG IN DGS#EL700D )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110505114659

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110505120849

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAP0000.cmd -dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAP0000.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( DROP TABLE "REPOLOAD" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed

( CREATE TABLE "REPOLOAD" ( "PROGNAME" SAPDB6CHAR(40) DEFAULT ' ' NOT NULL , "R3STATE" SAPDB6FIXCHAR(1) DEFAULT ' ' NOT NULL , "MACH" SMALLINT DEFAULT 0 NOT NULL , "UNAM" SAPDB6CHAR(12) DEFAULT ' ' NOT NULL , "UDAT" SAPDB6CHAR(8) DEFAULT '00000000' NOT NULL , "UTIME" SAPDB6CHAR(6) DEFAULT '000000' NOT NULL , "L_DATALG" INTEGER DEFAULT 0 NOT NULL , "Q_DATALG" INTEGER DEFAULT 0 NOT NULL , "SDAT" SAPDB6CHAR(8) DEFAULT '00000000' NOT NULL , "STIME" SAPDB6CHAR(6) DEFAULT '000000' NOT NULL , "MINOR_VERS" SMALLINT DEFAULT 0 NOT NULL , "MAJOR_VERS" INTEGER DEFAULT 0 NOT NULL , "LDATA" BLOB(1G)LOGGED , "QDATA" BLOB(1G)LOGGED ) IN DGS#EL700D INDEX IN DGS#EL700I LONG IN DGS#EL700D )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(DB) INFO: disconnected from DB

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110505120849

Former Member
0 Kudos

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110504190648

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -ctf I Q:\1000082149\1\ABAP\DATA\SAPPOOL.STR C:\Program Files\sapinst_instdir\CRM70\LM\COPY\DB6\SYSTEM\CENTRAL\AS-ABAP\DDLDB6.TPL SAPPOOL.TSK DB6 -l SAPPOOL.log

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job completed

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110504190648

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110504190648

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPPOOL.cmd -dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAPPOOL.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(DB) INFO: AANK created #20110504190649

(DB) INFO: AANK~0 created #20110504190649

(IMP) INFO: import of AANK completed (0 rows) #20110504190649

(DB) INFO: AANL created #20110504190649

(DB) INFO: AANL~0 created #20110504190649

(IMP) INFO: import of AANL completed (0 rows) #20110504190649

(DB) INFO: ATAB created #20110504190649

(DB) INFO: ATAB~0 created #20110504190649

(DB6) Using LOAD API for table ATAB

(IMP) INFO: import of ATAB completed (2719993 rows) #20110504190723

(DB) INFO: BPHIER created #20110504190723

(DB) INFO: BPHIER~0 created #20110504190723

(IMP) INFO: import of BPHIER completed (0 rows) #20110504190723

(DB) INFO: CFIS created #20110504190723

(DB) INFO: CFIS~0 created #20110504190723

(IMP) INFO: import of CFIS completed (0 rows) #20110504190723

(DB) INFO: CRVP created #20110504190723

(DB) INFO: CRVP~0 created #20110504190723

(IMP) INFO: import of CRVP completed (0 rows) #20110504190723

(DB) INFO: DEBI created #20110504190723

(DB) INFO: DEBI~0 created #20110504190723

(IMP) INFO: import of DEBI completed (0 rows) #20110504190723

(DB) INFO: DVPOOL created #20110504190723

(DB) INFO: DVPOOL~0 created #20110504190723

(IMP) INFO: import of DVPOOL completed (0 rows) #20110504190723

(DB) ERROR: DDL statement failed with SQL error

( CREATE TABLE "DVPOOLTEXT" ( "TABNAME" SAPDB6CHAR(10) DEFAULT ' ' NOT NULL , "VARKEY" SAPDB6CHAR(110) DEFAULT ' ' NOT NULL , "DATALN" SMALLINT DEFAULT 0 NOT NULL , "VARDATA" VARCHAR(16384) FOR BIT DATA ) IN DGS#POOLD INDEX IN DGS#POOLI LONG IN DGS#POOLD )

(SQL error -670)

error message returned by dsql:

SQL0670N The row length of the table exceeded a limit of "16293" bytes. (Table space "DGS#POOLD".) SQLSTATE=54010

(DB) INFO: disconnected from DB

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110504190723

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110505112616

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPPOOL.cmd -dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAPPOOL.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( DROP TABLE "DVPOOLTEXT" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed with SQL error

( CREATE TABLE "DVPOOLTEXT" ( "TABNAME" SAPDB6CHAR(10) DEFAULT ' ' NOT NULL , "VARKEY" SAPDB6CHAR(110) DEFAULT ' ' NOT NULL , "DATALN" SMALLINT DEFAULT 0 NOT NULL , "VARDATA" VARCHAR(16384) FOR BIT DATA ) IN DGS#POOLD INDEX IN DGS#POOLI LONG IN DGS#POOLD )

(SQL error -670)

error message returned by dsql:

SQL0670N The row length of the table exceeded a limit of "16293" bytes. (Table space "DGS#POOLD".) SQLSTATE=54010

(DB) INFO: disconnected from DB

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110505112617

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110505113814

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPPOOL.cmd -dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAPPOOL.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( DROP TABLE "DVPOOLTEXT" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed with SQL error

( CREATE TABLE "DVPOOLTEXT" ( "TABNAME" SAPDB6CHAR(10) DEFAULT ' ' NOT NULL , "VARKEY" SAPDB6CHAR(110) DEFAULT ' ' NOT NULL , "DATALN" SMALLINT DEFAULT 0 NOT NULL , "VARDATA" VARCHAR(16384) FOR BIT DATA ) IN DGS#POOLD INDEX IN DGS#POOLI LONG IN DGS#POOLD )

(SQL error -670)

error message returned by dsql:

SQL0670N The row length of the table exceeded a limit of "16293" bytes. (Table space "DGS#POOLD".) SQLSTATE=54010

(DB) INFO: disconnected from DB

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110505113815

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110505114629

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPPOOL.cmd -dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAPPOOL.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( DROP TABLE "DVPOOLTEXT" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed with SQL error

( CREATE TABLE "DVPOOLTEXT" ( "TABNAME" SAPDB6CHAR(10) DEFAULT ' ' NOT NULL , "VARKEY" SAPDB6CHAR(110) DEFAULT ' ' NOT NULL , "DATALN" SMALLINT DEFAULT 0 NOT NULL , "VARDATA" VARCHAR(16384) FOR BIT DATA ) IN DGS#POOLD INDEX IN DGS#POOLI LONG IN DGS#POOLD )

(SQL error -670)

error message returned by dsql:

SQL0670N The row length of the table exceeded a limit of "16293" bytes. (Table space "DGS#POOLD".) SQLSTATE=54010

(DB) INFO: disconnected from DB

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110505114629

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20110505120819

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe -i SAPPOOL.cmd -dbcodepage 4103 -k 1W1fd5M50Dh01eqteAQy1AA1 -l SAPPOOL.log -stop_on_error -loadprocedure fast LOAD

(DB) INFO: connected to DB

(DB) ERROR: DDL statement failed

( DROP TABLE "DVPOOLTEXT" )

dsql_exec_immediate returned DS_DBOBJECTUNKNOWN

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) ERROR: DDL statement failed with SQL error

( CREATE TABLE "DVPOOLTEXT" ( "TABNAME" SAPDB6CHAR(10) DEFAULT ' ' NOT NULL , "VARKEY" SAPDB6CHAR(110) DEFAULT ' ' NOT NULL , "DATALN" SMALLINT DEFAULT 0 NOT NULL , "VARDATA" VARCHAR(16384) FOR BIT DATA ) IN DGS#POOLD INDEX IN DGS#POOLI LONG IN DGS#POOLD )

(SQL error -670)

error message returned by dsql:

SQL0670N The row length of the table exceeded a limit of "16293" bytes. (Table space "DGS#POOLD".) SQLSTATE=54010

(DB) INFO: disconnected from DB

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

Q:\usr\sap\DGS\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20110505120819

Former Member
0 Kudos

Hi ,

Retry with the latest version of R3load available in the SAP SMP.

Regards ,

Sibashis