Error during ECC Upgrade

[Former Member]

Hi All.

I get the following error while upgrading R3 4.6C to ERP 6: AIX 5.3/ORACLE 10G

4 ETW000 [dev trc ,00000] OCI-call failed with -1=OCI_ERROR 637889 0.637889

4 ETW000 [dev trc ,00000] SQL error 904: 'ORA-00904: "WRONGCL": invalid identifier'

4 ETW000 19 0.637908

4 ETW000 [dbsloci. ,00000] *** ERROR => Error 904 in stmt_fetch() from oci_execute_stmt(), orpc=0

4 ETW000 17 0.637925

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

4 ETW000 15 0.637940

4 ETW000 [dev trc ,00000] sc_p=1108d5300,no=28,idc_p=1108ebaa0,con=0,act=1,slen=500,smax=512,#vars=2,stmt=1112c1220,table=DD02L

4 ETW000 16 0.637956

4 ETW000 [dev trc ,00000] SELECT "TABNAME" , "AS4LOCAL" , "AS4VERS" , "TABCLASS" , "SQLTAB" , "DATMIN" , "DATMAX" , "DATAVG" ,\

4 ETW000 14 0.637970

4 ETW000 [dev trc ,00000] "CLIDEP" , "BUFFERED" , "COMPRFLAG" , "LANGDEP" , "ACTFLAG" , "APPLCLASS" , "AUTHCLASS" , "AS4USER"\

4 ETW000 14 0.637984

4 ETW000 [dev trc ,00000] , "AS4DATE" , "AS4TIME" , "MASTERLANG" , "MAINFLAG" , "CONTFLAG" , "RESERVETAB" , "GLOBALFLAG" , "P\

4 ETW000 14 0.637998

4 ETW000 [dev trc ,00000] ROZPUFF" , "VIEWCLASS" , "VIEWGRANT" , "MULTIPLEX" , "SHLPEXI" , "PROXYTYPE" , "EXCLASS" , "WRONGCL"\

4 ETW000 14 0.638012

4 ETW000 [dev trc ,00000] FROM "DD02L" WHERE "TABNAME" = :A0 AND "AS4LOCAL" = :A1 ORDER BY "TABNAME" , "AS4LOCAL" , "AS4VERS"\

4 ETW000 14 0.638026

4 ETW000 [dev trc ,00000] ; 7 0.638033

4 ETW000 [dev trc ,00000] sc_p=1108d5300,no=28,idc_p=1108ebaa0,con=0,act=1,slen=500,smax=512,#vars=2,stmt=1112c1220,table=DD02L

4 ETW000 18 0.638051

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

4 ETW000 15 0.638066

4 ETW000 [dev trc ,00000] IN : cols=2,rmax=1,xcnt=0,rpc=0,rowi=0,rtot=0,upto=4294967295,rsize=31,vmax=32,bound=1,iobuf_p=110a03de0,vda_p=1112c24e0

4 ETW000 15 0.638081

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

4 ETW000 14 0.638095

4 ETW000 [dev trc ,00000] OUT: cols=31,rmax=295,xcnt=295,rpc=0,rowi=0,rtot=0,upto=4294967295,rsize=158,vmax=32,bound=1,iobuf_p=1109c40c0,vda_p=1112c2c00

4 ETW000 15 0.638110

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

4 ETW000 31 0.638141

4 ETW000 [dev trc ,00000] SELECT "TABNAME" , "AS4LOCAL" , "AS4VERS" , "TABCLASS" , "SQLTAB" , "DATMIN" , "DATMAX" , "DATAVG" ,\

4 ETW000 16 0.638157

4 ETW000 [dev trc ,00000] "CLIDEP" , "BUFFERED" , "COMPRFLAG" , "LANGDEP" , "ACTFLAG" , "APPLCLASS" , "AUTHCLASS" , "AS4USER"\

4 ETW000 14 0.638171

4 ETW000 [dev trc ,00000] , "AS4DATE" , "AS4TIME" , "MASTERLANG" , "MAINFLAG" , "CONTFLAG" , "RESERVETAB" , "GLOBALFLAG" , "P\

4 ETW000 27 0.638198

4 ETW000 [dev trc ,00000] ROZPUFF" , "VIEWCLASS" , "VIEWGRANT" , "MULTIPLEX" , "SHLPEXI" , "PROXYTYPE" , "EXCLASS" , "WRONGCL"\

4 ETW000 14 0.638212

4 ETW000 [dev trc ,00000] FROM "DD02L" WHERE "TABNAME" = :A0 AND "AS4LOCAL" = :A1 ORDER BY "TABNAME" , "AS4LOCAL" , "AS4VERS"\

4 ETW000 14 0.638226

4 ETW000 [dev trc ,00000] ; 8 0.638234

4 ETW000 [dbtrtab ,03908] ***LOG BY4=>sql error 904 performing SEL on table DD02L [dbtrtab#6 @ 3908]

4 ETW000 24 0.638258

4 ETW000 [dbtrtab ,03908] ***LOG BY0=>ORA-00904: "WRONGCL": invalid identifier [dbtrtab#6 @ 3908]

4 ETW000 14 0.638272

2EETW000 sap_dext called with msgnr "1":

2EETW000 -

---

db call info -

---

2EETW000 function: db_setget

2EETW000 fcode: RT_GET

2EETW000 tabname: DD02L

2EETW000 len: 31

2EETW000 key: CLS_ASSIGNMENT A

2EETW000 ok fetches: 0

2EETW000 last entry:

2EETW000 retcode: 1

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

1 ETP187 R3TRANS SHADOW IMPORT

1 ETP110 end date and time : "20071116150527"

1 ETP111 exit code : "12"

1 ETP199 ######################################

4 EPU202XEND OF SECTION BEING ANALYZED

[Former Member · Accepted solution]

hello,

check please the following sap note:

<b><u>731</u></b> - Collective note: ORA-00904

Best regards

Baran