AccessViolationException with dotConnect 6.10

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
FredFred
Posts: 4
Joined: Thu 20 Mar 2014 15:12

AccessViolationException with dotConnect 6.10

Post by FredFred » Fri 13 Feb 2015 11:24

Hello,

I'm using DotConnect for Oracle 6.10 with oracle 11.2.0.2.0 and I have some AccessViolation exception on my production server (Windows Server 2008 and web services WCF host on IIS).
Do you have an explanation or maybe a correction of this issue with a latest version?
Here under the stack trace from the windows event viewer :
Thanks for your help

Application: w3wp.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.AccessViolationException Stack: at OciDynamicType.nativeOCIHandleFree(System.Runtime.InteropServices.HandleRef, Int32) at OciDynamicType.OCIHandleFree(System.Runtime.InteropServices.HandleRef, Int32) at Devart.Data.Oracle.a5.b(System.Object) at System.Threading.ThreadHelper.ThreadStart_Context(System.Object) 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(System.Object)

FredFred
Posts: 4
Joined: Thu 20 Mar 2014 15:12

Re: AccessViolationException with dotConnect 6.10

Post by FredFred » Fri 13 Feb 2015 12:02

In my application log, I have also this exception below... (hope it helps)

System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> Devart.Data.Oracle.OracleException: ORA-24324: service handle not initialized
at Devart.Data.Oracle.a0.b(Int32 A_0)
at Devart.Data.Oracle.a2.a(Int32 A_0, bk A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Devart.Data.Oracle.Entity.e.a(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.e.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
--- End of inner exception stack trace ---
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
at System.Data.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__1[TResult](IEnumerable`1 sequence)
at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
at Services.Atlas.DAOContexteMetier.GetEquipmentReference(String serviceConsumerId)
at Services.Atlas.DAOEquipement.BuildEquipmentDeclaration(String consumerId)
at ServerShared.ServerTools.SvcOperationContext(String serviceConsumerIdStr, Object[] values)
at Services.ServiceEquipment.CheckMGS400ServerStatusAndSendHeartBeat(String serviceConsumerId)
at SyncInvokeCheckMGS400ServerStatusAndSendHeartBeat(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage41(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
2015-02-09 11:26:52,019 Error (null) Default Supervision - Problème lors de l'envoi de la trap sur SSUPSNMP.big.lan : Erreur SendSecureTrap : System error: Le nom demandé est valide, mais aucune donnée du type requise n’a été trouvée
2015-02-09 11:26:52,971 Error (null) Default Supervision - Problème lors de l'envoi de la trap sur SSUPSNMP.big.lan : Erreur SendSecureTrap : System error: Le nom demandé est valide, mais aucune donnée du type requise n’a été trouvée
2015-02-09 11:26:53,111 Error 00004 Default Erreur lors de la lecture dess infos DaoScar
System.Data.EntityException: The underlying provider failed on Open. ---> Devart.Data.Oracle.OracleException: Server did not respond within the specified timeout interval
at Devart.Data.Oracle.a5.a(ae A_0, a8 A_1)
at Devart.Data.Oracle.OracleInternalConnection..ctor(ae connectionOptions, OracleInternalConnection proxyConnection)
at Devart.Data.Oracle.cq.a(i A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, i A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
at Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.Oracle.OracleConnection.Open()
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
--- End of inner exception stack trace ---
at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
at System.Data.EntityClient.EntityConnection.Open()
at Services.OperationContext.SvcOperationContext.OpenScarEntityContext[T](T context)
at Services.OperationContext.SvcOperationContext.GetEntityContext[T](Boolean temporary)
at Services.OperationContext.OperationContextManager.GetEntityContext[T](Boolean temporary)
at Services.Scar.DaoScarBase.EntityContextDefaultGetter(Boolean temporary)
at Services.Scar.DaoScarInformationDosCli.GetSingleInformations()
2015-02-09 11:26:55,373 Error (null) Default An error occurred while executing the command definition. See the inner exception for details.
System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> Devart.Data.Oracle.OracleException: ORA-24324: service handle not initialized
at Devart.Data.Oracle.a0.b(Int32 A_0)
at Devart.Data.Oracle.a2.a(Int32 A_0, bk A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Devart.Data.Oracle.Entity.e.a(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.e.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
--- End of inner exception stack trace ---
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
at System.Data.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__1[TResult](IEnumerable`1 sequence)
at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
at Services.Atlas.DAOContexteMetier.GetEquipmentReference(String serviceConsumerId)

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: AccessViolationException with dotConnect 6.10

Post by Shalex » Mon 16 Feb 2015 12:36

There were a number of fixes (also related to AccessViolationException) after the 6.10 version: http://www.devart.com/dotconnect/oracle ... story.html. Please try using the latest (8.4.352) build of dotConnect for Oracle. If you do not have access to the licensed v8.4.352, check the functionality of a trial to make sure that the issue is fixed. If this doesn't help, send us a small test project with the corresponding DDL/DML script and specify the steps we should follow for reproducing.

FredFred
Posts: 4
Joined: Thu 20 Mar 2014 15:12

Re: AccessViolationException with dotConnect 6.10

Post by FredFred » Mon 16 Feb 2015 14:44

ok thanks for your answer,
We have the latest dotconnect release but not integrated yet...
And we don't reproduce in our test plateforme...
we're going to use your latest version...
thanks

Post Reply