Need to know the error means technically

General discussion forum about all databases other than SqlBase.
kumarravik

Need to know the error means technically

Post by kumarravik » 18 Sep 2013, 12:39

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

Re: Need to know the error means technically

Post by frevelundfey » 08 Dec 2013, 22:15

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

Re: Need to know the error means technically

Post by davidmartin123 » 30 Jun 2014, 06:29

Kindly reboot your system.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests