徵狀

在您使用 [部署管理員] 匯入貴組織之後,在匯入的組織中 FullTextCatalogIndex 的系統作業將會停止運作並停留在 [等待] 狀態中。 如果您已套用 KB977867,就不會有這個問題。

原因

[匯入組織] 不會重新命名完整的文字目錄,而且已匯入的組織資料庫已儲存包含已備份組織的 GUID 的完整文字目錄。 系統作業嘗試執行完整的文字目錄更新,其中包含目前的組織識別碼 ftcat_documentindex_<OrganizationIdGuidValue> 然後改為 [等待] 狀態。

解決方案

若要解決此問題,請在您的組織資料庫上執行下列 SQL 腳本:

DECLARE @ID AS NVARCHAR(128),   @OLDNAME AS NVARCHAR(128),   @NEWNAME AS NVARCHAR(128),  @LINES AS INTSELECT @OLDNAME = name FROM  SYS.FULLTEXT_CATALOGS WHERE name LIKE 'ftcat_documentindex_%'SELECT @ID = OrganizationId FROM OrganizationSET @ID = REPLACE(@ID,'-','')SET @ID = LOWER(@ID)SET @NEWNAME = 'ftcat_documentindex_' + @IDPRINT 'GUID IS : '+@IDPRINT '---------------------'PRINT 'OLDNAME IS : '+@OLDNAMEPRINT '---------------------'PRINT 'NEWNAME IS : '+@NEWNAMEPRINT '---------------------'IF @OLDNAME!=@NEWNAMEBEGIN EXEC sp_fulltext_database 'enable'  -- Drop exsiting full text catalog PRINT 'START DROPPING EXSITING FULL TEXT CATALOG ..' PRINT '---------------------' IF  EXISTS (SELECT * FROM sys.fulltext_indexes fti WHERE fti.object_id = OBJECT_ID(N'[dbo].[DocumentIndex]')) BEGIN  ALTER FULLTEXT INDEX ON [dbo].[DocumentIndex] DISABLE END IF  EXISTS (SELECT * FROM sys.fulltext_indexes fti WHERE fti.object_id = OBJECT_ID(N'[dbo].[DocumentIndex]')) BEGIN  DROP FULLTEXT INDEX ON [dbo].[DocumentIndex] END SELECT @LINES = COUNT(*) FROM sysfulltextcatalogs ftc WHERE ftc.name = @OLDNAME IF  @LINES > 0 BEGIN  EXEC sp_fulltext_catalog @OLDNAME,'drop'  END PRINT 'DROPPING COMPLETE ..' PRINT '---------------------' -- Add new full text catalog PRINT 'START ADDING EXSITING FULL TEXT CATALOG ..' PRINT '---------------------' EXEC sp_fulltext_catalog @NEWNAME,'create' EXEC sp_fulltext_table 'documentindex', 'create', @NEWNAME, 'cndx_PrimaryKey_DocumentIndex'  EXEC sp_fulltext_column 'documentindex', 'Title', 'add'    EXEC sp_fulltext_column 'documentindex', 'KeyWords', 'add'    EXEC sp_fulltext_column 'documentindex', 'SearchText', 'add'    EXEC sp_fulltext_table 'documentindex', 'activate'    EXEC sp_fulltext_catalog @NEWNAME, 'start_full'  PRINT 'ADDING COMPLETE ..'ENDELSEPRINT 'THE FULL TEXT CATALOG HAS BEEN UPDATED ..'

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

How satisfied are you with the translation quality?
What affected your experience?

Thank you for your feedback!

×