Unable to save Address profile "Literal value in the command exceeded…"-Collection of common programming errors

Tomas,

The maximum length of the UserObject profile’s “Address List” property is 255 characters since in the _profiles database in the UserObject table the “address_list” field is nvarchar(255). Since the address_id GUID is 38 characters long you can only store six (6) addresses in the “address_list” field.

The error you are seeing is being thrown by SQL Server back to the CS2007 runtime and basically says ” you’ve reached the limit for this property”.

I hope this explains the error.

Jeff Lynch

MVP – Commerce Server

http://codebetter.com/blogs/jeff.lynch