Article Number: 000125164
The Dell Security Management Server introduced a requirement for Full-Text Indexing within the Dell Security Management Server v9.9.2 and later. Full Text Indexing is being used to hasten the database calls between the Dell Security Management Server and the configured SQL server.
Failures seen when Full Text Indexing is not installed:
Figure 1: (English Only) SQL Server Requirement Missing
Failure that may be seen when Full Text Indexing is stopped:
Figure 2: (English Only) Database Schema Creation Error
Errors Displayed During Logon Attempts:
Figure 3: (English Only) An internal error occurred
The Security Servers output.log file shows:
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.
The SQL Full-test Filter Daemon Launcher service not running on the target SQL server may be the cause of this issue.
Starting with v9.9.2, full text search is required to be installed and operational on the SQL server.
To contact support, reference Dell Data Security International Support Phone Numbers.
Go to TechDirect to generate a technical support request online.
For additional insights and resources, join the Dell Security Community Forum.
Dell Encryption
23 Jan 2024
9
Solution