Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
crm 4.0 update error - Fulltextindex RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

     

    Hello,

     

    can anybody help me?

    I want to update my crm 3.0 to crm 4.0 and i can't to this because I get the following error:

     

    19:04:19|   Info| Die folgenden Volltextindizes sind mit den Microsoft Dynamics CRM 3.0-Volltextindizes nicht konsistent:

    ==>(English version: The following Fulltextindex are not consistent with the Microsoft Dynamics CRM 3.0-Fulltextindex)

    19:04:19|   Info| tableowner:                             dbo
    19:04:19|   Info| tablename:                              documentindex
    19:04:19|   Info| fulltextkeyindexname:                   cndx_primarykey_documentindex
    19:04:19|  Error| remark:                                 modified full-text index
    19:04:19|  Error| 
    19:04:19|  Error| Die Volltextindizes in der Microsoft Dynamics CRM-Datenbank sind mit den Microsoft Dynamics CRM 3.0-Volltextindizes nicht konsistent.
    19:04:19|  Error| Check SqlFullTextIndexValidator : Failure: Die Volltextindizes in der Microsoft Dynamics CRM-Datenbank sind mit den Microsoft Dynamics CRM 3.0-Volltextindizes nicht konsistent.

    And I can't delete the Fullindex because it is a primary key.

     

     

    Sunday, January 20, 2008 1:21 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    It sounds like someone has modified the SQL full text index. You can find out the properties of the full text index using 2 SQL stored procedures (sp_help_fulltext_tables and sp_help_fulltext_columns). Try running them in the MSCRM database. The results I get from a standard CRM install are:

     

    sp_help_fulltext_tables

    dbo DocumentIndex cndx_PrimaryKey_DocumentIndex 1 1 ftcat_documentindex

     

    sp_help_fulltext_columns
    dbo 1205579333 DocumentIndex Title 9 NULL NULL 1033
    dbo 1205579333 DocumentIndex KeyWords 11 NULL NULL 1033
    dbo 1205579333 DocumentIndex SearchText 12 NULL NULL 1033

     

    I expect you'll have a different value in the last column (1033), as this is the langauge code

    Sunday, January 20, 2008 5:14 PM
    Moderator