000030392 - How to perform a Search Index Rebuild in RSA Archer

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Sep 23, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000030392
Applies ToRSA Product Set: Archer
RSA Version/Condition: All
IssueRecords cannot be effectively searched by either:
  1. Clicking Show All Records
  2. Performing an Advanced Search for Records 
  3. Performing a Quick Search when selecting a Solution known to contain the record(s)
  4. Performing a Global Search
Resolution
  1. Log on to Queuing Server Specified in the RSA Archer Control Panel
  2. Stop the RSA Archer Queuing Service
  3. Perform the following command against your RSA Archer Instance Database (you will need db owner privileges to the database) 

    IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_tblSearchMessageContent_tblSearchMessageQueue]') AND parent_object_id = OBJECT_ID(N'[dbo].[tblSearchMessageContent]'))
    ALTER TABLE [dbo].[tblSearchMessageContent] DROP CONSTRAINT [FK_tblSearchMessageContent_tblSearchMessageQueue]
    GO
     
    TRUNCATE TABLE dbo.tblSearchMessageContent
     
    TRUNCATE TABLE dbo.tblSearchMessageQueue
     
    ALTER TABLE [dbo].[tblSearchMessageContent]  WITH CHECK ADD  CONSTRAINT [FK_tblSearchMessageContent_tblSearchMessageQueue] FOREIGN KEY([message_id])
    REFERENCES [dbo].[tblSearchMessageQueue] ([message_id])
    GO
     
    ALTER TABLE [dbo].[tblSearchMessageContent] CHECK CONSTRAINT [FK_tblSearchMessageContent_tblSearchMessageQueue]
    GO


  4.  Delete the existing Index Files including the Instance Id folder that they are contained in.  The Search Index location can be found through the RSA Archer Control Panel.  This folder structure is re-created when the Search Index Rebuild Process is finished.  Based on the images below as an example, delete the 50000 directory.

    And the instance ID
     
     
  5. Start the RSA Archer Queuing Service.
  6. Open the RSA Archer Control Panel and select the Instance name.
  7. Click the 'Rebuild Search Index' Button.
  8. The rebuild process is finished when the result of the following query is 0.  Run SQL command against the Instance database.

    SELECT COUNT(*) FROM dbo.tblSearchMessageQueue smq WHERE smq.priority_type_id = 3


NotesIf you have multiple RSA Archer instances running in one environment, the indexing process starts with the first instance and then moves forward.
The indexing is a single threaded process.  For example, if you have instances 50000 and 50001, make sure to complete index rebuild for 50000 first and then 50001. 

Attachments

    Outcomes