SQL Server Errors or Failures from Error: 9955 to Error: 9978

SQLServerF1

 

Error: 9955, Severity: 16, SQL Server failed to create named pipe ‘%ls’ to communicate with the full-text filter daemon (Windows error: %d). Either a named pipe already exists for a filter daemon host process, the system is low on resources, or the security identification number (S
Error: 9959, Severity: 16, Cannot perform requested task because full-text memory manager is not initialized.
Error: 9960, Severity: 16, View ‘%.*ls’ is not an indexed view. Full-text index is not allowed to be created on it.
Error: 9961, Severity: 16, Logical name, size, maxsize, filegrowth, and offline properties of full-text catalog cannot be modified.

Error: 9962, Severity: 16, Failed to move full-text catalog from ‘%ls’ to ‘%ls’. OS error ‘%ls’.
Error: 9963, Severity: 10, Inconsistent accent sensitivity of full-text catalog is detected. Full-text catalog for catalog ID ‘%d’, database ID ‘%d’ is reset.
Error: 9964, Severity: 16, Failed to finish full-text operation. Filegroup ‘%.*ls’ is empty, read-only, or not online.
Error: 9965, Severity: 16, NULL or Invalid type of value specified for ‘%ls’ parameter.
Error: 9966, Severity: 16, Cannot use full-text search in master, tempdb, or model database.

Error: 9967, Severity: 10, A default full-text catalog does not exist in database ‘%.*ls’ or user does not have permission to perform this action.
Error: 9968, Severity: 10, Warning: No appropriate filter was found during full-text index population for table or indexed view ‘%ls’ (table or indexed view ID ‘%d’, database ID ‘%d’), full-text key value ‘%ls’. Some columns of the row were not indexed.
Error: 9969, Severity: 10, Warning: No appropriate wordbreaker was found during full-text index population for table or indexed view ‘%ls’ (table or indexed view ID ‘%d’, database ID ‘%d’), full-text key value ‘%ls’. Neutral wordbreaker was used for some columns of the row.
Error: 9970, Severity: 16, Couldn’t complete full-text operation because full-text key for table or indexed view ‘%.*ls’ is offline.
Error: 9971, Severity: 10, Warning: No appropriate filter for embedded object was found during full-text index population for table or indexed view ‘%ls’ (table or indexed view ID ‘%d’, database ID ‘%d’), full-text key value ‘%ls’. Some embedded objects in the row could not be inde
Error: 9972, Severity: 16, Database is not fully started up or it is not in an ONLINE state. Try the full-text DDL command again after database is started up and becomes ONLINE.
Error: 9973, Severity: 10, Informational: Full-text %ls population paused for table or indexed view ‘%ls’ (table or indexed view ID ‘%d’, database ID ‘%d’). Number of documents processed: %d. Number of documents failed: %d.
Error: 9974, Severity: 10, Warning: Only running full population can be paused. The command is ignored. Other type of population can just be stopped and it will continue when your start the same type of crawl again.
Error: 9975, Severity: 10, Warning: Only paused full population can be resumed. The command is ignored.
Error: 9977, Severity: 10, Warning: Last population complete time of full-text catalog in directory ‘%ls’ does not match database ‘%.*ls’. The full-text catalog is attached and it may need to be repopulated.
Error: 9978, Severity: 10, Warning: During upgrade full-text index on table ‘%ls’ is disabled because at least one of full-text key column, full-text columns, or type columns is a non-deterministic or imprecise nonpersisted computed column.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *