Occasional error: ORA-08103

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
fbkevy
Posts: 4
Joined: Fri 20 Apr 2012 07:05

Occasional error: ORA-08103

Post by fbkevy » Fri 20 Apr 2012 07:49

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)
:?:

fbkevy
Posts: 4
Joined: Fri 20 Apr 2012 07:05

Post by fbkevy » Fri 20 Apr 2012 18:50

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.

Pinturiccio
Devart Team
Posts: 2138
Joined: Wed 02 Nov 2011 09:44

Post by Pinturiccio » Thu 26 Apr 2012 11:49

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.

Post Reply