Devart Issues - Need your attention

Devart Issues - Need your attention

Postby san_eins » Wed 18 Mar 2015 07:01

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.
san_eins
 
Posts: 8
Joined: Wed 29 Feb 2012 11:32

Re: Devart Issues - Need your attention

Postby Pinturiccio » Wed 18 Mar 2015 15:11

san_eins wrote: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/revision_history.html
Pinturiccio
Devart Team
 
Posts: 1869
Joined: Wed 02 Nov 2011 09:44

Re: Devart Issues - Need your attention

Postby san_eins » Thu 19 Mar 2015 06:37

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)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
san_eins
 
Posts: 8
Joined: Wed 29 Feb 2012 11:32

Re: Devart Issues - Need your attention

Postby Pinturiccio » Fri 20 Mar 2015 15:15

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/docs/?Devart.Data.Oracle~Devart.Data.Oracle.OracleConnection~ConnectionTimeout.html

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

Re: Devart Issues - Need your attention

Postby san_eins » Mon 23 Mar 2015 09:55

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
san_eins
 
Posts: 8
Joined: Wed 29 Feb 2012 11:32

Re: Devart Issues - Need your attention

Postby Pinturiccio » Tue 24 Mar 2015 16:36

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

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

Re: Devart Issues - Need your attention

Postby san_eins » Wed 15 Jul 2015 11:47

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
san_eins
 
Posts: 8
Joined: Wed 29 Feb 2012 11:32

Re: Devart Issues - Need your attention

Postby Shalex » Fri 17 Jul 2015 11:56

san_eins wrote: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).

san_eins wrote: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.

san_eins wrote: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.
Shalex
Devart Team
 
Posts: 7393
Joined: Thu 14 Aug 2008 12:44

Re: Devart Issues - Need your attention

Postby skoub » Fri 21 Aug 2015 17:59

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
skoub
 
Posts: 32
Joined: Fri 21 May 2010 15:47

Re: Devart Issues - Need your attention

Postby Shalex » Tue 25 Aug 2015 07:41

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.
Shalex
Devart Team
 
Posts: 7393
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle