BUG: Profile Service Cannot Retrieve Profile Objects Successfully in the Retail Site (277485)


The information in this article applies to:

  • Microsoft Commerce Server 2002
  • Microsoft Commerce Server 2000
This article was previously published under Q277485

SYMPTOMS

In a partitioned data store scenario, you may receive "Object not found" (E_PS_OBJECT_NOT_FOUND or DB_E_NOTFOUND) errors when you create, retrieve, modify, or delete a profile object. The occurrence of this error depends on whether the profile system performed the operation against the correct partition.

CAUSE

This problem occurs because of a limitation in the ANSI-SQL component of the profile system. The ANSI-SQL component cannot retrieve profile objects by a non-hashing key property value.

WORKAROUND

To work around this problem, define the same property as the primary key, the join key, and the hashing key on the profile definition.

STATUS

Microsoft has confirmed that this is a problem in Microsoft Commerce Server 2000.
Modification Type:MajorLast Reviewed:10/22/2003
Keywords:kbbug kbpending KB277485
©2003 Microsoft Corporation. All rights reserved.