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 15, 2018
Version 4Show 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]
    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 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 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 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. 

Attachments

    Outcomes