{"action":"opened","issue":{"url":"https://api.github.com/repos/OData/RESTier/issues/47","labels_url":"https://api.github.com/repos/OData/RESTier/issues/47/labels{/name}","comments_url":"https://api.github.com/repos/OData/RESTier/issues/47/comments","events_url":"https://api.github.com/repos/OData/RESTier/issues/47/events","html_url":"https://github.com/OData/RESTier/issues/47","id":59330701,"number":47,"title":"SQL issue when duration lenght greater than 1 day","user":{"login":"karataliu","id":10071498,"avatar_url":"https://avatars.githubusercontent.com/u/10071498?v=3","gravatar_id":"","url":"https://api.github.com/users/karataliu","html_url":"https://github.com/karataliu","followers_url":"https://api.github.com/users/karataliu/followers","following_url":"https://api.github.com/users/karataliu/following{/other_user}","gists_url":"https://api.github.com/users/karataliu/gists{/gist_id}","starred_url":"https://api.github.com/users/karataliu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/karataliu/subscriptions","organizations_url":"https://api.github.com/users/karataliu/orgs","repos_url":"https://api.github.com/users/karataliu/repos","events_url":"https://api.github.com/users/karataliu/events{/privacy}","received_events_url":"https://api.github.com/users/karataliu/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/OData/RESTier/labels/todo","name":"todo","color":"fef2c0"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-02-28T07:27:12Z","updated_at":"2015-02-28T07:27:12Z","closed_at":null,"body":"See case FilterBuiltInDateFunctions, when duration is > 1day, the exception is:\r\n\r\n\r\nMicrosoft.OData.Client.DataServiceRequestException : An error occurred while processing this request.\r\n---- Microsoft.OData.Client.DataServiceClientException : {\r\n  \"error\":{\r\n    \"code\":\"\",\"message\":\"An error has occurred.\",\"innererror\":{\r\n      \"message\":\"An error occurred while updating the entries. See the inner exception for details.\",\"type\":\"System.Data.Entity.Infrastructure.DbUpdateException\",\"stacktrace\":\"   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n   at Microsoft.Restier.EntityFramework.Submit.SubmitExecutor.<ExecuteSubmitAsync>d__0.MoveNext() in d:\\\\git\\\\DomainFramework\\\\src\\\\Microsoft.Restier.EntityFramework\\\\Submit\\\\SubmitExecutor.cs:line 24\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n   at Microsoft.Restier.Core.Submit.DefaultSubmitHandler.<PerformPersist>d__2d.MoveNext() in d:\\\\git\\\\DomainFramework\\\\src\\\\Microsoft.Restier.Core\\\\Submit\\\\DefaultSubmitHandler.cs:line 281\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()\\r\\n   at Microsoft.Restier.Core.Submit.DefaultSubmitHandler.<SubmitAsync>d__0.MoveNext() in d:\\\\git\\\\DomainFramework\\\\src\\\\Microsoft.Restier.Core\\\\Submit\\\\DefaultSubmitHandler.cs:line 100\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n   at Microsoft.Restier.Core.Domain.<SubmitAsync>d__19.MoveNext() in d:\\\\git\\\\DomainFramework\\\\src\\\\Microsoft.Restier.Core\\\\Domain.cs:line 707\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n   at Microsoft.Restier.WebApi.ODataDomainController`1.<Post>d__e.MoveNext() in d:\\\\git\\\\DomainFramework\\\\src\\\\Microsoft.Restier.WebApi\\\\ODataDomainController.cs:line 328\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__3`1.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()\",\"internalexception\":{\r\n        \"message\":\"An error occurred while updating the entries. See the inner exception for details.\",\"type\":\"System.Data.Entity.Core.UpdateException\",\"stacktrace\":\"   at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.<UpdateAsync>d__0.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Data.Entity.Core.Objects.ObjectContext.<ExecuteInTransactionAsync>d__3b`1.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Data.Entity.Core.Objects.ObjectContext.<SaveChangesToStoreAsync>d__37.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.<ExecuteAsyncImplementation>d__9`1.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Data.Entity.Core.Objects.ObjectContext.<SaveChangesInternalAsync>d__2f.MoveNext()\",\"internalexception\":{\r\n          \"message\":\"SqlDbType.Time overflow.  Value '1.01:00:00' is out of range.  Must be between 00:00:00.0000000 and 23:59:59.9999999.\",\"type\":\"System.OverflowException\",\"stacktrace\":\"   at System.Data.SqlClient.SqlCommand.<ExecuteDbDataReaderAsync>b__24(Task`1 result)\\r\\n   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()\\r\\n   at System.Threading.Tasks.Task.Execute()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.<ExecuteAsync>d__0.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.<UpdateAsync>d__0.MoveNext()\"\r\n        }\r\n      }\r\n    }\r\n  }\r\n}\r\nResult StackTrace:\t\r\nat Microsoft.OData.Client.SaveResult.HandleResponse()\r\n   at Microsoft.OData.Client.BaseSaveResult.EndRequest()\r\n   at Microsoft.OData.Client.DataServiceContext.SaveChanges(SaveChangesOptions options)\r\n   at Microsoft.OData.Client.DataServiceContext.SaveChanges()\r\n   at Microsoft.Restier.WebApi.Test.Scenario.TrippinE2ETestCases.FilterBuiltInDateFunctions() in d:\\git\\DomainFramework\\test\\ODataEndToEndTests\\Microsoft.Restier.WebApi.Test.Scenario\\TrippinE2ETestCases.cs:line 277\r\n----- Inner Stack Trace -----\r\n\r\n"}}