Devart Issues - Need your attention

[san_eins]

Dear Devart Support Team,

This is regarding the issues that Devart is raising, which is causing our application failures on production environment. We have few windows services running on windows 2008 server, which are using “Devart DOT Connect” to connect to oracle database.

From past few days, we are seeing too many devart errors getting logged by these applications in event viewer. Few examples are shown below.

Could you please look into these and get back to us ASAP.

We are using Devart Dot Connect 6.3 version.

1)
DOT NET Error:
Application: Iata.IS.Service.InvoiceProcessorService.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.OracleQueue.Dequeue(Devart.Data.Oracle.OracleQueueDequeueOptions)
at Iata.IS.Framework.Service.ProcessingUnit.DoProcess()
at Iata.IS.Framework.Service.ServiceProcess`1[[System.__Canon, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].StartWorkerThread()
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()



Application Error:
Faulting application Iata.IS.Service.InvoiceProcessorService.exe, version 1.0.0.0, time stamp 0x54f45fc7, faulting module OraClient11.Dll, version 11.2.0.3, time stamp 0x4eb215e6, exception code 0xc0000005, fault offset 0x000000000009133a, process id 0x%9, application start time 0x%10.


2)
DOT NET Error:
Application: Iata.IS.Service.LegalArchiveRetrievalService.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
Stack:
at Devart.Data.Oracle.OracleConnection.BeginTransaction(System.Data.IsolationLevel)
at Iata.IS.Framework.Service.ProcessingUnit.DoProcess()
at System.Threading.Tasks.Task.Execute()
at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(System.Threading.Tasks.Task ByRef)
at System.Threading.Tasks.Task.ExecuteEntry(Boolean)
at System.Threading.ThreadPoolWorkQueue.Dispatch()
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()



Application Error:
Faulting application Iata.IS.Service.LegalArchiveRetrievalService.exe, version 1.0.0.0, time stamp 0x4f901f00, faulting module ntdll.dll, version 6.0.6002.18881, time stamp 0x51da3d16, exception code 0xc0000005, fault offset 0x000000000002574a, process id 0x%9, application start time 0x%10.

[Pinturiccio]

We are using Devart Dot Connect 6.3 version.

Try using the latest version of dotConnect for Oracle. You can download dotConnect for Oracle Trial from our site http://www.devart.com/dotconnect/oracle/download.html and test your application.

dotConnect for Oracle includes several fixes related to AccessViolationException made after version 6.3. For more information, please refer to http://www.devart.com/dotconnect/oracle ... story.html

[san_eins]

Dear Sam,

Thanks for the prompt reply. As recommended by you, we will try to upgrade to latest devart version.

We are also receiving the below error quite frequently in our application from Devart while opening DB connection or executing SQL query in database. Are these errors also going to be resolved after Devart upgrade or these error looks to be database errors to you.

We have provided below 2 errors with stack trace.

Please advise.

Error - 1)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Error Message: The underlying provider failed on Open.
StackTrace: 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 System.Data.Objects.ObjectContext.EnsureConnection() at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator() at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source) at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source, Expression`1 predicate) at Iata.IS.Business.MemberProfile.Impl.MemberManager.GetMemberCode(Int32 memberId) at Iata.IS.Win.OfflineCollectionDownloadSingleInstance.Program.Main(String[] args)

Inner Exception Message: Server did not respond within the specified timeout interval Inner Exception StackTrace: at Devart.Data.Oracle.a3.a(z A_0, ah A_1) at Devart.Data.Oracle.OracleInternalConnection..ctor(z connectionOptions, OracleInternalConnection proxyConnection) at Devart.Data.Oracle.cs.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)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Error - 2)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The error occured for Invoice No: , Billing Member: at 3/17/2015 1:01:37 AM

Details of Exceptions:

Method Name: StartPDFProcess()

Error Message: Server did not respond within the specified timeout interval Additional Info:

SPName=GETINVOICEFORPROCESS


StackTrace: at iPayables_PDFCreator.FOProcessor.StartPDFProcess()
at InvoicePDFCreator.Invoice_XmlFOP.Main()
at iPayables_PDFCreator.Common.GetNextProcessInvoices()
at iPayables_PDFCreator.FOProcessor.StartPDFProcess()
at iPayables_PDFCreator.Common.get_DataUOW()
at iPayables_PDFCreator.Common.GetNextProcessInvoices()
at iPayables_Data.UnitOfWork.Connect(ConnectionType Type)
at iPayables_PDFCreator.Common.get_DataUOW()
at Devart.Data.Oracle.a3.a(z A_0, ah A_1)
at Devart.Data.Oracle.OracleInternalConnection..ctor(z connectionOptions, OracleInternalConnection proxyConnection)
at Devart.Data.Oracle.cs.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 iPayables_Data.UnitOfWork.Connect(ConnectionType Type)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

[Pinturiccio]

In both cases you have got "Server did not respond within the specified timeout interval" exception. This exception occurs when connection establishing takes more time than the interval, specified in the 'Connection Timeout' connection string parameter. By default it is 15 seconds. We recommend you to increase the value of this parameter. For more information, please refer to http://www.devart.com/dotconnect/oracle ... meout.html

Are these errors also going to be resolved after Devart upgrade or these error looks to be database errors to you.

Probably no, because this is not a bug, this is the correct behavior when connection establishing takes more time than the interval, specified in the 'Connection Timeout' connection string parameter.

[san_eins]

Hi,

If we increase it more than 15 secs, what should be the ideal Timeout parameter.

Could you please let us know the best practice followed to set the "Connection Timeout".

Thanks
Manish

