FIX: Error message in Commerce Server 2002: "A Profile service limitation of 255 columns in the UserObject table exists" (896057)



The information in this article applies to:

  • Microsoft Commerce Server 2002

SYMPTOMS

In Microsoft Commerce Server 2002, you may receive an error message that resembles the following:
A Profile service limitation of 255 columns in the UserObject table exists. The UserObject table has been extended to more than 255 columns.
Error: ID 0x8002000B
Message ID: E_MSCOP_MSCSDB3_INTERNALERROR

CAUSE

This problem occurs because the Profile service limits the UserObject table to 255 columns.

RESOLUTION

To resolve this problem, use join keys to aggregate the profile definition over multiple tables.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Modification Type:MajorLast Reviewed:5/25/2006
Keywords:kbfix kbBug kbmsccsearch kbpubtypekc KB896057 kbAudDeveloper kbAudITPRO