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

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Jun 4, 2019
Version 7Show Document
  • View in full screen mode

Article Content

Article Number000030392
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Archer Control Panel (ACP), Database
RSA Version/Condition: 5.x, 6.x
IssueRecords cannot be effectively searched using the following methods:
  • Clicking Show All Records
  • Performing an Advanced Search for Records 
  • Performing a Quick Search when selecting a Solution known to contain the record(s)
  • Performing a Global Search
ResolutionFollow the steps below to resolve the issue.
  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]
    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])
    ALTER TABLE [dbo].[tblSearchMessageContent] CHECK CONSTRAINT [FK_tblSearchMessageContent_tblSearchMessageQueue]

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

    And the instance ID
  5. Start the RSA Archer Queuing Service.
  6. Open the RSA Archer Control Panel and select the Instance name. PLEASE NOTE: If you are using integrated security on the database tab, make sure you are logging into the RSA Archer Control Panel as the service account or an account that has permissions to the instance database. If you don't, you will get a message saying: "An error occurred requesting the rebuild. This error has been logged".
  7. Click the Rebuild Search Index button.
  8. The rebuild process is finished when the result of the following query is 0.  PLEASE NOTE:  The queuing service needs to process all priority 1 messages before it moves onto priority 3 messages, so it might some time for the query results to return 0.  Run the following 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.