When using the database adapter to connect to a source SharePoint environment, the error message below is encountered. It may also appear during the migration.
"The count aggregate operation cannot take a unique identifier data type as an argument."
This is a known issue when using an older Content Matrix version with a SharePoint farm that is using SQL Server 2000 for the content databases. It does not support aggregate operations in SQL queries.
The issue has been resolved as of Content Matrix 7.0.0.2. However, if an upgrade cannot be performed, you may either use a different connection adapter or upgrade the SQL Server to version 2005 or 2008.
