FIX: Cannot query or migrate data from a local Stretch-enabled table after you execute sys.sp_rda_reconcile_batch

Symptoms

Consider the following scenario:
  • You delete some batches from the recovery point objective (RPO) table and from remote Azure tables when you use Microsoft SQL Server 2016.
  • You execute sys.sp_rda_reconcile_batch on a local Stretch-enabled table to reconcile local and remote batch IDs.
  • You restore the remote Azure tables to a restore point.
In this scenario, you can no longer migrate data from the local Stretch-enabled table to the remote Azure tables. Additionally, when you execute a query that queries data from the remote Azure tables, you receive an error message that resembles the following:
Cannot query table '%.*ls' because data reconciliation is in progress. This is part of the automatic recovery process for a remote data archive enabled table. You may check the status of this operation in sys.remote_data_archive_tables.


Resolution

The issue was first fixed in the following cumulative update of SQL Server:
Recommendation: Install the latest cumulative update for SQL Server

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

Learn about the terminology that Microsoft uses to describe software updates.
Properties

Article ID: 3174076 - Last Review: Jul 26, 2016 - Revision: 1

Feedback