FIX: Replication Snapshot Agent May Fail with Access Violation Error When A Long Filter Clause is Used (243504)

MORE INFORMATION

The example that follows demonstrates this behavior.

Suppose you have a table named Orders in the publication and you define a horizontal filter on this table as:

Select * from Orders where Orders.emp_id in (select emp_id from Employees inner join Permanent_Employees on Employees.emp_id = Permanent_Employees.emp_id where Employees.emp_id = '10' )
				

This filter clause may cause the Snapshot agent to generate an access violation error because the filter clause exceeds 129 characters in length.

To avoid this error create a View object by using the view in your filter clause:

Create View V_Orders as Employees inner join Permanent_Employees on Employees.emp_id = Permanent_Employees.emp_id where Employees.emp_id = '10' 
				

You can then filter the Orders table with this condition:

Select * from Orders where Orders.emp_id in (select emp_id from V_Orders )
				

This filter clause design avoids the access violation behavior.