Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL CE Replication errors on handhelds Expand / Collapse
Author
Message
Posted Monday, February 23, 2009 2:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, April 17, 2009 6:07 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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 »

Add to briefcase

Permissions Expand / Collapse