Uploaded image for project: 'C# Driver'
  1. C# Driver
  2. CSHARP-483

Error MongoDB.Driver.Linq.SelectQuery.BuildQuery

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 1.4.2
    • Component/s: None
    • Labels:

      my code:

      IQueryable<MessageOutbound> query = from mo in this.All() where !mo.IsSending && mo.RemainingRetryCount > 0 select mo;
      
      query = query.Where(mo => mo.DateLastAttempt.Value.Add(interval) <= DateTime.Now.ToUniversalTime());
      

      result:

      Unsupported where clause: (mo.DateLastAttempt.Value.Add(TimeSpan:(00:01:00)) <= DateTime:(2012-05-31T12:06:09.2683135Z)). 
      Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
      
      Exception Details: System.ArgumentException: Unsupported where clause: (mo.DateLastAttempt.Value.Add(TimeSpan:(00:01:00)) <= DateTime:(2012-05-31T12:06:09.2683135Z)).
      
      Stack Trace: 
      
      
      [ArgumentException: Unsupported where clause: (mo.DateLastAttempt.Value.Add(TimeSpan:(00:01:00)) <= DateTime:(2012-05-31T12:06:09.2683135Z)).]
         MongoDB.Driver.Linq.SelectQuery.BuildQuery(Expression expression) in C:\work\10gen\mongodb\mongo-csharp-driver\Driver\Linq\Translators\SelectQuery.cs:862
         MongoDB.Driver.Linq.SelectQuery.BuildQuery(Expression expression) in C:\work\10gen\mongodb\mongo-csharp-driver\Driver\Linq\Translators\SelectQuery.cs:827
         MongoDB.Driver.Linq.SelectQuery.Execute() in C:\work\10gen\mongodb\mongo-csharp-driver\Driver\Linq\Translators\SelectQuery.cs:132
         MongoDB.Driver.Linq.MongoQueryable`1.GetEnumerator() in C:\work\10gen\mongodb\mongo-csharp-driver\Driver\Linq\MongoQueryable.cs:81
         System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +382
         System.Linq.Enumerable.ToList(IEnumerable`1 source) +80
         Datavod.Core.Repositories.MessageOutboundRepository.GetNext(TimeSpan interval, Int32 blockSize) in N:\Development\datavod\datavod.core\Repositories\MessageOutboundRepository.cs:84
         Datavod.Core.Services.MessageService.GetNext(TimeSpan interval, Int32 blockSize) in N:\Development\datavod\datavod.core\Services\MessageService.cs:25
         Datavod.Core.BackgroundService.SendMessages.Run() in N:\Development\datavod\datavod.core\BackgroundService\SendMessages.cs:41
         Datavod.Core.BackgroundService.InProcessBackgroundServiceExecutor.Start() in N:\Development\datavod\datavod.core\BackgroundService\InProcessBackgroundServiceExecutor.cs:46
         Datavod.Core.Infrastructure.BootStrapperTasks.LoadBackgroundServices.Execute(IDictionary`2 state) in N:\Development\datavod\datavod.core\Infrastructure\BootStrapperTasks\LoadBackgroundServices.cs:40
         datavod.web.MvcApplication.Application_Start() in N:\Development\datavod\datavod.web\Global.asax.cs:128
      
      [HttpException (0x80004005): Unsupported where clause: (mo.DateLastAttempt.Value.Add(TimeSpan:(00:01:00)) <= DateTime:(2012-05-31T12:06:09.2683135Z)).]
         System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +4057141
         System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +191
         System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +352
         System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +407
         System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +375
      
      [HttpException (0x80004005): Unsupported where clause: (mo.DateLastAttempt.Value.Add(TimeSpan:(00:01:00)) <= DateTime:(2012-05-31T12:06:09.2683135Z)).]
         System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +11700896
         System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +141
         System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +4869125
      

            Assignee:
            robert@mongodb.com Robert Stam
            Reporter:
            nikolay@chistyakov.me Nikolay Chistyakov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: