crm 4.0 update error - Fulltextindex
-
20 มกราคม 2551 13:21
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.
ตอบทั้งหมด
-
20 มกราคม 2551 17:14ผู้ดูแล
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 1033I expect you'll have a different value in the last column (1033), as this is the langauge code
