MSSQL_REPL-2147199398
Applies to: SQL Server Azure SQL Managed Instance
Message Details
Attribute | Value |
---|---|
Product Name | SQL Server |
Event ID | -2147199398 |
Event Source | MSSQLServer |
Symbolic Name | |
Message Text | The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the article at the Subscriber. This can occur when there are pending DDL changes waiting to be applied at the Subscriber. Restart the Merge Agent to apply the DDL changes and synchronize the subscription. |
Explanation
When the merge process is propagating changes from the Subscriber to the Publisher, it compares the version of the replication stored procedures that is being used by the Merge Agent with the version of the stored procedures at the Publisher. If a DDL change occurred while the merge process was running, a schema mismatch could be detected.
User Action
Retrying the merge process should fix the problem, because the Merge Agent will start using the version of the replication stored procedures present at the Publisher.
Internal-Only
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for