System.AccessViolationException

[dcoracle600pro]

dotConnect v.7.8.301.0
OS: Win2K12 patched as of 2013-08-12

Log Name: Application
Source: .NET Runtime
Date: 8/12/2013 5:27:41 PM
Event ID: 1026
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: Win2K12-w3web01.precysesolutions.net
Description:
Application: w3wp.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
Stack:
at Devart.Common.DbCommandBase.ExecuteDbDataReader(System.Data.CommandBehavior, Boolean)
at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
at Precyse.Core.Data.BaseData.ExecuteCommandForTable(System.String, System.String, System.Data.IDbDataParameter[])
at Precyse.Coding.Data.CodableJobData.LoadProcedures(Int32, Precyse.Coding.Model.JobType, Precyse.Coding.Model.Codes, JobCodeType, System.Nullable`1<Int32>)
at Precyse.Coding.Data.CodableJobData`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].GetPrimaryCodes(Int32, System.Nullable`1<Int32>)
at Precyse.Coding.Cdi.Data.ModelExtensions.ToCdiJob(System.Data.DataRow, Boolean)
at Precyse.Coding.Cdi.Data.CdiJobData.GetAssignedJob(Int32, System.String, Boolean)
at Precyse.Coding.Cdi.Services.Wcf.TracService.Download(Int32)
at DynamicClass.SyncInvokeDownload(System.Object, System.Object[], System.Object[])
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(System.Object, System.Object[], System.Object[] ByRef)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(System.ServiceModel.Dispatcher.MessageRpc ByRef)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(System.ServiceModel.Dispatcher.MessageRpc ByRef)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(System.ServiceModel.Dispatcher.MessageRpc ByRef)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean)
at System.ServiceModel.Dispatcher.ChannelHandler.DispatchAndReleasePump(System.ServiceModel.Channels.RequestContext, Boolean, System.ServiceModel.OperationContext)
at System.ServiceModel.Dispatcher.ChannelHandler.HandleRequest(System.ServiceModel.Channels.RequestContext, System.ServiceModel.OperationContext)
at System.ServiceModel.Dispatcher.ChannelHandler.AsyncMessagePump(System.IAsyncResult)
at System.Runtime.IOThreadScheduler+ScheduledOverlapped.IOCallback(UInt32, UInt32, System.Threading.NativeOverlapped*)
at System.Runtime.Fx+IOCompletionThunk.UnhandledExceptionFrame(UInt32, UInt32, System.Threading.NativeOverlapped*)
at System.Threading._IOCompletionCallback.PerformIOCompletionCallback(UInt32, UInt32, System.Threading.NativeOverlapped*)

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name=".NET Runtime" />
<EventID Qualifiers="0">1026</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2013-08-12T21:27:41.000000000Z" />
<EventRecordID>2060</EventRecordID>
<Channel>Application</Channel>

We're seeing this error periodically and it takes down the entire IIS worker process. The application is in the DefaultAppPool, .NET Framework v.4.0, Integrated. We're using the Oracle client version v.11.2.0.3.

[Pinturiccio]

Please provide the following information:
1. the capacity of your application. You can check the capacity of your application in Task Manager;
2. Oracle server version;
3. the provider features you use
4. the code that runs before the AccessViolationException

If possible, create and send us a small test project with the corresponding DDL/DML scripts for reproducing the issue.

[EmilyFong]

We have the same error in Workflow too.
We are using devart 7.7.267.0 with Oracle Client 11.2.0 on Windows Server 2008 R2 SP1.
It happened randomly in different procedure.

The error message in event log as following:
First error Log:

Application: w3wp.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
Stack:
at Devart.Common.DbCommandBase.ExecuteDbDataReader(System.Data.CommandBehavior, Boolean)
at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
at Devart.Data.Oracle.ActivitiesTracking.OracleTrackingParticipant.a(System.Activities.Tracking.BookmarkResumptionRecord, Devart.Data.Oracle.OracleConnection)
at Devart.Data.Oracle.ActivitiesTracking.OracleTrackingParticipant.a(System.Activities.Tracking.TrackingRecord)
at System.Activities.Tracking.TrackingParticipant+TrackAsyncResult.TrackCore()
at System.Runtime.IOThreadScheduler+ScheduledOverlapped.IOCallback(UInt32, UInt32, System.Threading.NativeOverlapped*)
at System.Runtime.Fx+IOCompletionThunk.UnhandledExceptionFrame(UInt32, UInt32, System.Threading.NativeOverlapped*)
at System.Threading._IOCompletionCallback.PerformIOCompletionCallback(UInt32, UInt32, System.Threading.NativeOverlapped*)




Second Error log:

Application: w3wp.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
Stack:
at Devart.Common.DbCommandBase.ExecuteDbDataReader(System.Data.CommandBehavior, Boolean)
at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
at Devart.Data.Oracle.DurableInstancing.as.a(Boolean)
at Devart.Data.Oracle.DurableInstancing.ag.c()
at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
at System.Threading.ThreadHelper.ThreadStart()

[Pinturiccio]

Please provide the following information:
1. the capacity of your application. You can check the capacity of your application in Task Manager;
2. the Oracle server version;
3. the code that runs before the AccessViolationException.

Please also find out the steps that reproduce the issue for sure and send them to us. If possible, create and send us a small test project with the corresponding DDL/DML scripts for reproducing the issue.

[EmilyFong]

Oracle Server is 11g and client is on IIS server is 11g client too.

the code that runs before the exception is

Dim customRecord As CustomTrackingRecord = New CustomTrackingRecord(GetResourceStrings("CustomTrackRecordName", "WorkflowEngineTrack"))
customRecord.Data.Clear()
customRecord.Data.Add(context.WorkflowInstanceId.ToString, "Error Consume Work Item (" & _BookmarkName_Error & ") : " & ex.Message)
context.Track(customRecord)
context.SetValue(Me.Result, "N")

Thanks!

[MariiaI]

Unfortunately, this information is not enough to reproduce this issue, find the reason and the solution for you. Please provide us with your sample project with the corresponding DDL/DML scripts so that we are able to investigate this issue in more details, and specify the capacity of your application ( you can check the capacity of your application in Task Manager).
JIC: It is not necessary to send us the whole project, you could exclude those parts of the project that should not affect the reproducing the issue.