Kazmarek

Free Site Analysis 1-858-952-5400
REMOTE ASSISTANCE
  • Home
  • OnGoing Management
  • IT Services
    • Microsoft 365, Exchange Services, and Consulting
    • Cloud Solutions
    • Virtualization
    • Mobility
    • Backup & Disaster Recovery
    • Server Installation/Migration
    • VoIP
    • Network & System Administration
    • Additional Solutions
  • Why Kazmarek
    • Case Studies
    • Testimonials
    • KTS Values
  • For Clients
    • O365 Log In
    • Client Portal
    • KTS Documents
    • SonicWALL VPN Client
  • News
    • Newsletters
  • Who We Are
    • Company
    • Team
    • KTS E-Award Winners
    • KTS Values
    • Charities We Support
  • Contact Us
    • Contact Us
    • Careers

Full-Text Index Inconsistency When Upgrading to CRM 4.0

March 11, 2008 by Kazmarek Administrator

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:

  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.

Categories

  • Active Directory
  • Backup Exec (All Versions)
  • Blackberry / Blackberry Enterprise Server
  • Citrix
  • Cool Tech Stuff
  • CRM
  • Dell
  • Exchange 2007
  • Exchange 2010
  • Exchange 2013
  • Exchange Hosted
  • Exchange Server
  • Group Policy
  • IIS
  • Kaseya
  • kazmarek
  • MacOS
  • Microsoft
  • Networking
  • newsletter
  • Office
  • Office 365
  • Office Communications Server
  • OfficeScan
  • Outlook
  • Printing
  • SBS 2003
  • SBS 2008
  • SBS 2011
  • Server 2003
  • Sharepoint
  • Spyware
  • SQL
  • Symantec
  • Terminal Server
  • Thawte
  • Trend Micro
  • Uncategorized
  • Virtual Server
  • Websense
  • Windows 7
  • Windows Mobile
  • Windows Server 2008
  • Windows Server 2012
  • Windows Vista
  • Windows XP Pro/Home
Copyrights: © 2023 Kazmarek. All rights reserved.

Designed by TinyFrog & N Halie Designs