SQL Server Error Msg 21584 – Cannot insert the row for article ‘%s’. The row does not belong to the Subscriber’s partition, and the article has a value of 2 or 3 (nonoverlapping partitions) for the partition_options property. Nonoverlapping partitions do not allow out-of-partition inserts.

In this blog post, let’s learn about the error message “21584 – Cannot insert the row for article ‘%s’. The row does not belong to the Subscriber’s partition, and the article has a value of 2 or 3 (nonoverlapping partitions) for the partition_options property. Nonoverlapping partitions do not allow out-of-partition inserts.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

21584 – Cannot insert the row for article ‘%s’. The row does not belong to the Subscriber’s partition, and the article has a value of 2 or 3 (nonoverlapping partitions) for the partition_options property. Nonoverlapping partitions do not allow out-of-partition inserts.

Reason for the Error

To be update soon…

Solution

To be update soon…