Any odata filter on dates fields gives error 500

Trying to export all workItems by given a data but always give error 500. Tried filter other fields that are not date and is working fine.

Example: https://[xxxxxx].timehub.7pace.com/api/odata/v3.0/workItems?$filter=System_CreatedDate ge 2020-09-01T00:00:00Z

https://[xxxxxx].timehub.7pace.com/api/odata/v3.0/workItems?$filter=Microsoft_VSTS_Common_StateChangeDate ge 2020-09-01T00:00:00Z

Tried with workItemsFilter , apply, all methods and none of them work.

Export all workItems is very slow and need to get just the last changed/created.

Tested on postman and python.

{

"statusCode": 500,

"errorCode": "UnexpectedError",

"errorDescription": "Unexpected error occurred",

"fields": {

"originalMessage": "An error occurred while executing the command definition. See the inner exception for details.",

"originalStacktrace": " at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)\r\n at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)\r\n at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)\r\n at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass41_0.<GetResults>b__0()\r\n at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)\r\n at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__31_0()\r\n at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()\r\n at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)\r\n at Microsoft.AspNet.OData.Query.TruncatedCollection`1..ctor(IQueryable`1 source, Int32 pageSize, Boolean parameterize)\r\n at Microsoft.AspNet.OData.Query.ODataQueryOptions.LimitResults[T](IQueryable`1 queryable, Int32 limit, Boolean parameterize, Boolean& resultsLimited)"

}

Maxim Shestakov

September 25, 2020 14:23

Hi Iara!

Thank you for your message and my apologies for the issues you are experiencing.
I am forwarding your ticket and the information you provided to our technical team. We will post an update as soon as we will have details on it

Regards,
Maxim

September 29, 2020 12:04

Hi!

Our team checked and confirmed that there is a floating-issue with the Date filter.
Currently, it should work fine, but as the root cause is not fixed yet - it might appear in the future, so I've added a task to our backlog to investigate and fix it in future releases.
Could you please check if it is working now on your side?

Iara Rodrigues

September 29, 2020 12:42

Hi Maxim,

Thanks for the answer. Still have the same problem in all requests in dates.

I noticied that any request with any filter (not just dates) that can't get a fast response get the error 500. About 30s (used postman for the test).

If I use any filter that matches any register from 2013 works, but if just exists in a more recent date gives the error.

October 01, 2020 15:09

Could you please provide your DevOps organization name so we could check it further? If you do not want to post it publicly, please sent us an email at support@7pace.com

Any odata filter on dates fields gives error 500

Comments