SQL CE Replication errors on handhelds

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server CE » SQL CE Replication errors on handhelds

SQL CE Replication errors on handhelds

Rate Topic

Display Mode

Topic Options

Author

Message

s.solanaki

Posted Monday, February 23, 2009 2:53 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 23, 2009 3:56 AM
Points: 1, Visits: 3

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.

Post #662433

Shankar Pesalperthy

Posted Friday, April 17, 2009 6:07 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 22, 2010 8:29 AM
Points: 177, Visits: 19

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.

Post #699885

« Prev Topic | Next Topic »

Permissions