Need to know the error means technically

[kumarravik]

Hi Team,

we have an application developed on team developer.

After Database migration (FROM ORACLE 10G TO 11G), i am getting some errors (mentioned below) in some applications connected to security schema of our database.

SQL ERROR NUMBER 20942
SQL ERROR NUMBER 203
SQL ERROR NUMBER 20904

Please help me to understand the meaning of these and how to resolve this.

many thanks.

[frevelundfey]

Hint:
If errornumber >= 20.000 subtract 20.000 then you get Oracle-error-number.
E.g.:
20942 = ORA-00942: table or view does not exist
20904 = ORA-00904: string: invalid identifier Cause: The column name entered is either missing or invalid.
For error-numbers < 20.000 call dberror.exe (watch in Gupta-Directory) and type in the error number.
E.g.:
203 DBO NEX Command has not been executed

Conclusion:
Looks like your migration wasn't successful.
Either table does not exist, rights are not granted, maybe public synonym is missing.

Regards Thomas

[davidmartin123]

Kindly reboot your system.