Modul Memuat Kesalahan Pengecualian Saat Mencoba Menggunakan Pengindeksan Teks Lengkap Di Situs DNN Anda

Kesalahan Pengecualian Pemuatan Modul Saat Mencoba Menggunakan Pengindeksan Teks Lengkap Di Situs DNN Anda

Masalah
Ketika Anda mencoba menggunakan modul yang menggunakan pengindeksan teks lengkap, Anda menerima galat yang mirip dengan berikut ini:DotNetNuke.Services.Exceptions.ModuleLoadException: 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. ---> System.Data.SqlClient.SqlException: 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. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, String spName, Object[] parameterValues) at Active.Modules.Forums.SqlDataProvider.Search_FullText(Int32 PortalId, Int32 ModuleId, Int32 UserId, Int32 ForumId, Boolean IsSuper, Int32 RowIndex, Int32 MaxRows, String SearchString, Int32 MatchType, Int32 SearchField, Int32 Timespan, Int32 AuthorId, String Author, String Forums, String Tags, String ForumsAllowed) at Active.Modules.Forums.af_search_new.BindPosts(Int32 Column, String Sort) at Active.Modules.Forums.af_search_new.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
Penyebab
Layanan Pengindeksan Teks Lengkap SQL Server tidak diinstal atau tidak berjalan di bawah akun pengguna yang benar.

Resolusi
Jika Anda menggunakan server shared hosting, maka masalah tersebut harus diselesaikan oleh Teknisi Dukungan.

1. Masuk ke server Anda melalui Desktop Jarak Jauh.
2. Klik Mulai> Jalankan (Windows - R). Ketik Services.msc dan tekan Enter .
3. Telusuri Peluncur Daemon Filter Teks Lengkap SQL (MSSQLSERVER)
4. Klik kanan pada layanan dan pilih Properti
5. Setel properti berikut di atasnya:
   • Umum> Jenis Startup =Otomatis
   • Masuk> Masuk Sebagai =Akun Sistem Lokal
6. Klik Oke .
7. Klik kanan pada layanan dan pilih Mulai ulang .
8. Tutup kotak Layanan.