Microsoft KB Archive/277485

= BUG: Profile Service Cannot Retrieve Profile Objects Successfully in the Retail Site =

Article ID: 277485

Article Last Modified on 10/22/2003

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition
 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q277485



SYMPTOMS
In a partitioned data store scenario, you may receive &quot;Object not found&quot; (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.

Additional query words: cs2k com2k object not found error message

Keywords: kbbug kbpending KB277485

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.