Cannot Perform Merge of RLV Store

Problem: You receive an error message indicating that the RLV store cannot be merged with the IQ main store.

Explanation A

An RLV store merge was attempted on a table which was not RLV-enabled. Only tables which are RLV-enabled may be merged.

Explanation B

There was an error during the merge. Consult the database IQMSG file for possible exceptions or errors codes, which may describe a problem and allow you to perform a DML operation to address the item causing the issue.

For example, if there was an error inserting a row from the RLV store into the IQ main store, and the IQMSG file contained an exception on row X or value Y, it might be possible to:

Identify the source row
Save the row
Delete the row.

In this case, the merge should then succeed. The exported row could then be dealt with separately.