Sunday, March 11, 2012

28549Integrity Violation when sync between PDA and SQL server 20

Hi all,
I have a problem with replication. I did a search for error number 28549 in
this group and find no answer that matched my case. :-(
I have used replication for download data from sqlserver to pda. All the
tables a independent with each other. No link between them.
I have set the -ExchangeType 2 so that the synchronization is just one
direction from sql server to pda.
There aren't null data.
I have 50 users synchronize data. Some of users succeeded but most of them
failed.
The error is 28549-Integrity Violation...
I tried to copy the data file (.sdf) from pda of user succeeded in
synchronization. And then paste it to a new pda, synchronize again, and
that's so odd!!!! I met the same error!!!
I was confused, Can anyone help me out...
So appreciated
I have found that server have insert some rows that existing in
subscriptions. How can I find which row is conflict with db at subscriptions
at merge-agents. or at db server.
I have tried to delete merge_contents table, and it seems after that, all
subscriptions can not be regconized. All subscriptions are anonymous
subscriptions
"Mai Thoa" wrote:

> Hi all,
> I have a problem with replication. I did a search for error number 28549 in
> this group and find no answer that matched my case. :-(
> I have used replication for download data from sqlserver to pda. All the
> tables a independent with each other. No link between them.
> I have set the -ExchangeType 2 so that the synchronization is just one
> direction from sql server to pda.
> There aren't null data.
> I have 50 users synchronize data. Some of users succeeded but most of them
> failed.
> The error is 28549-Integrity Violation...
> I tried to copy the data file (.sdf) from pda of user succeeded in
> synchronization. And then paste it to a new pda, synchronize again, and
> that's so odd!!!! I met the same error!!!
> I was confused, Can anyone help me out...
> So appreciated
|||Please provide more detail about your setup, like, version of sql server,
kind of replication (replication over VPN or web sync using https), and in
which replication process are you getting this error?
thansk - Deepak
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Mai Thoa" <MaiThoa@.discussions.microsoft.com> wrote in message
news:09DF1BD7-55D6-473A-9FA0-BEA8B021603F@.microsoft.com...
> I have found that server have insert some rows that existing in
> subscriptions. How can I find which row is conflict with db at
subscriptions[vbcol=seagreen]
> at merge-agents. or at db server.
> I have tried to delete merge_contents table, and it seems after that, all
> subscriptions can not be regconized. All subscriptions are anonymous
> subscriptions
> "Mai Thoa" wrote:
in[vbcol=seagreen]
them[vbcol=seagreen]

No comments:

Post a Comment