I get error while I update a row in immediate updating subscription what is the cause?
Posted by Karthick P.K on September 15, 2010
Error:
{
Another user has modified the contents of this table or view; the database row you
are modifying no longer exists in the database.
Database error: ‘[Microsoft][ODBC SQL Server Driver][SQL Server]Updatable
Subscriptions: Rows do not match between Publisher and Subscriber. Run the
Distribution Agent to refresh rows at the Subscriber.
[Microsoft][ODBC SQL Server Driver][SQL Server]Updatable Subscriptions: Rolling
back transaction.’
}
In Transactional Replication with immediate updating subscription
Update to a row in subscriber which is already updated in publisher is not
possible.
When we update the row in subscriber it compares the value of msrepl_tran_version
in Publisher and subscriber. If it matches then update is allowed.
If msrepl_tran_version in Publisher and subscriber doesn’t match Update is not
possible for that row in subscriber.
This entry was posted on September 15, 2010 at 6:29 PM and is filed under Replication. Tagged: Another user has modified the contents of this table or view; the database row you are modifying no longer exists in the database, Replication, Transactional replication, Transactional replication fails. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
