Access violation

[san_eins]

Hi Team,



We are facing intermittent issue of "Access violation" while using oracle advance queue in the application. Below are the logs from memory dump and windows event viewer:

“Unhandled exception at 0x00007FFF120B908C (KERNELBASE.dll) in memory.hdmp: 0xC0000005: Access violation”

Exception Info: System.AccessViolationException
at OciDynamicType.nativeOCITypeByName(System.Runtime.InteropServices.HandleRef, System.Runtime.InteropServices.HandleRef, System.Runtime.InteropServices.HandleRef, Byte[], Int32, Byte[], Int32, System.String, Int32, Int16, Int32, IntPtr ByRef)
at OciDynamicType.OCITypeByName(System.Runtime.InteropServices.HandleRef, System.Runtime.InteropServices.HandleRef, System.Runtime.InteropServices.HandleRef, Byte[], Int32, Byte[], Int32, System.String, Int32, Int16, Int32, IntPtr ByRef)
at Devart.Data.Oracle.df.a(System.String ByRef, Devart.Data.Oracle.dg)
at Devart.Data.Oracle.OracleType.a(System.String, System.String, Devart.Data.Oracle.bx)
at Devart.Data.Oracle.OracleParameter.a(Devart.Data.Oracle.bz ByRef, Boolean, Devart.Data.Oracle.OracleConnection, Byte[], System.Collections.Hashtable, Devart.Data.Oracle.bx, Boolean ByRef, Int32)
at Devart.Data.Oracle.OracleCommand.a(Devart.Data.Oracle.ck, Int32, Devart.Data.Oracle.OracleParameterCollection, Devart.Data.Oracle.bx, Boolean ByRef)
at Devart.Data.Oracle.OracleCommand.InternalExecute(System.Data.CommandBehavior, System.IDisposable, Int32, Int32, Boolean)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(System.Data.CommandBehavior, Boolean)
at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
at Devart.Data.Oracle.OracleQueue.Dequeue(Devart.Data.Oracle.OracleQueueDequeueOptions)

Please note that issue intermittent and cannot be produced at will.

Below are the environment details :

Windows 2012 Standard R2

Oracle Client 12.1.0

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Devart.Data.dll 5.0.2070.0

Devart version 9.6

[san_eins]

Hi Devart Team,

We would appreciate a quick response on this, as we are stuck with this issue and it keep appearing intermittently.

Thanks & Regards,
Sanjay

[Shalex]

Oracle Client 12.1.0

1. We have received a feedback from our customer that upgrading the Oracle client installed on the server from 12.1.0.2 to 12.2.0.1 fixed System.AccessViolationException.

Devart version 9.6

2. Also, we recommend using the newest (9.11.980) build of dotConnect for Oracle: https://www.devart.com/dotconnect/oracl ... story.html.