[Pinturiccio]

There is no ideal value for the 'Connection Timeout' connection string parameter. Each case would have it's own optimal value.

Could you please let us know the best practice followed to set the "Connection Timeout".

The 'Connection Timeout' connection string parameter should be increased in case of unstable network, overloaded database server or in other cases that decrease the speed of the server response.

[san_eins]

We have upgraded the devart version from 6.30.172.0 to 8.4.379.0 in our .Net application
and we are facing some issue due to upgradation as below:

1) System.Data.ConstraintException: The 'BillingPeriod' property on 'MiscBillingHistorySearchResult' could not be set to a 'null' value. You must set this property to a non-null value of type 'Int32'.
at System.Data.Common.Internal.Materialization.Shaper.ErrorHandlingValueReader`1.GetValue(DbDataReader reader, Int32 ordinal)
at System.Data.Common.Internal.Materialization.Shaper.GetPropertyValueWithErrorHandling[TProperty](Int32 ordinal, String propertyName, String typeName)
at lambda_method(Closure , Shaper )
at System.Data.Common.Internal.Materialization.Coordinator`1.ReadNextElement(Shaper shaper)
at System.Data.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Iata.IS.Data.MiscUatp.Impl.MiscInvoiceRepository.GetBillingHistoryCorrSearchResult(CorrespondenceSearchCriteria corrSearchCriteria, Int32 billingCategoryId)
at Iata.IS.Business.MiscUatp.Impl.MiscUatpInvoiceManager.GetBillingHistoryCorrSearchResult(CorrespondenceSearchCriteria corrCriteria, Int32 billingCategoryId)
at Iata.IS.Web.Areas.MU.Controllers.BillingHistoryControllerBase.BillingHistorySearchGridData(String criteria, Int32 billingCategoryId) in f:\Builds\1\SimplifiedInterlineSettlement\ISWEB - 64 BIT - Devart840\Sources\Iata.IS.Web\Iata.IS.Web.App\Areas\MU\Controllers\BillingHistoryControllerBase.cs:line 172
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)

2) System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
at Devart.Data.Oracle.Entity.y.b(Int32 A_0)
at System.Data.Common.Internal.Materialization.Shaper.ErrorHandlingValueReader`1.GetValue(DbDataReader reader, Int32 ordinal)
at System.Data.Common.Internal.Materialization.Shaper.GetPropertyValueWithErrorHandling[TProperty](Int32 ordinal, String propertyName, String typeName)
at lambda_method(Closure , Shaper )
at System.Data.Common.Internal.Materialization.Coordinator`1.ReadNextElement(Shaper shaper)
at System.Data.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Iata.IS.Data.Pax.Impl.InvoiceRepository.GetCorrespondenceTrailSearchResult(CorrespondenceTrailSearchCriteria correspondenceTrailSearchCriteria)
at Iata.IS.Business.Pax.Impl.InvoiceManager.GetCorrespondenceTrailSearchResult(CorrespondenceTrailSearchCriteria correspondenceTrailSearchCriteria)
at Iata.IS.Web.Areas.Pax.Controllers.CorrespondenceTrailController.CorrespondenceTrailSearchGridData(String criteria) in f:\Builds\1\SimplifiedInterlineSettlement\ISWEB - 64 BIT - Devart840\Sources\Iata.IS.Web\Iata.IS.Web.App\Areas\Pax\Controllers\CorrespondenceTrailController.cs:line 120
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)

3) System.Configuration.Provider.ProviderException: An exception occurred. Please contact your administrator.
at Devart.Common.Web.Providers.DbSessionStateStore.SetAndReleaseItemExclusive(HttpContext context, String id, SessionStateStoreData item, Object lockId, Boolean newItem)
at System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)


Please advice.

Thanks in advance

[Shalex]

1) System.Data.ConstraintException: The 'BillingPeriod' property on 'MiscBillingHistorySearchResult' could not be set to a 'null' value. You must set this property to a non-null value of type 'Int32'.

Try either setting Nullable=True for the 'BillingPeriod' property in 'MiscBillingHistorySearchResult' or make sure that this property is always initialized by your code (or, depending on your approach, by result set received from database).

2) System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
at Devart.Data.Oracle.Entity.y.b(Int32 A_0)
at System.Data.Common.Internal.Materialization.Shaper.ErrorHandlingValueReader`1.GetValue(DbDataReader reader, Int32 ordinal)

Looks like a bug in dotConnect for Oracle. Please localize the issue and send us a small test project with the corresponding DDL/DML script for reproducing.

3) System.Configuration.Provider.ProviderException: An exception occurred. Please contact your administrator.
at Devart.Common.Web.Providers.DbSessionStateStore.SetAndReleaseItemExclusive(HttpContext context, String id, SessionStateStoreData item, Object lockId, Boolean newItem)
at System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs)

There should be the inner exception which decribes the reason of the problem. If not, please send us a small test project with the corresponding DDL/DML script for reproducing.

[skoub]

I also have the problem:

Code: Select all

ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

but it's very difficult to send you a test project to reproduce it since that it's very intermittent. We can use the website all day long without the problem and for not particular reason, the problem appear on an INSERT command and probably on the UPDATE too. When the website goes to sleep or you reload it in memory, everything is fine again.

I'm presently on v8.4.359.0

[Shalex]

1. Specify the full call stack of the error with all inner exceptions if any.
2. Turn on the dbMonitor tool. Is there any failed SQL statement in dbMonitor when the application throws the ArgumentOutOfRangeException?
3. Please try to localize the issue and send us a small test project with the corresponding DDL/DML script for reproducing.