find a location for property in a new city

Thursday 25 August 2011

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

While trying to insert an entity into a Windows Azure Table Storage table I got the rather ambiguous "An error occurred while processing this request." error message from a System.Data.Services.Client.DataServiceRequestException. The inner exception help a message of "One of the request inputs is out of range."

The error message wasn't terribly helpful but I finally found what was causing the problem. It was because of my Row Key. The RowKey property that comes from the TableServiceEntity abstract class has specific requirements which I was unintentionally breaching.

My RowKey was calculated from another property of my Entity. In this particular instance this meant the string included a '/' symbol. This is not allowed by Table Storage for RowKeys.

Solution

When calculating the RowKey from the other property I am now removing special characters that the Azure Storage does not allow. This includes forward slash (/) character, backslash (\) character, number sign (#) character, question mark (?) character.

Old code:
private string productName;
public string ProductName
{
   get { return productName; }
   //setting the RowKey and productName to the same value in one go
   set { RowKey = productName = value; }
}
New code:
private string productName;
public string ProductName
{
   get { return productName; }
   set { RowKey = Regex.Replace(productName = value, @"[\ /?#]", ""); }
}
I actually already knew about this from when I read Apress's Windows Azure Platform but the confusing error message threw me off on a tangent and hoped it hadn't done the same to anyone else.

Follow britishdev on Twitter

18 comments:

  1. BTW this will happen with PartationKeys too.

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. how to retrieve all the table content without know Table fields name

    ReplyDelete
  4. Motifz Designer Lawn. 1, 2 & 3 Piece Unstitched Premium Embroidered Lawn 2019, Premium embroidered Lawn, Premium lawn, Premium lawn 2019, Motifz, Premium lawn in Pakistan. Shipping worldwide. Stitching option available.

    ReplyDelete
  5. Blackbird packaging provide you with any size, shape design, custom e liquid boxes sooner than any other packaging competitor in the market

    ReplyDelete
  6. Shop from a wide variety of Local and Imported hair masks and hair moisturizers available at Al-Fatah. Shop hair masks online and hair moisturizers in wide variety from favorite brands today available under one roof at Al-Fatah. Shop the best for your Hair. Avail Free Delivery on order above 1000pkr in selected cities only.

    ReplyDelete
  7. Blackbird packaging provide you with any size, shape design, custom soap boxes sooner than any other packaging competitor in the market

    ReplyDelete
  8. Buy shorts pakistan from ndure at best prices delivered at your doorstep. Get free shipping

    ReplyDelete
  9. Buy gym trousers mens online pakistan from dshred at best prices delivered at your doorstep. Get free shipping

    ReplyDelete
  10. Great post! Thank you for sharing post. This post is very informative for computer science students. Furthermore, If you are worried related to cleaning services then you should hire commercial cleaning Dallas tx for best and quality work.

    ReplyDelete
  11. You discuss related to azure table storage request in detail. I like your post. Further, This time to take advantages of Reverse osmosis filter chloramine shower filter California for quality water.

    ReplyDelete
  12. Thank you for sharing post with us. I like your post. I learn more through your post. Moreover, We present the best professional epoxy coating services as your desired requirements.

    ReplyDelete
  13. Borjan offers its customers the best driving moccs shoes for men online in Pakistan. We have the highest quality men's driving Moccasins in Pakistan for the most affordable prices. Get Borjan's amazing collection of men's Moccs online. Get your favorite men's driving Moccs from Borjan to keep yourself in style and comfort at the same time.

    ReplyDelete

  14. From Ndure buy the best quality wide leg trousers for women online at affordable price. Fast Shipping.

    ReplyDelete
  15. I like this post. Are you in need of custom thesis writing help at affordable rates? Let us help you, we offer top-quality writing hel online.

    ReplyDelete