Devart Forums

skoub

Its difficult to trap the error because it's intermittent but i can confirm that the sql statement is not sent to the database (dbMonitor).

skoub

i have an intermittent problem. I get this error message in my application for no particular reason because when i call a refresh to this page, the problem disappear. The application can run for a few hours without problem and then decide to throw an exception. So i cannot give you a test projet for that particular reason.

I'm running my app with MVC5, Framework 4.5.2 and Devart v8.5.478.0 (also tried with v8.4.359.0).

Code: Select all

System.Data.Entity.Core.ProviderIncompatibleException: The provider did not create a CommandDefinition. ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at Devart.Common.Entity.ag.a(br A_0, br A_1)
   at Devart.Common.Entity.ep.a(ah A_0, DbCommand A_1)
   at Devart.Common.Entity.e6.a(ah A_0, DbCommandBase A_1)
   at Devart.Common.Entity.e6.c()
   at Devart.Data.Oracle.Entity.OracleEntityProviderServices.CreateDbCommandDefinition(DbProviderManifest baseProviderManifest, DbCommandTree commandTree)
   at System.Data.Entity.Core.Common.DbProviderServices.CreateCommandDefinition(DbProviderManifest providerManifest, DbCommandTree commandTree)
   --- End of inner exception stack trace ---
   at System.Data.Entity.Core.Common.DbProviderServices.CreateCommandDefinition(DbProviderManifest providerManifest, DbCommandTree commandTree)
   at StackExchange.Profiling.Data.EFProfiledDbProviderServices`1.CreateDbCommandDefinition(DbProviderManifest providerManifest, DbCommandTree commandTree)
   at System.Data.Entity.Core.Common.DbProviderServices.CreateCommand(DbCommandTree commandTree, DbInterceptionContext interceptionContext)
   at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.CreateCommand(DbModificationCommandTree commandTree)
   at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.CreateCommand(Dictionary`2 identifierValues)
   at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary`2 identifierValues, List`1 generatedValues)
   at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction)
   at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction)
   at System.Data.Entity.Internal.InternalContext.SaveChanges()
   at MTO.Sysgot.Web.Controllers.Pilotage.TypesOffresTouristiques.TypesOffresTouristiquesController.Add(Boolean isRepertoire, Nullable`1 typeOffreTouristiqueParentId, TypeOffreFormViewModel typeOffreFormViewModel)
   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.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass33.<BeginInvokeActionMethodWithFilters>b__32(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)
   at System.Web.Mvc.Controller.<BeginExecuteCore>b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
   at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
   at System.Web.Mvc.MvcHandler.<BeginProcessRequest>b__5(IAsyncResult asyncResult, ProcessRequestState innerState)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

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

skoub

Is it possible to have a follow up on this problem? I understand that it might not be on your side but is there any communication between you and Microsoft about a possible fix?

It would be great if you can keep us informed about the evolution of this bug since that everyone here will be impacted when they will installed NET 4.5!

thank you very much!

alex

skoub

i've just found another post about the same problem. We will continue the discussion there: http://forums.devart.com/viewtopic.php?f=30&t=24769

skoub

hi!

we have installed the Microsoft Framework 4.5 and since then, we have many outer apply or cross apply errors that we didnt had when we were on Framework 4.0.

Here's our project setup:
- Framework 4.0
- Entity Framework 4.3 CodeFirst
- DevArt v7.0.24 (and tried 7.2.114)

Before the Framework 4.5 installation, everything was fine. Every Linq Queries was working great. After the installation, even if the project was still on Framework 4.0 our linq queries began to generate some "outer apply" or "cross apply" errors.

here's an example of a cross apply error:

Code: Select all

var q = from depistage in this.appContext.DEPISTAGES                    
        where depistage.TypeDepistageId == 1 &&
              DateDebut <= depistage.DateDepistage &&
              DateFin >= depistage.DateDepistage &&
              depistage.AvisDepistages.FirstOrDefault().ResultatDepistageId == 1
        select depistage;

So my question is: why it was working before and now, with Framework 4.5 installed but not used in our solution, we get the outer/cross apply error so easly?

thank you for the help!

alex

skoub

hi!

i was using dotConnect for Oracle v6.50.237 with CodeFirst without any problems. Today, we have upgraded our project to v7.0.17 and now we get the error ORA-12704: character set mismatch.

I'm not sure where the problem come from but here's my research so far:

Here's the query that throw the 'character set mismatch' error:

Code: Select all

var q = from publication in this.appContext.Publications
            .Include(x => x.Transactions)
            .Include(x => x.PublicationsCommandes)
        select publication;

q.ToList();

If i test each entities one by one, everything is fine:

Code: Select all

this.appContext.Publications.ToList();
this.appContext.Transactions.ToList();
this.appContext.PublicationsCommandes.ToList();

If i remove one Include in the query, everything is fine:

Code: Select all

var q = from publication in this.appContext.Publications
            .Include(x => x.Transactions)
        select publication;

q.ToList();

// OR

var q = from publication in this.appContext.Publications
            .Include(x => x.PublicationsCommandes)
        select publication;

q.ToList();

So the problem is the 2 Includes at the same time. Here's the SQL generated by the query that throw the error:

Code: Select all

SELECT 
"UnionAll1".ID_PUBLC AS C1,
"UnionAll1".ID_PUBLC1 AS C2,
"UnionAll1".CODE AS C3,
"UnionAll1".TITRE AS C4,
"UnionAll1".DESCRIPTION AS C5,
"UnionAll1".POIDS AS C6,
"UnionAll1".DATE_ACTIF AS C7,
"UnionAll1".DATE_INACTIF AS C8,
"UnionAll1".NOTE AS C9,
"UnionAll1".ID_PERD AS C10,
"UnionAll1".ID_TYPE_PUBLC AS C11,
"UnionAll1".ID_PUBLC_PARNT AS C12,
"UnionAll1".QUANTITE_PAR_BOITE AS C13,
"UnionAll1".ID_INTER AS C14,
"UnionAll1".C1 AS C15,
"UnionAll1".ID_TRANS AS C16,
"UnionAll1".DATE_TRANSACTION AS C17,
"UnionAll1".QUANTITE AS C18,
"UnionAll1".ID_TYPE_TRANS AS C19,
"UnionAll1".ID_PUBLC2 AS C20,
"UnionAll1".ID_INTER_DE AS C21,
"UnionAll1".ID_INTER_A AS C22,
"UnionAll1".NOTE1 AS C23,
"UnionAll1".ANNEE_INVENTAIRE AS C24,
"UnionAll1".QUANTITE_PREMIERE_LIVRAISON AS C25,
"UnionAll1".CODE_UTILISATEUR_MAJ AS C26,
"UnionAll1".C2 AS C27,
"UnionAll1".C3 AS C28,
"UnionAll1".C4 AS C29,
"UnionAll1".C5 AS C30,
"UnionAll1".C6 AS C31,
"UnionAll1".C7 AS C32,
"UnionAll1".C8 AS C33
FROM  (SELECT 
	CASE WHEN "Extent2".ID_TRANS IS NULL THEN TO_NUMBER(NULL) ELSE 1 END AS C1,
	"Extent1".ID_PUBLC,
	"Extent1".ID_PUBLC AS ID_PUBLC1,
	"Extent1".CODE,
	"Extent1".TITRE,
	"Extent1".DESCRIPTION,
	"Extent1".POIDS,
	"Extent1".DATE_ACTIF,
	"Extent1".DATE_INACTIF,
	"Extent1".NOTE,
	"Extent1".ID_PERD,
	"Extent1".ID_TYPE_PUBLC,
	"Extent1".ID_PUBLC_PARNT,
	"Extent1".QUANTITE_PAR_BOITE,
	"Extent1".ID_INTER,
	"Extent2".ID_TRANS,
	"Extent2".DATE_TRANSACTION,
	"Extent2".QUANTITE,
	"Extent2".ID_TYPE_TRANS,
	"Extent2".ID_PUBLC AS ID_PUBLC2,
	"Extent2".ID_INTER_DE,
	"Extent2".ID_INTER_A,
	"Extent2".NOTE AS NOTE1,
	"Extent2".ANNEE_INVENTAIRE,
	"Extent2".QUANTITE_PREMIERE_LIVRAISON,
	"Extent2".CODE_UTILISATEUR_MAJ,
	TO_NUMBER(NULL) AS C2,
	TO_NUMBER(NULL) AS C3,
	TO_NUMBER(NULL) AS C4,
	TO_NUMBER(NULL) AS C5,
	CAST(NULL AS TIMESTAMP(9)) AS C6,
	CAST(NULL AS TIMESTAMP(9)) AS C7,
	TO_NCHAR(NULL) AS C8
	FROM  GIPI_NET.PUBLICATIONS "Extent1"
	LEFT OUTER JOIN GIPI_NET.TRANSACTIONS "Extent2" ON "Extent1".ID_PUBLC = "Extent2".ID_PUBLC
UNION ALL
	SELECT 
	2 AS C1,
	"Extent3".ID_PUBLC,
	"Extent3".ID_PUBLC AS ID_PUBLC1,
	"Extent3".CODE,
	"Extent3".TITRE,
	"Extent3".DESCRIPTION,
	"Extent3".POIDS,
	"Extent3".DATE_ACTIF,
	"Extent3".DATE_INACTIF,
	"Extent3".NOTE,
	"Extent3".ID_PERD,
	"Extent3".ID_TYPE_PUBLC,
	"Extent3".ID_PUBLC_PARNT,
	"Extent3".QUANTITE_PAR_BOITE,
	"Extent3".ID_INTER,
	TO_NUMBER(NULL) AS C2,
	CAST(NULL AS TIMESTAMP(9)) AS C3,
	TO_NUMBER(NULL) AS C4,
	TO_NUMBER(NULL) AS C5,
	TO_NUMBER(NULL) AS C6,
	TO_NUMBER(NULL) AS C7,
	TO_NUMBER(NULL) AS C8,
	TO_NCHAR(NULL) AS C9,
	TO_NUMBER(NULL) AS C10,
	TO_NUMBER(NULL) AS C11,
	TO_NCHAR(NULL) AS C12,
	"Extent4".ID_PUBLC_COMND,
	"Extent4".ID_PUBLC AS ID_PUBLC2,
	"Extent4".ID_COMND,
	"Extent4".QUANTITE,
	"Extent4".DATE_LIVRAISON_SOUHAITE,
	"Extent4".DATE_CONFIRMATION_COMPLETEE,
	"Extent4".COMMENTAIRE
	FROM  GIPI_NET.PUBLICATIONS "Extent3"
	INNER JOIN GIPI_NET.PUBLICATION_COMMANDE "Extent4" ON "Extent3".ID_PUBLC = "Extent4".ID_PUBLC) "UnionAll1"
ORDER BY "UnionAll1".ID_PUBLC1 ASC, "UnionAll1".C1 ASC

Is it a bug on your side or did i miss something on my side?

thank you for the help!

alex

skoub

I also have this problem. Everything was fine with v6.50.237 and today we have upgraded to v7.0.17 and now i get the error "ORA-12704: character set mismatch".

We are working with CodeFirst! What have changed since the v6.50.237??

skoub

A feature request to support the keyword MERGE. The documentation about this feature is here: http://www.oracle-base.com/articles/10g ... nts10g.php

thank you!

skoub

great! that is good news!!
thank you for the work

alex

skoub

we have opened an issue with Oracle and here's the reply that we've got:

this error is caused by unpublished bug 9298049.
This bug do not have any workaround and is not included in any 11.2.0.1 PSU or bundle patch.
The fix for this bug is included in 11.2.0.2 patchset.

we havent installed the 11.2.0.2 patch yet so we can't confirm that our bug is resolved. We might install it in the next few weeks.

alex

skoub

thank you!

skoub

hi!

i think i've found a bug with the designer when we change a property of a method.

1 - i have imported a stored procedure from Oracle that contain 1 parameter
2 - if a test the method, it return something from the database
3 - then a rename the parameter inside the method (just lowercase the name) and i must do the same with the stored procedure in the store (lowercase the name)
4 - i run the application and it will crash when i call the method. I get:

The data reader is incompatible with the specified 'MTO.DDS.Data.EF.Rapport2'. A member of the type, 'NoAtr', does not have a corresponding column in the data reader with the same name.

any idea?

alex[/list]

skoub

i have found why i get this error. I don't know why i get it but i've found the line that Oracle doesnt like.

If i remember right, i've found this piece of code in your forum:

Code: Select all

public partial class Entities : ObjectContext
    {
        partial void OnContextCreated()
        {
            DbConnection conn = (Connection as EntityConnection).StoreConnection;
            if (conn.GetType().Name == "OracleConnection")
            {
                conn.Open();
                ExecuteStoreCommand("ALTER SESSION SET NLS_COMP=LINGUISTIC");
                ExecuteStoreCommand("ALTER SESSION SET NLS_SORT=FRENCH_AI");
            }
        }
    }

and the line that cause the error is the ALTER SESSION SET NLS_COMP=LINGUISTIC

if you know why i get this error, please let me know. We will also search for a solution!

thank you!

alex

skoub

Hi!

i have a View that use the Oracle 11g Pivot function but it only work in the DevArt designer, not in my code. When i call my repository to get the data from the View, i receive this error:

Code: Select all

ORA-00600: code d'erreur interne, arguments : [qkngbAllocate.6], [], [], [], [], [], [], [], [], [], [], []

Like i said, in the DevArt designer, i can use "Retreive Data" and it work great. Any thought on this one?

alex

Devart Forums

Search found 32 matches

Re: The provider did not create a CommandDefinition

The provider did not create a CommandDefinition

Re: Devart Issues - Need your attention

Re: .NET 4.5 compatibility heads up

Re: Many outer/cross apply errors when Framework 4.5 is installed

Many outer/cross apply errors when Framework 4.5 is installed

ORA-12704: character set mismatch

Re: string length for VARCHAR2(4000)

feature request for the MERGE keyword

Bug when renaming a parameter of a EF4 Method

Oracle View with Pivot table problem