Replication error is SQL 2005 - increase the -OutputVerboseLevel setting

Dear Experts,

I'm doing replication is SQL 2005 in everytime I got this error message:

"A row update at 'CData1' could not be propagated to CData1'. This failure can be caused by a constraint violation. The Merge Agent was unable to synchronize the row due to one or more unanticipated errors in the batch of changes. When troubleshooting, increase the -OutputVerboseLevel setting, restart the agent, and check for and resolve any errors generated by the dat"

Any idea or possible leads to resolve this issue?

Thanks,

Microsoft SQL Server 2005DatabasesMicrosoft SQL Server

Last Comment

JaimeJegonia

8/22/2022 - Mon

gova

5/31/2007

Do you have any constraints setup for that particular field?

JaimeJegonia

6/1/2007

ASKER

Yes, there's. Is it not possible to have constraint set with replicated database?

gova

6/1/2007

May be the data is not consistent with the datatypes or is it going against the constraint set?

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Walt Forbes

JaimeJegonia

6/1/2007

ASKER

What happened is, Cdata2 is only a standly (inactive) replicator yet it is the one complaining. But the active CData1 has no error. If I go aganist constraint set, it must be stopped at active box not only in the replicated box. Anymore idea?

Thanks,

BTW : this is supposed to be "A row update at 'CData1' could not be propagated to CData2'

ASKER CERTIFIED SOLUTION

JaimeJegonia

7/24/2007

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.