000037874 - RSA Archer usp_get_field_history_records_to_encrypt_and_decrypt blocks content save for 10+ minutes at a time

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

Article Content

Article Number000037874
Applies ToRSA Product Set: Archer
RSA Product/Service Type: RSA Archer (On-Premise)
RSA Version/Condition:
Platform: Windows
IssueThe stored procedure usp_get_field_history_records_to_encrypt_and_decrypt  blocks content save for 10+ minutes at a time, causing content save failure due to time out error.
CauseIn this version, there is a daily maintenance job that scans through every row in tblIVFieldHistory and checks the encryption of the history log entry against the encryption settings of the field. For large tblIVFieldHistory, this always fails with a time out and blocks any content save while running.
ResolutionUpgrade to a version of Archer that contains an index on the column dek_id in tblIVFieldHistory.  This was confirmed to significantly increase the speed of this stored procedure and reduce the amount of time that it blocks. 6.5 P2 and later was confirmed to have this index.
WorkaroundIf field encryption has never been enabled, and there is not any plan on enabling it, then you can dequeue the maintenance job that updates the encryption on the field's history log.
  1. Archer Control Panel -> Plugins -> job Engine Manager
  2. Menu -> System Jobs -> Encrypted Field History Data Toggle
  3. Dequeue Jobs -> Submit.
Important: If field encryption is going to be used then this job needs to be queued.