Merge System View is pointing to the Table not a system view

• Wednesday, November 14, 2012 4:55 PM

   

   
  

  0

  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.

  Any thoughts?

  • Reply
  • Quote