ora-00904 in the phase TOOLIMPD3 when upgrading 46c to ecc6

[Former Member]

Hi:

the sap system is sap 46c sr2 + oracle 8.1.7.4 + windows 2000 server. For upgrading 46c to ecc6 , I had done these steps:

1. migrate the oracle 8.1.7.4 to 9.2.0.7

2. upgrade the windows 2000 server to windows 2003

3. migrade the oracle 9.2.0.7 to oracle 10.2.0.2.

These steps is successful. Then I upgrade the 46c sr2 to ECC 6 SR2. I executed the PREPARE and to the phase TOOLIMPD3, the error message is :

4 ETW000 [dbsloci. ,00000] *** ERROR => ORA-904 occurred when executing SQL statement (parse error offset=51)

4 ETW000 30709 0.130628

4 ETW000 [dev trc ,00000] sc_p=00398F34,no=51,idc_p=01D82AC8,con=0,act=1,slen=123,smax=256,#vars=4,stmt=037D41E8,table=DDLOG

4 ETW000 22 0.130650

4 ETW000 [dev trc ,00000] INSERT INTO DDLOG (SEQNUMBER, TIMESTAMP, SYSTEMID, NBLENGTH, NOTEBOOK) VALUES ( DDLOG_SEQ.NEXTVAL, 😕

4 ETW000 17 0.130667

4 ETW000 [dev trc ,00000] A0 , :A1 , :A2 , :A3 ) ; 10 0.130677

4 ETW000 [dev trc ,00000] sc_p=00398F34,no=51,idc_p=01D82AC8,con=0,act=1,slen=123,smax=256,#vars=4,stmt=037D41E8,table=DDLOG

4 ETW000 21 0.130698

4 ETW000 [dev trc ,00000] prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p=00000000,ocistmth_p=037D4F34

4 ETW000 17 0.130715

4 ETW000 [dev trc ,00000] IN : cols=4,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=1,upto=-1,rsize=32042,vmax=32,bound=1,iobuf_p=01E2C5A0,vda_p=037D5340

4 ETW000 19 0.130734

4 ETW000 [dev trc ,00000] lobs=0,lmax=0,lpcnt=0,larr=00000000,lcurr_p=00000000,rret=0

4 ETW000 15 0.130749

4 ETW000 [dev trc ,00000] OUT: cols=0,rmax=0,xcnt=0,rpc=0,rowi=0,rtot=0,upto=0,rsize=0,vmax=0,bound=0,iobuf_p=00000000,vda_p=00000000

4 ETW000 17 0.130766

4 ETW000 [dev trc ,00000] lobs=0,lmax=0,lpcnt=0,larr=00000000,lcurr_p=00000000,rret=0

4 ETW000 16 0.130782

4 ETW000 [dev trc ,00000] INSERT INTO DDLOG (SEQNUMBER, TIMESTAMP, SYSTEMID, NBLENGTH, NOTEBOOK) VALUES ( DDLOG_SEQ.NEXTVAL, 😕

4 ETW000 15 0.130797

4 ETW000 [dev trc ,00000] A0 , :A1 , :A2 , :A3 ) ; 10 0.130807

4 ETW000 [dbsynseq ,00324] ***LOG BY4=>sql error 904 performing INS on table DDLOG [dbsynseq#1 @ 324]

4 ETW000 38 0.130845

4 ETW000 [dbsynseq ,00324] ***LOG BY0=>ORA-00904: "NBLENGTH": invalid identifier [dbsynseq#1 @ 324]

4 ETW000 25 0.130870

4 ETW000 [dev trc ,00000] db_syflush (TRUE, FALSE) failed 12 0.130882

4 ETW000 [dev trc ,00000] db_con_commit received an error return code in before-commit action

4 ETW000 15 0.130897

4 ETW000 [dbeh.c ,00000] *** ERROR => missing return code handler 16 0.130913

4 ETW000 caller does not handle code 1024 from dblink#5[293]

4 ETW000 ==> calling sap_dext to abort transaction

2EETW000 sap_dext called with msgnr "900":

2EETW125 SQL error "904" during "" access: "ORA-00904: "NBLENGTH": invalid identifier"

1 ETP153 DICTIONARY IMPORT

1 ETP110 end date and time : "20090121154955"

1 ETP111 exit code : "12"

Why? How can I solve it?

Help me, thanks.

[markus_doehr2]

> 4 ETW000 caller does not handle code 1024 from dblink#5[293]

> 4 ETW000 ==> calling sap_dext to abort transaction

> 2EETW000 sap_dext called with msgnr "900":

> 2EETW125 SQL error "904" during "" access: "ORA-00904: "NBLENGTH": invalid identifier"

> 1 ETP153 DICTIONARY IMPORT

I would

- update to the latest tp

- update to the latest R3trans

- update to the latest dboraslib

and retry the phase.

Markus

[Former Member]

Hi,

Firstly, make sure you are using the latest SAPup version and patch level. Take a look at SAP Note 731 - point 6.

Cheers

[Former Member]

Hi:

thanks for your reply,the problem is solved.

[Former Member]

dear ,how did you solve the problem,just update SAPup to new version?

[Former Member]

hello qiu, i have the same problem,i update the SAPup ,it still have the error.

how did you get the problem solved?

thanks