Microsoft Developer Network > Forums Home > Commerce Server Forums > Commerce Server 2007 > Can not add more then 42 items in the multivalued field of user profile
Ask a questionAsk a question
 

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

  • Saturday, November 07, 2009 1:28 AMlogicunit Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    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

All Replies

  • Saturday, November 07, 2009 8:51 PMSoftware-Smith Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    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
  • Saturday, November 07, 2009 9:55 PMlogicunit Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    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
  • Sunday, November 08, 2009 4:31 PMRavi Kanth KoppalaMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    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.)
  • Sunday, November 08, 2009 8:03 PMlogicunit Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    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