ORA-00904: : invalid identifier during R3Load

[Former Member]

Dear Guru's,

I'm doing a migration from :

Source System :

O/S : Linux

Kernel : 4.6D Ext

DB : Oracle 8.1.7

to

Target System :

O/S : Windows 2003

Kernel : 4.6D Ext

DB: Oracle 10 R2 (latest patches)

but encountered in Phase DBR3LOADVIEW_NT_ORA :

#START: 20081211162539

error message: No such file or directory

(GOS) WARNING: Unable to open file "NULL\.EXT" - default sizes assumed for initial extents

#Trying to create view "V_PDBKUR"

DbSl Trace: ORA-904 occurred; SQL statement is ==>

(IMP) ERROR: CREATE statement failed for object "V_PDBKUR"

(CREATE VIEW "V_PDBKUR" ( "MANDT", "PERNR", "INPER", "FPPER", "SEQNO", "KENID", "ZVKAS", "STATS", "BESCH", "WERKS", "BTRTL", "RZNSK", "RZNAG", "BNRSK", "NUS01", "NUS02", "RZDAT", "VERNR", "FNAME", "ZVKAN", "SKPNR", "MDART", "ABRMO", "ABRJA", "BEGDA", "ENDDA", "STONR", "WAERS", "BTAGE", "BLOHN", "AFSTD", "NUS03", "GTAGE", "GVERG", "GZUTG", "NUS06", "GSTDG", "GSTDB", "GBRTL", "GLGRP", "NACHN", "VORNA", "NUS05" ) AS SELECT T0002."MANDT", T0002."PERNR", T0002."INPER", T0002."FPPER", T0002."SEQNO",

T0002."KENID", T0002."ZVKAS", T0002."STATS", T0002."BESCH", T0002."WERKS", T0002."BTRTL", T0001."RZNSK", T0001."RZNAG", T0001."BNRSK", T0001."NUS01", T0001."NUS02",

T0001."RZDAT", T0001."VERNR", T0001."FNAME", T0001."ZVKAN", T0001."SKPNR", T0001."MDART", T0001."ABRMO", T0001."ABRJA", T0001."BEGDA", T0001."ENDDA", T0001."STONR",

T0001."WAERS", T0001."BTAGE", T0001."BLOHN", T0001."AFSTD", T0001."NUS03", T0001."GTAGE", T0001."GVERG", T0001."GZUTG", T0001."NUS06", T0001."GSTDG", T0001."GSTDB",

T0001."GBRTL", T0001."GLGRP", T0001."NACHN", T0001."VORNA", T0001."NUS05" FROM "PDBKUR" T0001, "PDBKAD" T0002 WHERE

T0001."MANDT" = T0002."MANDT" AND T0001."PERNR" = T0002."PERNR" AND T0001."INPER" = T0002."INPER"

AND T0001."FPPER" = T0002."FPPER" AND T0001."SEQNO" = T0002."SEQNO" AND T0001."KENID" =

T0002."KENID")

DbSlExecute: rc = 99

(SQL error 904)

error message returned by DbSl:

ORA-00904: "T0001"."GLGRP": invalid identifier

Can someone help?

Thank You

[Former Member]

That is no error - it happens if you repeat an import that had an ".err" in the corresponding .TSK file. R3load tries to drop the object and recreate it. Since it was not there it couldn't be dropped (which is not an error but just a warning).

Ermm..there arent any .tsk file in the folder..isn't it tsk are for WAS 6.10 >? any log that you require to see?

[markus_doehr2]

> ORA-00904: "T0001"."GLGRP": invalid identifier

Does table T0001 contain a column with that name?

Markus

[Former Member]

Hi,

This table haven't even created yet :

This are the log before I hit that error

DbSl Trace: ORA-1403 when accessing table SAPUSER

1. trying to restart import ###

(RIM) WARNING: unable to drop view "V_PDBKUR"

DbSlExecute: rc = 107

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

[markus_doehr2]

> This table haven't even created yet :

This is interesting. The SAPVIEW package is usually the last package to be imported. Are all other package successfully finished?

> This are the log before I hit that error

>

> DbSl Trace: ORA-1403 when accessing table SAPUSER

>

> ### trying to restart import ###

> (RIM) WARNING: unable to drop view "V_PDBKUR"

> DbSlExecute: rc = 107

> (SQL error 942)

> error message returned by DbSl:

> ORA-00942: table or view does not exist

That is no error - it happens if you repeat an import that had an ".err" in the corresponding .TSK file. R3load tries to drop the object and recreate it. Since it was not there it couldn't be dropped (which is not an error but just a warning).

You can try to

cd <installation directory>
find /c "err" *.tsk

to find out the errorneous packages.

Markus