Windows Azure Tables

I spent around 1 hour trying to resolve an error that i received while trying to query a table in Windows Azure Tables, the query was something like this

this.Users.Where( s=> s.UserID==userID).ToArray();

the error i received


System.Data.Services.Client.DataServiceQueryException was unhandled by user code
  Message="An error occurred while processing this request."

InnerException: System.Data.Services.Client.DataServiceClientException
Message="<?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"yes\"?>\r\n
<error xmlns=\"http://schemas.microsoft.com/ado/2007/08/dataservices/metadata\">\r\n
<code>InvalidInput</code>\r\n
<message xml:lang=\"en-US\">One of the request inputs is not valid.</message>\r\n
</error>"


after some research i found the following in the Azure SDK

Characters Disallowed in Key Fields
The following characters are not allowed in values for the PartitionKey and RowKey properties:

  • The forward slash (/) character
  • The backslash (\) character
  • The number sign (#) character
  • The question mark (?) character

My key field had some slashes :(

My bad !!, but in my defense the error message was not very clear :)

Comments

John Morrill said…
This helper me solve a similar problem. In my case the entities I defined in my Context inherited from other entities. It would appear the query client cannot use properties in the base classes as query parameters.
May 06, 2011 11:48 PM
Данил said…
thx!!!
In my case problem was in Partition Key, similar name with other pk name.
thx!
May 30, 2011 8:22 PM
Post a Comment

Popular posts from this blog

Documentum DQL Query Custom Data Extension For SQL Server Reporting Services

When it comes to Reporting SQL Reporting Services is my favorite choice. SQL Reporting Services has a plenty of data source types but unfortunately Documentum is not one of them, whenever we have to develop some reports based on the data in Documentum we first develop a web service that contains the necessary DQL queries and returns the result in a Data Set, then we create an XML data source that consumes this web service and use it in our reports. Fortunately SQL Reporting Services allows you to extend its data access capabilities by developing a custom data extension (CDE)that retrieves data from your custom data source. I developed a Custom Data Extension for Documentum that allows you to specify a Documentum Repository as a data source and provide your DQL query that will populate your report, I used the Reporting Services SDK Sample (FsiDataExtension) and this Article as starting points You can download the extension from here To install the extension: you have to install the ex
Read more

Portable Class Library Projects and MVVM Light

Image
With Portable Class Library Projects you can create a single library that can target different platforms (e.g. Windows Phone, .Net, Windows Store Apps). For most of the modern apps it’s kind of mandatory to use the MVVM pattern, a famous MVVM library is Laurent Bugnion MVVM Light library. In this post we will walk through the steps needed to create a Portable Class Library that uses the MVVM Light library and targets the Windows Phone 8 and .Net for Windows Store Apps frameworks. I will be using Visual Studio 2012 with Update 3. - Let’s create a new Portable Class Library project and name it MyApp.Core, the solution name will be MyApp - We will target the Windows Phone 8 and .Net for Windows Store Apps - We will create two applications, the first is a Windows Store Blank Application named MyApp.Win8 and the second is a Windows Phone 8 named MyApp.WP8 - We will add a reference to the Portable Class Library Project MyApp.Core to the Windows Store Project and the
Read more

Using taco to create Ionic projects for the Windows platform

Image
Recently Microsoft released Tools for Apache Cordova Command Line Interface (TACO CLI), by using TACO, you can quickly start building awesome Apache Cordova apps really and leave all the plumbing of the different platforms dependencies, plugins, etc. to the tools to take care of. For example the following few commands create a cordova project based on the ionic base template, add the android platform to the project, install the platform requirements, build the app, and run it in the emulator: $ taco create sampleApp --template https://github.com/driftyco/ionic-app-base $ cd sampleApp $ taco platform add android $ taco install-reqs android $ taco build android $ taco emulate android Check the TACO home page of for installation instructions and more information http://taco.tools/ . I ran into a problem when i created a new project based on the ionic base template and tried to run it on a windows 8.1 emulator, to reproduce the issue use the following taco commands to cr
Read more