sqlce Error 28557 during replication

[Michael Morisoli]

I have a .net app using sqlce replication to sql2k.

I had a few issues setting up replication the first time, but after I got it
working it seemed to work well. Then I discovered that when I would make
simple changes to the db schema and recreate the subscriptions the PPC would
start to encounter the runtime error 28557 and could not sync.

I searched MSDN and could find a few references to check constraints on
identity columns. I have removed everything down again to a simple db and I
can not get replication to work again.

Does anybody have insights on this darn 28557 error?

Thanks, Mike

 

[marcmc]

i dont recognise the error. But if you change DB
structure, you have to drop the entire replication setups
and redo them. Your best bet is to script the replication
and do that each time.

 

[Michael Morisoli]

I found out what it is. I have a feeling this is a bug with sqlce.

One of my tables uses a Char(10) for it's pkey. So on a related table I had
to create an fkey that is also Char(10) and then create a relationship
between the two.

This is the point of failure. If the fkey and relationship are defined,
replication will fail ever time. If I change them to Int and setup the
relationship it replicates fine.

So while I have a workaround, it's not ideal.

Thanks, Mike