|
Home > Archive > User Profile Management > December 2005 > A duplicate value for unique key member GeneralInfo.user_id found
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
A duplicate value for unique key member GeneralInfo.user_id found
|
|
| TechMate 2005-12-15, 5:58 pm |
| I am getting this error:
System.Runtime.InteropServices.COMException (0xC1004042): A duplicate value
for unique key member GeneralInfo.user_id found while building indices for
profile UserObject. Check the underlying store for uniqueness of the
property. at
Microsoft.CommerceServer.Interop.Profiles.ProfileServiceClass.CreateProfile(Object
sValue, String bstrType) at
Microsoft.CommerceServer.Runtime.Profiles.Profile..ctor(ProfileContext
profileService, String keyValue, String profileType, Boolean retrieveProfile)
I believe that duplicate GUID's are created when Anonymous accounts are
created.
Please help me get rid of this.
| |
| Jeff Lynch 2005-12-16, 5:54 pm |
| I don't think this is correct. A GUID (globally unique ID) is generated by
CS for each user that has a User Profile. The odds of generating a duplicate
GUID are pretty slim. The underlying SQL table has it's primary key set to
this field so it can't be NULL or duplicated. This error seems to indicate
that the SQL table contains a duplicate "user_id". The easiest way to check
this out is to runa simple query against the table to see if any duplicate
"user_id"'s exist.
--
Jeff Lynch
"Ramblings From A [Microsoft] Connected Universe"
http://codebetter.com/blogs/jeff.lynch
"TechMate" <TechMate@discussions.microsoft.com> wrote in message
news:70A31CAB-9E6E-4F54-AEE9-DBCE9FD4814A@microsoft.com...
>I am getting this error:
>
> System.Runtime.InteropServices.COMException (0xC1004042): A duplicate
> value
> for unique key member GeneralInfo.user_id found while building indices for
> profile UserObject. Check the underlying store for uniqueness of the
> property. at
> Microsoft.CommerceServer.Interop.Profiles.ProfileServiceClass.CreateProfile(Object
> sValue, String bstrType) at
> Microsoft.CommerceServer.Runtime.Profiles.Profile..ctor(ProfileContext
> profileService, String keyValue, String profileType, Boolean
> retrieveProfile)
>
> I believe that duplicate GUID's are created when Anonymous accounts are
> created.
>
> Please help me get rid of this.
|
|
|
|
|