Error in EU_IMPORT1

[Former Member]

+Hello everybody

I'm upgrading from 4.70 to ECC 6.0. In phase EU_IMPORT1 I get the following error :+

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

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

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

Compiled Oct 22 2007 23:20:22

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

DbSl Trace: SQL-Error -204 in function db_open

(DB) INFO: connected to DB

(DB) INFO: DDNTF? deleted/truncated #20071120162551

(BUF) ERROR: CsDecompr rc = -11

(SQL) INFO: SDIC.SQL not found

(DB) ERROR: DDL statement failed

(ALTER TABLE "DDNTF?" DROP PRIMARY KEY )

DbSlExecute: rc = 99

(SQL error -539)

error message returned by DbSl:

Table DDNTF? in R3PRDDATA doesn't have primay key. MSGID= Job=807797/PRDOFR/R3LOAD

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

(DB) ERROR: DDL statement failed

(ALTER TABLE "DDNTF?" ADD CONSTRAINT "DDNTF&0" PRIMARY KEY ( "TABNAME", "BLOCKNR" ) )

DbSlExecute: rc = 99

(SQL error -951)

error message returned by DbSl:

The object DDNTF? of R3PRDDATA has not been altered. MSGID= Job=807797/PRDOFR/R3LOAD

(DB) INFO: disconnected from DB

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

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

+Obviously, the table exist and the primary key too.

Anybody knows how can this error be solved?

Thank you in advanced

Rubén+

[Former Member · Accepted solution]

Hi Ruben,

did you check for the following ?

CHGJRN JRN(R3sidDATA/QSQJRN) JRNRCV(GEN) RCVSIZOPT(RMVINTENT *MAXOPT2)

I had something similar when it was not set or on *MAXOPT1 only ...

Regards

Volker Gueldenpfennig, consolut international ag

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

[Former Member]

Thank you for everything.

I have just opened the ticket.

[Former Member]

Hi

Still the same error.

Is it related with the symbol "?" after the name of the table (DDNTF?) ?

Any help would be apreciated.

Regards

Rubé

[Former Member]

Hi Ruben,

no, definetely not !

That is just a sign, that it is for the shadow instance .... => that is normal & necessary.

Obviously, you are having an issue and should open an OSS ticket at BC-OP-AS4 ...

Regards

Volker Gueldenpfennig, consolut international ag

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

[Former Member]

Hi volker,

we are also stop at same stage with below log

/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 provde me some solution

thnaks

ajai

[Former Member]

Hi ajai

Pls check the journal for

RCVSIZOPT(*RMVINTENT *MAXOPT2)

Let us know..!!

If it is not that..change it to the above and try again..

Thanks

Abhi

[Former Member]

Ah! yes, we had an unexpected IPL.

[Former Member]

Hi Ruben,

then I would suggest to run RCLSTG *DBXREF ...

Regards

Volker Gueldenpfennig, consolut international ag

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

[Former Member]

Hello again

I have found the following:

CPI32A6 - Cross-reference notification 10 for request 303, type 2

Message . . . . : Cross-reference notification 10 for request 303, type 2.

Cause . . . . . : An unexpected condition was detected while processing

the

system cross-reference files. This message does not indicate the

existence

of a problem, but may be valuable to IBM developers if a cross-reference

problem occurs at a future time. The Unexpected condition type is 2.

The condition types and their meanings follow:

0 -- Context recovery

1 -- Inconsistent data was discovered in the cross-reference files for

library R3PRDDATA.

2 -- The server recovered from an unexpected error.

3 -- Exit condition.

Recovery . . . : No recovery is required.

Technical Descrpition (sorry it is in Spanish)

- Problem Type : 2

- Petición : 303

- Instancia : 10

- Número IASP/ASP : 0

- Contexto del error : R3PRDDATA

- Contexto de objeto : R3PRDDATA

- Nombre de objeto : Q_AT000000

- Contexto ref. cruzada : QSYS

- Archivo ref. cruzada : QADBXLFI

- Atributo registro : TB

- Reclam. registro : X'40404040404040404040404040404040'

- Reclam. petición : X'5CD1D6C2404040404040F8F0F7F7F9F7'

- Cuenta referencia : 0

- Segundo contexto : *NONE

- Segundo nombre : *NONE

- Alternative Name:

DDNTF?

- Second Alternative name. :

- Biblioteca atributos : *NONE

- Nombre de atributo : *NONE

- Nombre trabajo petición: R3LOAD

- Usuario trab. petición : PRDOFR

- Número trabajo petición: 807797

- ID hebra trab. petición: X'0000000000000003'

Is this information useful?

Regards.

[Former Member]

Hello Volker

The attributes of the diary are exactly you describe...

Best regards.

Rubé

[Former Member]

Hi Ruben,

then we need the joblog of 807797/PRDOFR/R3LOAD ...

Regards

Volker Gueldenpfennig, consolut international ag

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