Oracle Error (ORA-08103) happens intermittently

[slaxman]

Exception is thrown intermittently during some read operations on our production environment. It does not reproduce on our test servers. any thoughts?

Devart.Data.Oracle.dll 9.0.12.0

call stack:

||544|2019/01/03 14:49:37.074|8284|PoolThread:89|||Details: Devart.Data.Oracle.OracleException: ORA-08103: object no longer exists
at Devart.Data.Oracle.cv.d()
at Devart.Data.Oracle.ah.i()
at Devart.Data.Oracle.ad.s(Byte[] A_0, Int32 A_1, Int32 A_2)
at Devart.Data.Oracle.Entity.d.b(Int32 A_0, aa A_1)
at System.Data.Entity.Core.Common.Internal.Materialization.Coordinator`1.ReadNextElement(Shaper shaper)
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

[Shalex]

Most likely, your table was truncated by another process at the same time when your code was executing select. Please refer to https://stackoverflow.com/questions/485 ... ing-tables.

[Bellamy112]

Most likely, your table was truncated by another process at the same time when your code was executing select. Please refer to https://stackoverflow.com/questions/485 ... ing-tablesworld of solitaire

OK. So, does Connection Timeout=0 in OCI mode act the same and wait for the connection for an unlimited amount of time?

[DmitryGm]

does Connection Timeout=0 in OCI mode act the same and wait for the connection for an unlimited amount of time?

Yes, Connection Timeout is the time (in seconds) to wait while trying to establish a connection before terminating the attempt and generating an error. A value of 0 indicates no limit. The default value is 15 seconds.

See: ConnectionString Property