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 Settings\user\Application Data\Microsoft\Mscrm\Logs\crm40svrsetup.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:

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:
   • KeyWords
   • SearchText
   • Title
4. 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.

This entry was posted on Tuesday, March 11th, 2008 at 6:21 am and is filed under CRM. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.