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

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

Postby 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
bartolomeo
 
Posts: 3
Joined: Fri 18 Dec 2009 13:02

Postby 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
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby 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?
bartolomeo
 
Posts: 3
Joined: Fri 18 Dec 2009 13:02

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby 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.
bartolomeo
 
Posts: 3
Joined: Fri 18 Dec 2009 13:02

Postby AndreyR » Thu 14 Jan 2010 11:10

I have sent the extended trial version to the email you have provided in your forum profile.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle