Erro exibido durante o upgrade, ativações de endpoint e login no Dell Security Management Server após o upgrade para a versão 9.9.2 ou posterior

Produtos afetados:

• Dell Security Management Server

Versões afetadas:

• v9.9.2 e posterior

O Dell Security Management Server introduziu um requisito para indexação de texto completo no Dell Security Management Server v9.9.2 e posterior. A indexação de texto completo está sendo usada para acelerar as chamadas de banco de dados entre o Dell Security Management Server e o SQL Server configurado.

Erros exibidos durante a instalação/upgrade do SMS:

Falhas vistas quando a indexação de texto completo não está instalada:

Figura 1: (Somente em inglês) Requisitos do SQL Server ausentes

Falha que pode ser vista quando a indexação de texto completo é interrompida:

Figura 2: (Somente em inglês) Erro de criação do esquema de banco de dados

Erros exibidos durante as tentativas de log-on:

Figura 3: (Somente em inglês) Ocorreu um erro interno

O arquivo security servers output.log mostra:

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.

O serviço SQL Full-test Filter Daemon Launcher não executado no SQL Server de destino pode ser a causa desse problema.

A partir da v9.9.2, a pesquisa de texto completo deve ser instalada e operacional no SQL Server.

Para entrar em contato com o suporte, consulte Números de telefone do suporte internacional do Dell Data Security.
Acesse o TechDirect para gerar uma solicitação de suporte técnico on-line.
Para obter insights e recursos adicionais, participe do Fórum da comunidade de segurança da Dell.