Devart Forums

Posted: **Fri 03 Apr 2020 17:35**

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

Posted: **Wed 08 Apr 2020 11:03**

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

Posted: **Wed 08 Apr 2020 17:38**

san_eins wrote: ↑Fri 03 Apr 2020 17:35Oracle 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.

san_eins wrote: ↑Fri 03 Apr 2020 17:35Devart 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.

Devart Forums

Access violation

Access violation

Re: Access violation

Re: Access violation