Problem: Transaction appears to hang.
Multiple connections may be waiting on a table-level write-lock. If the transactions are in progress when a foreground (blocking) merge of the RLV store and IQ main store is triggered, the transactions will appear to hang. To troubleshoot further, run the appropriate stored procedures from another connection to see if there are locks being held or a merge in progress.