EU_IMPORT1 stop error

[Former Member]

hi ,

we are geting this error in phse of EU_IMPORT1

/usr/sap/put/exe/R3load: START OF LOG: 20080201224729

/usr/sap/put/exe/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#13 $ SAP

/usr/sap/put/exe/R3load: version R7.00/V1.4

Compiled Jun 30 2007 06:35:49

/usr/sap/put/exe/R3load -i /usr/sap/put/exchange/compack/EX000000.COD -p /usr/sap/put/log/EX000000.DPR -s /usr/sap/put/log/EX000000.DST -datacodepage 1100 -dbcodepage auto -upg_nametab DDNTT? DDNTF?

DbSl Trace: SQL-Error -204 in function db_open

(DB) INFO: connected to DB

(SQL) INFO: SLEXC.SQL not found

(DB) ERROR: DDL statement failed

(DROP TABLE "DYNPLOAD?")

DbSlExecute: rc = 103

(SQL error 204)

error message returned by DbSl:

DYNPLOAD? in *LIBL type *FILE not found. MSGID= Job=004704/DEVOFR/R3LOAD

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

(DB) ERROR: DDL statement failed

(CREATE TABLE "DYNPLOAD?" ( "PROGNAME" GRAPHIC(40) CCSID 13488 DEFAULT ' ' NOT NULL , "DYNPNUMBER" GRAPHIC(4) CCSID 13488 DEFAULT '0000' NOT NULL , "TYPE" GRAPHIC(1) CCSID 13488 DEFAULT ' ' NOT NULL , "DATA" BLOB(/LOB_SIZE/ 1G) ) )

DbSlExecute: rc = 99

(SQL error 7905)

error message returned by DbSl:

Table DYNPLOAD? in R3DEVDATA created but was not journaled. MSGID= Job=004704/DEVOFR/R3LOAD

(DB) ERROR: DDL statement failed

(DROP TABLE "DYNPTXTLD?")

DbSlExecute: rc = 103

(SQL error 204)

error message returned by DbSl:

DYNPTXTLD? in *LIBL type *FILE not found. MSGID= Job=004704/DEVOFR/R3LOAD

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

(DB) ERROR: DDL statement failed

(CREATE TABLE "DYNPTXTLD?" ( "PROGNAME" GRAPHIC(40) CCSID 13488 DEFAULT ' ' NOT NULL , "DYNPNUMBER" GRAPHIC(4) CCSID 13488 DEFAULT '0000' NOT NULL , "LANGUAGE" GRAPHIC(1) CCSID 13488 DEFAULT ' ' NOT NULL , "TYPE" GRAPHIC(1) CCSID 13488 DEFAULT ' ' NOT NULL , "DATA" BLOB(/LOB_SIZE/ 1G) ) )

DbSlExecute: rc = 99

(SQL error 7905)

error message returned by DbSl:

Table DYNPTXTLD? in R3DEVDATA created but was not journaled. MSGID= Job=004704/DEVOFR/R3LOAD

(DB) ERROR: DDL statement failed

(DROP TABLE "REPOLOAD?")

DbSlExecute: rc = 103

(SQL error 204)

error message returned by DbSl:

REPOLOAD? in *LIBL type *FILE not found. MSGID= Job=004704/DEVOFR/R3LOAD

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

(DB) ERROR: DDL statement failed

(CREATE TABLE "REPOLOAD?" ( "PROGNAME" GRAPHIC(40) CCSID 13488 DEFAULT ' ' NOT NULL , "R3STATE" GRAPHIC(1) CCSID 13488 DEFAULT ' ' NOT NULL , "MACH" SMALLINT DEFAULT 0 NOT NULL , "UNAM" GRAPHIC(12) CCSID 13488 DEFAULT ' ' NOT NULL , "UDAT" GRAPHIC(8) CCSID 13488 DEFAULT '00000000' NOT NULL , "UTIME" GRAPHIC(6) CCSID 13488 DEFAULT '000000' NOT NULL , "L_DATALG" INTEGER DEFAULT 0 NOT NULL , "Q_DATALG" INTEGER DEFAULT 0 NOT NULL , "SDAT" GRAPHIC(8) CCSID 13488 DEFAULT '00000000' NOT NULL , "STIME" GRAPHIC(6) CCSID 13488 DEFAULT '000000' NOT NULL , "MINOR_VERS" SMALLINT DEFAULT 0 NOT NULL , "MAJOR_VERS" INTEGER DEFAULT 0 NOT NULL , "LDATA" BLOB(/LOB_SIZE/ 1G) , "QDATA" BLOB(/LOB_SIZE/ 1G) ) )

DbSlExecute: rc = 99

(SQL error 7905)

error message returned by DbSl:

Table REPOLOAD? in R3DEVDATA created but was not journaled. MSGID= Job=004704/DEVOFR/R3LOAD

(DB) INFO: disconnected from DB

/usr/sap/put/exe/R3load: job finished with 3 error(s)

/usr/sap/put/exe/R3load: END OF LOG: 20080201224732

please give me answer.

thanks

aji kumar

[Former Member · Accepted solution]

Hi Ajai,

don't you think, this ia a forum for everybody instead asking for free support from one special person ?

ok, anyway ...

You should setup the journal receivers properly and it will work fine:

CHGJRN JRN(R3sidDATA/QSQJRN) & F4

and check if you are having the following:

RCVSIZOPT(*RMVINTENT *MAXOPT2)

As this will NOT be the case, you should use the following and repeat:

JRNRCV(GEN) RCVSIZOPT(RMVINTENT *MAXOPT2)

Regards

Volker Gueldenpfennig, consolut international ag

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

[Former Member · Accepted solution]

Hi volker,

thanks volker.i think it will work.

thanks

ajai kumar

[Former Member · Accepted solution]

thanks all problem was solved

[Former Member · Accepted solution]

thanks volker

[former_member195641]

Hello Kumar,

as already mentioned by Volker, it really makes sense to open a customer ticket in such cases. If there is really a bug in the tools than it should be analyzed and fixed by SAP. Workarounds just help in a concrete situation and maybe other customer will run into the same issue. And a fixed program helps more than just one customer.

It would be helpful to have a look at the documentation provided by SAP. From the logfile excerpt you provided I saw the 700 R3load was running in the given phase. Therefore SAP note 822296 is the most interesting info source behind the upgrade guide. In addition, there is a section right in the middle of this note describing exactly your problem - added in 2002.

Best regards

René Lang

SAP NetWeaver on IBM System i Development