SQL CE Replication errors on handhelds

  • s.solanaki

    Grasshopper

    Points: 13

    Hello,

    I am working for a company that owns a mobile application that requires synchronization. We have about 100 clients that work flowless for a long time now and we use a standard installation for most of them. On a specific client we have issues with their databases getting corrupted. It is occuring on all of their pilots about once per 10-15 days. The only way we have found to solve this is to delete the local database on the device and synchronize it from the start. This is an easy procedure for us but for our client is something that is too hard to explain and takes a lot of their time. We need to find the reason this is happening. The messages are always empty with error code 80040E19 and minor err. 28574. I don't know what other feedback to give you to help but let me know if the information given are not enough. I would love to hear from you soon.

    Best regards

    S.

  • Shankar Pesalperthy

    SSC Veteran

    Points: 207

    We had a similar problem while performing merge replication between SQL Server 2005 and SQL Server Mobile, We only have few handhelds in the field but receive this error after every couple of weeks or so. There is not much information on it.

    It is a client side error, ie no error shows up in the server logs. What we do to go around this error is to Reinitialize All Subscriptions, selecting the "Use a new snapshot" option with "Generate now" checked. Once the snapshot is done the device replicates again and is just fine.

    Don't forget to monitor Snapshot Agent Status.

    Please post here if you find a solution.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply