Share-n-dipity

SharePoint serendipity is the effect by which one accidentally discovers something fortunate, especially while looking for something else entirely. In this case, it is the occassional musings, observations, and Ouija board readings about the phabulously

One of the request inputs is out of range Error with Azure Table Storage

One of the request inputs is out of range Error with Azure Table Storage

  • Comments 10
  • Likes

I wanted to document this error here because I recently went nearly blind trying to solve it, and I never did find the exact cause when Bing'ing for it.  Unfortunately it's a pretty generic error so it may very well have been out there, but it seems there are several reasons for it.  In my case I created a new instance of a class that I was adding to my Azure table but it kept failing with this "One of the request inputs is out of range" error that was driving me absolutely nuts.  Fortunately some bright individual pointed out to me that my class contained a DateTime property, and I wasn't initializing it.  Apparently the default DateTime.MinValue in .NET is outside the bounds of what Azure table storage supports.  So I just put in a dummy date in my property and - voila! - everything started working again.

So just a heads up in case you see this error yourself - it seems like a pretty easy one to miss.

Hope everyone has a happy holiday season!

Comments
  • please share if you find any documentation on this

  • msdn.microsoft.com/.../microsoft.windowsazure.storageclient.cloudtableclient.minsupporteddatetime.aspx

  • The most annoying thing is that dev storage doesn't enforce this restriction, so you get different results than running in live. There are various small corner cases like this (another is that DateTimes are silently truncated to milliseconds).

  • Came across this error using queues. Solution for my case:

    blog.codingoutloud.com/.../azure-error-one-of-the-request-inputs-is-out-of-range

  • Thanks for sharing this. It helped me..

  • Thanks a lot for this. It saved a day for us.

  • was scratching my head for a while on this one.

  • Thanks Steve, thankfully it didn't take me too long to find what's going wrong and come across your post.

  • Thank you, its useful

  • Thanks so much, this was driving me nuts because dev storage doesn't enforce this!

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment