Can not add more then 42 items in the multivalued field of user profile

Question

Hello,

I'm trying to add about a 100 items to a multivalued field of the user object and it limits me to 42. Is there some config setting to over come this limitation? Any suggestion is greatly appreciated

Thanks
Vadim

Answer 1

The way multivalued fields are done in Commerce Server 2007 is that it concatenates the identies of the values. For example, for an address it uses the GUID. Since only about 7 GUIDs fit in the field, this means effectively you have only 7 address possible. More details are here.

http://www.theruntime.com/blogs/davebalzer/archive/2008/05/17/working-with-multi-value-fields-in-commerce-server-2007-profile-system.aspx

In some cases you can lengthen the field to reach your objective.

---

Hope this helps.

Regards

Glen (Software) Smith
CS2009 Training, Europe and North America: http://www.software-smith.com/
CS2007 book: http://www.software-smith.com/csbook

Answer 2

Thanks Glen,

I understand how multivalued fields work. I know how manipulate their values. That is not the issue. The issue is that i'm trying to set the multivalued field to an array with more then 42 items, but it only takes 42 and drops the rest. I have set the multivalued field type in the database to nvarchar(MAX) and I set a custom attribute MaxLength to 2147483647. Still, it only holds 42 ites in the multivalued field

Thanks
Vadim

Answer 3

I don't think we have such setting in commerce server. Can you run SQL profiler and check what date is going into SQL Server procedure/table.

---

http://techblog.ravikanth.net (If this post answers your question - Either Mark this post as the answer or vote as being useful.)

Answer 4

Thanks for the reply Ravi.

I ran profiler and i see that only 42 items are send in the update statement. Also i checked this in debug mode. After I set the multivalued field, I checked its value and it only has first 42 items. All others are lost. Looks like there is something going on inside "property set".

Any suggestions for a workaround? is there any way to contact someone on the Commerce Server team? I think it's kind of an important limitation and it's not documented anywhere

Thanks
Vadim