SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL CE Replication errors on handhelds


SQL CE Replication errors on handhelds

Author
Message
s.solanaki
s.solanaki
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 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.
Shankar Pesalperthy
Shankar Pesalperthy
SSC-Enthusiastic
SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)

Group: General Forum Members
Points: 181 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search