Page 1 of 1

Occasional error: ORA-08103

Posted: Fri 20 Apr 2012 07:49
by fbkevy
This error happens about 1 in 50 DB connection attempts. For some reason. Anyone got any ideas? Is this a problem on the client side or the server side?

Thanks in advance!

Devart.Data.Oracle.dll version: 6.0.86.0
Windows 2008 (64bit), .Net4, c#
Oracle client lib version: 11.2 (32 bit)
Oracle version: 11.2
Client software is 32 bit.

Error:

Code: Select all

18 Apr 2012 07:35:54,787 [16] ERROR xxx.yyy [(null)] - Error when executing ODP query
Devart.Data.Oracle.OracleException (0x80004005): ORA-08103: object no longer exists
   at Devart.Data.Oracle.a0.b(Int32 A_0)
   at Devart.Data.Oracle.a2.c(Int32 A_0)
   at Devart.Data.Oracle.OracleDataReader.Read()
   at xxx.yyy.OranetQueryDatabase[T](IDictionary`2 filterDictionary, IDictionary`2 minValuesDictionary, IDictionary`2 maxValuesDictionary, Int64 maxRows, Int64 pageNo, DbTransaction dbTransaction)
:?:

Posted: Fri 20 Apr 2012 18:50
by fbkevy
It could also be possible the the server side data is changing.

It is also possible that multiple clients are accessing the DB at the exact same time.

Posted: Thu 26 Apr 2012 11:49
by Pinturiccio
fbkevy wrote:It is also possible that multiple clients are accessing the DB at the exact same time.
The exception can be caused by another user deleting an object after the operation has been started.
If this information does not help you, please send us a small test project with DDL/DML scripts or describe steps for reproducing the issue.