Skip to Content
0
Former Member
May 05, 2011 at 07:58 AM

Error in ABAP Import Phase - 3 jobs failed

156 Views

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