FIX: Snapshot Agent fails when you publish many tables using snapshot or transactional replication

Ισχύει για: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

Symptoms


Assume that you publish many tables (more than 1,000) by using snapshot or transactional replication. Snapshot Agent takes a long time to run, such as an hour, the agent may fail, and you may receive error messages that resemble the following:

Resolution


This fix is included in the following updates for SQL Server:

      Cumulative Update 4 for SQL Server 2016 Service Pack 2

      Cumulative Update 12 for SQL Server 2016 Service Pack 1

Workaround


To work around this issue, add the parameter "-prefechtables 0" to the snapshot agent job.

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 Microsoft uses to describe software updates.