Clustered Index in the Profiles System

There is a change in the Profiles System SourceDef table configuration that may affect you when you migrate from Commerce Server 2002 to Commerce Server 2007. The Profiles System SourceDef table contains information about the physical storage locations of profiles. In Commerce Server 2002, the SourceDef table had no constraints. However in Commerce Server 2007, it has a clustered index to the SourceName column. The clustered index makes sure that rows are retrieved from this table in alphabetical order.

The reason for this change was because of problems with data sources after multiple profile schema imports. If the order of the partitions in Commerce Server 2002 changed, for example the order of elements in the XML changed, the partitions became reversed. Therefore, the Profiles System could not find any profiles. This design change makes sure that the order never changes when you import profile schemas.