Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
m_z_iqbal
Starting Member
28 Posts |
 Posted - 2009-04-06 : 08:45:32
|
| Hi All , I am getting this error, when doing Merge Subscription Synchornization, What is this, and how to fix it ? Command attempted:{call sp_MSsetconflicttable (N'tblSales', N'MSmerge_conflict_Sales_Publish_Caste', N'IQBAL', N'Sales_Pub', N'Sales_Publish')}Error messages:Incorrect syntax near 'caste_id'. (Source: MSSQLServer, Error number: 102)Get help: http://help/102The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)Get help: http://help/MSSQL_REPL-2147201001 |
|
|
zzzbla
Starting Member
13 Posts |
Posted - 2009-04-06 : 12:11:17
|
| Hi,Can you give more info? SQL version? Are you initializing the subscriber or is post-init? Was the subscriber initialized with snapshot?If the subscriber wasn't initialized with snapshot, the problem might be that you don't have the GUID column in the subscriber article.See here for more information: http://vladimirkofman.com/archive/2007/09/15/mss2005-merge-replication-error-incorrect-syntax-near.aspx |
 |
|
|
m_z_iqbal
Starting Member
28 Posts |
Posted - 2009-04-07 : 02:04:31
|
| i am using Sql Server 2005. The subscriber was not initialized with snapshot. It was done by backup and restore |
|
|
|
zzzbla
Starting Member
13 Posts |
Posted - 2009-04-07 : 02:45:32
|
| And you have a rowguid column in the table (both at the publisher and the subscriber)?Can you initialize the subscriber with snapshot? |
|
|
|
|
|
|
|
|
Merge Replicatio Conflict error