Home Dashboard Directory Help
Search

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


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 872121
Opened: 5/12/2014 11:10:56 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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

Message:
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

@@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)

SERVERPROPERTY('productversion')

     11.0.3000.0

SERVERPROPERTY('productlevel')

     SP1

SERVERPROPERTY('edition')

     Enterprise Evaluation Edition (64-bit)

Thank you in advanced,

Melnichenko S.
Details
Sign in to post a comment.
Sign in to post a workaround.