Wednesday, November 14, 2012 4:55 PM
When I added a table (SFA_Brand_Family) to a merge publication I received a strange error when I tried to generate the publication snapshot. (Cannot drop table SFA_Brand_Family using drop view command). I tried to add it again and it let me but I have issues when generating partitioned snapshots related to this table.
If I pull this table out of the publication no issues applying the partitioned snapshot. When it is in the publication I get the following error:
‘The Merge Agent was unable to generate a partitioned snapshot for this subscription; either the Snapshot Agent failed to run or the location for the partitioned snapshot could not be accessed. The subscription will be initialized using a standard snapshot.’
However the snapshot file was created and is accessible.
The sync continues then I get this error:
‘11/14/2012 10:52:25 AM - Enumerating inserts and updates in article 'SFA_Brand_Family' (generation batch 1)
11/14/2012 10:52:25 AM - The merge process could not enumerate changes at the 'Publisher'. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.
11/14/2012 10:52:25 AM - The merge process could not enumerate changes at the 'Publisher'. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.’
Also, when I run sp_helpmergearticle the system lists all the views used for articles but this table references itself??
SFA_Chain_Profile_Type dbo MSmerge_FieldSalesDownloadOnly_SFA_Chain_Profile_Type_VIEW
SFA_Brand_Family dbo SFA_Brand_Family
SFA_Class_Trade dbo MSmerge_FieldSalesDownloadOnly_SFA_Class_Trade_VIEW
I cannot drop the publication and recreate it I also cannot drop all the subscriptions and recreate them.
Wednesday, November 14, 2012 5:00 PMModeratorAre you publishing views as well as tables? This error might make sense if there was a view using the base table. From that I see this looks like merge replication system view which should not throw up these errors.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
Thursday, November 15, 2012 6:54 PM
I am not publishing views in this publication. The issue is when I add this particular table to the publication the system will not create the replication system views need for replication. See the bottom section of my original post. The other tables have system views created this one does not.Can I force the system to generate replication system views for an article?