PRB: Error Occurs When You Validate a Profile with a Property Mapped to Uniqueidentifier (296327)
The information in this article applies to:
- Microsoft Commerce Server 2002
- Microsoft Commerce Server 2000
This article was previously published under Q296327 SYMPTOMS
When you validate a profile that contains a property that is mapped to a field of datatype uniqueidentifier, the following errors may occur:
Could not load profile 'xyz'.
Error 1: Microsoft OLE DB Provider for SQL Server : Syntax error converting from a character string to uniqueidentifier.
Error 2: Microsoft Commerce OLE DB Provider : One or more errors occurred during processing of command.
Do you want to continue validating the profiles?
Yes No
The error above is followed by:
Invalid Profile
One or more profiles may be invalid.
CAUSE
The validate profile utility in the Commerce Server Manager attempts to write a hard-coded string or number to the specified field. In this case, it does not write a valid GUID, and an error is generated. A similar error occurs if you attempt to validate a profile that is mapped to a read-only property in AD.STATUS
This behavior is by design.
| Modification Type: | Major | Last Reviewed: | 10/22/2003 |
|---|
| Keywords: | kbpending kbprb KB296327 |
|---|
|