Search is a key mechanism that members of your community will use to locate content that they are interested in. You must Install and configure search for your community. If you are having difficulty using search, please review how to troubleshoot search.
The information below helps you reset your default content search index; Ideas content search index, or Calendar content search index.
The Telligent Community search provider uses a powerful search engine to furnish search results as well as index content sent from Telligent products. The search index is self-updating and will add and remove content as it changes on your site. The search results are trimmed based on the user's roles. If for some reason the index becomes corrupt or has invalid data, you can manually delete and reindex the content on the site.
The primary reason for reindex your site would be if the search results are not the expected results or they have data that is not correct.
Reasons this may occur:
To reset the search index, there are two tasks that need to be performed:
Stop the Tomcat service using the tray icon or through the Services MMC. If using the MMC, look for "Apache Tomcat."
Delete your existing index by renaming or deleting the Index folder. (Delete the whole folder, not just the content in it. Solr will recreate it in %ProgramFiles%\Apache Software Foundation\Tomcat 7.0\Solr\data\.)
Restart the indexing service by starting Tomcat.
To manually reindex default content, you need access to the database where the content is contained and permission to run SQL scripts against the database. Each object type that maps to a Search Content Mapper can be reset.
Here is the script that resets all default content:
/* Resets all default content types */
delete from cs_Search_Queue
exec te_SearchIndex_Update null, null, 0
If you want to reindex Ideas content manually, this content is not included with the default content and requires a different script:
/* Resets ideas content */exec [telligent_Ideas_ReindexAll]
If you want to reindex Calendar content manually, this content is not included with the default content and requires a different script:
/* Resets calendar content*/exec [telligent_Calendar_ReindexAll]
Due to the fact that this should only be done in rare cases, you should keep in mind a few items to think about prior to resetting your index on a live site:
Error Indexing Attachment : [Filename=document.pdf ]System.ApplicationException: TextFilter error: CommunityServer.Components.Search.TextFilterException: IFilter instance not found for file C:\Windows\TEMP\1000.69.1626.document.pdf at CommunityServer.Components.Search.TextFilter.áÃƒâ€šÃ‚ÂÂÃƒâ€šÃ‚ÂÂ() at CommunityServer.Components.Search.TextFilter.áÃƒâ€šÃ‚ÂÂÃƒâ€šÃ‚ÂÂ() at CommunityServer.Components.Search.TextFilter..ctor(String file) at CommunityServer.Search.MappingExtension.GetAttachmentText(PostAttachment attachment) Search Indexing 9/23/2009 2:26:41 PM WEB1 500 Warning 1000
You do not need to have Windows Search index 'D:"; it can be removed. The indexing task copies (and deletes) attachment to the Windows TEMP folder.
Download the Adobe PDF iFilter (http://www.adobe.com/support/downloads/detail.jsp?ftpID=2611). Starting after Adobe 6.0, 32-bit servers only require that you install Adobe Reader to get the iFilter. But for 64-bit servers, you need a different download: http://www.adobe.com/support/downloads/detail.jsp?ftpID=4025.
Install the Microsoft filter pack.
Install Windows Search (if you have not already done so).
To be prudent, recycle application pool so you can be certain that the indexing task is refreshed.
For testing, flag posts that have attachments to be reindexed:
UPDATE [dbo].[te_Blog_Posts] SET [IsIndexed] = 0
WHERE PostID IN (select ContentId from te_Attachments where IsRemote = 0 and ApplicationTypeId = 1)
UPDATE [dbo].[te_Forum_Threads] SET IsIndexed = 0
WHERE ThreadId IN (select ContentId from te_Attachments where IsRemote = 0 and ApplicationTypeId = 0 and ApplicationContentTypeId = 0)
UPDATE [dbo].[te_Forum_ThreadReplies] SET IsIndexed = 0
WHERE ThreadReplyId IN (select ContentId from te_Attachments where IsRemote = 0 and ApplicationTypeId = 0 and ApplicationContentTypeId = 1)
UPDATE [dbo].[te_FileGallery_Files] SET IsIndexed = 0
To check the index for documents that have attachment text, you can issue the following query against your Solr instance:
(Notes: Keep in mind that there is an almost 30-second delay before the documents are committed to the Solr index, so be patient. Also, do a hard refresh in the browser to avoid the browser caching the results.)
http://[your Solr Server]:8080/solr/select/?q=attachmenttext:[*+TO+*]&sort=indexed_at+desc&fl=attachmentname,indexed_at&rows=100
If you see the following error approximately every minute, it may be due to an known issue with escaping reserved characters in some search situations.
SearchUnknownError Thu, April 15, 2010, 10:13 AM 10002 User Agent:Path: as HTTPReferrer:Message: There was an error processing search queue message '37334515-7301-474a-9ce5-d3ec852443a6'. Http error in request/response to http://localhost:8080/solr/update/System.Exception: Http error in request/response to http://localhost:8080/solr/update/at CommunityServer.Search.Solr.WebRequests.Post(String url, Byte bytesToPost, String& statusDescription)at CommunityServer.Search.Solr.SolrSearchIndexProvider.RemoveFromIndexByQuery(SearchQuery query)at CommunityServer.Search.Tasks.DeleteQueryRunner.Execute()
Telligent has identified a potential root cause for this issue and has released an update which does not observe the general causes for this error. For assistance, please submit a ticket to Telligent Support with the exception details along with the specific version of the product you have deployed, the Solr version you have installed, and the Catalina log file.
Telligent Systems, Inc. ©2012, All Rights Reserved
Telligent Systems, Inc. ©2013, All Rights Reserved