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

23 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. You’ve written nice post, I am gonna bookmark this page, thanks for info. I actually appreciate your own position and I will be sure to come back here.MenmyshopCar StereoDouble Din Android PlayerHyepersonic Double Din PlayerHyundai Creta Double Din Player
    CBSE open schoolcbse privatebanzaraonjourneyAdj online

    ReplyDelete
  5. 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
  6. Because I have a Hotmail account, so I found Hotmail login account for troubleshooting every problems. If you cannot find your problems any where, this website will help you.

    ReplyDelete
  7. Buy online wholesale printed custom cbd boxes and packaging at easy prices and shipping worldwide, with 24/7 customer support. Get a free custom quote now!!

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

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

    ReplyDelete
  10. Great Article
    Cloud Computing Projects




    Networking Projects



    Final Year

    Projects for CSE





    JavaScript Training in Chennai



    JavaScript

    Training in Chennai




    The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals,

    Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer.

    Angular Training

    ReplyDelete
  11. 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
  12. Blackbird packaging provide you with any size, shape design, custom soap boxes sooner than any other packaging competitor in the market

    ReplyDelete
  13. Blackbird packaging provide you with any size, shape design, wedding cookie boxes wholesale sooner than any other packaging competitor in the market

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

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

    ReplyDelete
  16. Buy men clothing online from Al-Fatah at best prices delivered at your doorstep. Get free shipping

    ReplyDelete
  17. 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
  18. 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
  19. 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