Prev: Subscription cannot be reinitialised after Replication was deleted
Next: How to set up replication from SQL Server 2005 to MySQL through ODBC
From: Magnus Lovsten on 18 Apr 2007 02:30
I've tried to enable verbose logging but I'm probably doing something wrong
cause I get this error when running the agent job.

Message
Executed as user: RED01\MobileReplication. The replication agent encountered
a failure. See the previous job step history message or Replication Monitor
for more information. The step failed.

What I've done is to add '-OutputVerboseLevel 2 -Output f:\sqlout.txt' to
the end of my agent job which was this:
-Publisher [SVR01\SQL2005] -PublisherDB [Comp1] -Distributor [SVR01\SQL2005]
-Publication [SM_Mobile_Comp1] -ReplicationType 2 -DistributorSecurityMode 1



"Magnus Lovsten" wrote:

> Additional info:
> Only way to get ride of this problem is for me to delete Comp1 publication,
> delete subscription Main-Comp1 and remove the Comp1 database. Then set
> everything up again. And it will run for some more days before the problem
> occurs again.
>
> "Magnus Lovsten" wrote:
>
> > I've got a republishing scenario.
> >
> > 3 databases:
> > - Main (central db with all customer data)
> > - Comp1 (serverside db with only Company 1 data)
> > - MobComp1 (mobile SQL db with same data as Comp1)
> >
> > Between Main and Comp1 I got a Merge replication with row filters (to select
> > the Company 1 data). This synchronized once every minute.
> > Between Comp1 and MobComp1 I got a another Merge replication. No filters.
> > This synchronized when my mobile app requestes it.
> >
> > Everything seems to be running fine for a few days. Then all of a sudden I
> > get this error in mobile app when trying to synch:
> > - A call to SQL Server Reconciler failed
> >
> > When looking in the Replication monitior I find this error:
> > Error messages:
> > The merge process could not enumerate deletions at the 'Publisher'.
> > Troubleshoot by restarting the synchronization with verbose history logging
> > and specify an output file to which to write. (Source: MSSQL_REPL, Error
> > number: MSSQL_REPL-2147201000)
> > Get help: http://help/MSSQL_REPL-2147201000
> > SELECT permission denied on object 'sysmergepartitioninfoview', database
> > 'vfmNewIdealMobile_SM_C60', schema 'dbo'. (Source: MSSQLServer, Error number:
> > 229)
> > Get help: http://help/229
> >
> > Any ideas?
> >
 | 
Pages: 1
Prev: Subscription cannot be reinitialised after Replication was deleted
Next: How to set up replication from SQL Server 2005 to MySQL through ODBC