The 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.
In 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.
Upgrade 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.
If 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.
Archer Control Panel -> Plugins -> job Engine Manager
Menu -> System Jobs -> Encrypted Field History Data Toggle
Dequeue Jobs -> Submit.
Important: If field encryption is going to be used then this job needs to be queued.