I received the following error in the environmental diagnostics wizard during an upgrade to CRM 4.0:
“The full-text indexes on the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM 3.0 full-text indexes.”
After some research, MS article 927226 pointed me to the log file from the installation found here:
C:Documents and SettingsuserApplication DataMicrosoftMscrmLogscrm40svrsetup.log
Looking for the error message towards the bottom of the log, I found where it referenced the table with the inconsistency. this section of the log looked like this:
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
Looking at the table in question, dbo.DocumentIndex, I was able to determine that it didn’t have any full-text indexes. After some research, I discovered that it was in fact suppoed to…you can run the following commands to check this:
Command: sp_help_fulltext_tables
Expected Results:
dbo DocumentIndex cndx_PrimaryKey_DocumentIndex 1 1 ftcat_documentindex
Command: sp_help_fulltext_columns
Expected Results:
dbo 1205579333 DocumentIndex Title 9 NULL NULL 1033
dbo 1205579333 DocumentIndex KeyWords 11 NULL NULL 1033
dbo 1205579333 DocumentIndex SearchText 12 NULL NULL 1033
The fix then was to create a new full-text catalog for the table. The steps I followed are:
- Right-click the dbo.DocumentIndex table and select “Full-Text Index”
- Select the defaults (click “Next”) until you get to the column selection.
- Select the following columns to include in the index:
- KeyWords
- SearchText
- Title
- Select the defaults the rest of the way through and name the catalog ftcat_documentindex.
After creating the full-text catalog, full-text indexing will be enabled on that table. This will cause another error in the CRM 4.0 setup, so right-click the table again and choose “Disable Full-Text Index” from the “Full-Text Index” menu.
As always, if you are looking for professional Microsoft CRM Consulting for assistance with installation, migration, or upgrade, contact Kazmarek Technology Solutions directly.