Merge Publication - Snapshot Agent Error. Incorrect syntax near the keyword "and". - by Sergey Melnichenko

Status : 


Sign in
to vote
ID 872121 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 5/12/2014 11:10:56 AM
Access Restriction Public


I've been running Merge replication successfully. We use Pull subscriptions and Dynamic Snapshots. After a while we added new subscription and got the following error. After that this error occured on all subscription with every snapshot recreation.

Merge Agent

A dynamic snapshot is required because the publication 'XYZ' contains both dynamic filters and logical record relationships. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199439)
Get help: http://help/MSSQL_REPL-2147199439

Dynamyc Snapshot Agent

Error messages:
Message: Incorrect syntax near the keyword "and". 
Command Text: sp_MSmakesystableviews
Parameters: 	@publication = XYZ
	@create_dynamic_views = 1
	@max_bcp_gen = 9860

Stack:    в Microsoft.SqlServer.Replication.AgentCore.ReMapSqlException(SqlException e, SqlCommand command)
   в Microsoft.SqlServer.Replication.AgentCore.AgentExecuteReader(SqlCommand command, Int32 queryTimeout, CommandBehavior commandBehavior)
   в Microsoft.SqlServer.Replication.AgentCore.ExecuteWithResults(CommandSetupDelegate commandSetupDelegate, ProcessResultsDelegate processResultsDelegate, Int32 queryTimeout)
   в Microsoft.SqlServer.Replication.Snapshot.MergeSnapshotProvider.GenerateSystemTableBcpFiles()
   в Microsoft.SqlServer.Replication.Snapshot.MergeSnapshotProvider.DoPostArticleFilesGenerationProcessing()
   в Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
   в Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
   в Microsoft.SqlServer.Replication.AgentCore.Run() (Source: MSSQLServer, Error number: 102)
Get help: http://help/102
Server WIN-N3I74K7TM6T, Level 15, State 1, Procedure MSmerge_cont0FB2BCE28F284557B56688F2B5894919_90, Line 1
Incorrect syntax near the keyword "and". (Source: MSSQLServer, Error number: 102)
Get help: http://help/102

I’m running version


Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) 
	Oct 19 2012 13:38:57 
	Copyright (c) Microsoft Corporation
	Enterprise Evaluation Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)






     Enterprise Evaluation Edition (64-bit)

Thank you in advanced,

Melnichenko S.
Sign in to post a comment.