When I upgrade Microsoft Microsoft Dynamics CRM 3.0 to Microsoft Microsoft Dynamics CRM 4.0 i receive this error:
“The full-text indexes on the Microsoft Dynamics Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics Microsoft Dynamics CRM 3.0 full-text indexes.”
Installation log file from the installation found here:
C:\Documents and Settings\user\Application Data\Microsoft\Mscrm\Logs\crm40svrsetup.log
21:54:13| Info| tableowner: dbo
21:54:13| Info| tablename: documentindex
21:54:13| Info| fulltextkeyindexname: cndx_primarykey_documentindex
21:54:13| Error| remark: modified full-text index
I fix then was to create a new full-text catalog for the table. The steps I followed are:
1. Right-click the dbo.DocumentIndex table and select “Full-Text Index”
2. Select the defaults (click “Next”) until you get to the column selection.
3. Select the following columns to include in the index:
o KeyWords
o SearchText
o Title
4. Select the defaults the rest of the way through and name the catalog ftcat_documentindex.
This will cause another error in the Microsoft Dynamics CRM 4.0 setup, right-click the table again and choose “Disable Full-Text Index” from the “Full-Text Index” menu.