SQL CE Error 29045, reconciler has failed.

[Kev Moore]

Hi there
we are using MS SQL Server 2000 and SQL CE. We are trying
to syncronise a database onto our PDA. the .spf file has
been created on the PDF successfully but when we
syncronise we get the dreaded 29045 error. We have
checked IIS and the publisher permissions and they are all
correct. The login/pwd are all the same so there shouldnt
be any problems there. We are also running the latest SQL
Server SP (SP3a). Anyone else out there experiencing
this? the IBuySpy demo works fine so we can rule out
legacy dll's etc.

cheers

Kev Moore

 

[Michael Morisoli]

Kev, while I haven't seen your 29045 error I have experenced plenty of
others like 28557 and 28560. It turns out that sqlce would not handle a
relationship I had setup using Char(10) for the pkey and fkey. The check
constraint that is created using keys of type char caused replication to
fail.

Don't know it this helps you, but I am finding that sqlce is fragle with the
types of things it can replicate.

Also as a side fyi, you should read up on all the things that are not
replicated to sqlce. Things like triggers, check constraints, default
values, none of those atributes are replicated or enforced by sqlce, so we
have to do that in code...

Hope this helps, good luck, Mike

 

[Selahattin TASPINAR]

Check if the sql agent is running , the probably reason of this error is
that the snapshot is not valid . Refresh the snapshot and try again