000038011 - Queuing service log message: "Level index rebuild" in RSA Archer

Document created by RSA Customer Support Employee on Oct 29, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000038011
Applies ToRSA Product Set: Archer
RSA Version/Condition: 6.x
IssueThe queuing service log contains the entry:

"Received a level (ID: [nnn]) index rebuild message for "[instance name]".

The database table tblSearchMessageContent contains Priority 2 records for each of the level's content IDs
CauseThe queuing service log message :

"Received a level (ID: [nnn]) index rebuild message for "[instance name]"

is caused by the deletion of a field. Deleting a field also results in the following database entries:

  • tblSearchMessageQueue: A single row with message type 3 (full index rebuild)
  • tblSearchMessageQueue: The type three message is processed quickly and then a single type 1 message (content update) is written
  • tblSearchMessageContent: A row is created for each content ID for the level. These rows have Priority 2.
The Priority 2 rows in tblSearchMessageContent are not processed until there are no Priority 1 rows (normal content adds and updates) in the table. So these rows do not normal indexing of record adds/updates.
When the Priority 2 rows are processed, content for the deleted field is removed from the index. Until that time, a search will return records that contained matching content in the deleted field.
ResolutionThe Priority 2 records will be processed and content for the deleted field will be removed from the index when there are no Priority 1 records to process.