Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. FIX: Error message in Commerce Server 2002: "A Profile service limitation of 255 columns in the UserObject table exists"

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

View products that this article applies to.

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

↑ Back to the top

Cause

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

↑ Back to the top

Resolution

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

↑ Back to the top

Status

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

↑ Back to the top

Keywords: KB896057, kbpubtypekc, kbmsccsearch, kbbug, kbfix

↑ Back to the top

Article Info
Article ID : 896057
Revision : 1
Created on : 5/25/2006
Published on : 5/25/2006
Exists online : False
Views : 264