Occasional error: ORA-08103

Occasional error: ORA-08103

Postby 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

Postby 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.
fbkevy
 
Posts: 4
Joined: Fri 20 Apr 2012 07:05

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1928
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle