System.AccessViolationException

System.AccessViolationException

Postby dcoracle600pro » Mon 12 Aug 2013 21:46

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.
dcoracle600pro
 
Posts: 43
Joined: Mon 09 Apr 2012 09:57

Re: System.AccessViolationException

Postby Pinturiccio » Tue 13 Aug 2013 14:55

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

Re: System.AccessViolationException

Postby EmilyFong » Tue 21 Jan 2014 07:43

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()
EmilyFong
 
Posts: 12
Joined: Sun 20 May 2012 04:25

Re: System.AccessViolationException

Postby Pinturiccio » Wed 22 Jan 2014 16:06

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

Re: System.AccessViolationException

Postby EmilyFong » Thu 27 Feb 2014 05:50

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!
EmilyFong
 
Posts: 12
Joined: Sun 20 May 2012 04:25

Re: System.AccessViolationException

Postby MariiaI » Fri 28 Feb 2014 13:47

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.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17


Return to dotConnect for Oracle