Showing posts with label agent. Show all posts
Showing posts with label agent. Show all posts

Sunday, February 12, 2012

Client Agent Error: integrity violation

Hello:

I tried to do the merge replication between SQL 2000 database and the SQL mobile server on PDA with SQL server management studio from SQL 2005 and I have already successfully synchronized my PDA with one small SQL server database file. However when I tried to synchronized my PDA with another larger SQL server database file, I got the error on PDA as following: “The row operation cannot be reapplied due to an integrity violation. Check the publication filter. [Table = AuditCriterion, operation = Insert, RowGuid = {1ee9321d-f00d-410c-8d5b-08d4220d2627}]”. I have keep checking the size of sdf file during synchronization, I found after the size of the sdf file stop increasing for about 20 mintues, then I got the error above. Morever, AuditCriterion table have a foreign key with another table AuditElement and I have not used publication filter at this stage.

Please help thanks.

Eddie

If AuditCriterion has as a foreign key with AuditElement have you included both tables in the publication?

If the table is missing the insert will fail because SQL Server 2000 cannot find the required primary key.

Thanks

Nabila Lacey

Friday, February 10, 2012

Clearing out snapshot folders

They should be removed by the cleanup agent, provided all subscribers have
been initialized. Do you have anonymous subscribers? That'll force them to
hang around until the retention period is reached. So - 2 things to check:
anonymous subscribers enabled and is the cleanup agent enabled...
HTH,
Paul Ibison
Have a look at sp_helpdistributiondb.
Cheers,
Paul
|||Hi,
i'm having the same issue as Dave...I have anonymous subscriptions,
clean up agent is enabled, retention period is set to 48hrs,
subscription expiriation is set to the default 14 days. but in the
repldata folder i have snapshots that have been created from months
ago.
how come they are not being cleaned up? what else do i need to check
besides what was already mentioned?
Thanks in advance
Steve
On May 19, 1:38 am, David Gray <g...@.turpin-distribution.com> wrote:
> 48hrs... That will be why then.
> Cheers
> Dave
> On Fri, 18 May 2007 07:28:04 -0700, Paul Ibison
>
> <Paul.Ibi...@.Pygmalion.Com> wrote:
> - Show quoted text -