ORA-00904:"BIGCOUNT":invalid identifier-Data Services Count

bartolomeo · Post by **bartolomeo** » Fri 18 Dec 2009 13:19

After applying ADO.NET Data Services Update for .NET Framework 3.5 on top of Entity Model implemented with dotConnect for Oracle, following error occurs when new count functionality is used:

Sample URL: http://localhost:3436/ReportingDataStor ... ENT/$count

Error Message:

An error occurred while processing this request.

Exception has been thrown by the target of an invocation.
System.Reflection.TargetInvocationException
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)

at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Data.Services.RequestQueryProcessor.GenerateQueryResult()
at System.Data.Services.RequestQueryProcessor.ProcessQuery()
at System.Data.Services.RequestQueryProcessor.ProcessQuery(IDataService service, RequestDescription description)

at System.Data.Services.RequestUriProcessor.ProcessRequestUri(Uri absoluteRequestUri, IDataService service)
at System.Data.Services.DataService`1.ProcessIncomingRequestUri()
at System.Data.Services.DataService`1.HandleRequest()

An error occurred while executing the command definition. See the inner exception for details.
System.Data.EntityCommandExecutionException

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.Single[TSource](IEnumerable`1 source)

at System.Data.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__2[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.LongCount[TSource](IQueryable`1 source)
at System.Data.Services.RequestQueryProcessor.CountQueryResult[TElement](IQueryable`1 query)

ORA-00904: "BIGCOUNT": invalid identifier
Devart.Data.Oracle.OracleException
at xc.u.d()
at Devart.Data.Oracle.bi.c()
at Devart.Data.Oracle.r.a(Int32 A_0, a4 A_1)

at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Devart.Data.Oracle.Entity.h.a.a(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.h.a.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)

Tnx in advance,
Bartul

AndreyR · Post by **AndreyR** » Mon 21 Dec 2009 09:36

Thank you for the report, we are investigating the problem.
I will let you know about the results of our investigation.

AndreyR · Post by **AndreyR** » Fri 25 Dec 2009 14:36

Thank you for your help, we have fixed the problem.
The fix will be available in the nearest build.

bartolomeo · Post by **bartolomeo** » Wed 13 Jan 2010 13:28

When approximately is new release expected?

That information is of great value to me because product trial period is running out and also I have implementation decision deadline approaching.

And btw, is there any way, considering circumstances, to extend my trial period?

AndreyR · Post by **AndreyR** » Thu 14 Jan 2010 09:51

The new build is available.
If you still need the extended trial, please let me know, I will send it to the e-mail available in your forum profile.

bartolomeo · Post by **bartolomeo** » Thu 14 Jan 2010 10:05

Please do.
It will help a lot, saving me the hassle of preparing test environment on fresh test server.
Thanks in advance.

AndreyR · Post by **AndreyR** » Thu 14 Jan 2010 11:10

I have sent the extended trial version to the email you have provided in your forum profile.