升級至 9.9.2 版或更新版本後，在升級、端點啟用及登入 Dell Security Management Server 時顯示錯誤

受影響的產品：

• Dell Security Management Server

受影響的版本：

• v9.9.2 及更新版本

Dell Security Management Server 在 Dell Security Management Server 9.9.2 版及更新版本中推出了全文索引的要求。全文索引用於加速 Dell Security Management Server 與已設定 SQL 伺服器之間的資料庫呼叫。

SMS 安裝/升級期間顯示的錯誤：

未安裝全文索引時出現失敗：

圖 1：（僅限英文）SQL 伺服器需求遺失

全文索引停止時可能會出現失敗：

圖 2：（僅限英文）資料庫架構建立錯誤

登入嘗試期間顯示的錯誤：

圖 3：（僅限英文）發生內部錯誤

Security Servers output.log檔案顯示：

2017-12-21 18:04:38,544 WARN com.dell.ddps.exception.aop.AdminServiceExceptionMappingAspect [qtp1081046174-21] - org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT EID, CID, EntityType, EntitySubType, UID, DisplayName, Removed, Hidden, Guid FROM Entity WHERE CONTAINS(UID, ?) ORDER BY EID]; SQL state [S0001]; error code [30046]; SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.

2017-12-21 18:04:38,560 ERROR ADMINSERVICES [qtp1081046174-21] - adminService.login: com.dell.ddps.service.ServiceException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT EID, CID, EntityType, EntitySubType, UID, DisplayName, Removed, Hidden, Guid FROM Entity WHERE CONTAINS(UID, ?) ORDER BY EID]; SQL state [S0001]; error code [30046]; SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.

2017-12-21 18:04:38,575 ERROR ADMINSERVICES [qtp1081046174-21] - ServiceException thrown in webservice controller
com.dell.ddps.service.ServiceException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT EID, CID, EntityType, EntitySubType, UID, DisplayName, Removed, Hidden, Guid FROM Entity WHERE CONTAINS(UID, ?) ORDER BY EID]; SQL state [S0001]; error code [30046]; SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. Make sure that the FDHost process is running. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.

在目標 SQL 伺服器上未執行 的 SQL 完整測試篩選器精靈啟動器 服務可能是造成此問題的原因。

從 v9.9.2 開始，必須在 SQL 伺服器 上安裝 全文搜尋並 運作 。

如要聯絡支援部門，請參閱 Dell Data Security 國際支援電話號碼。
請前往 TechDirect，以線上產生技術支援要求。
如需更多深入見解與資源，請加入 Dell 安全性社群論壇。