ramazotti7
28th September 2008, 10:22 AM
Hello to all,
we have a hard time with a replication project. A call to
SqlCeReplication.Dispose() reboots the device 100% reproducable. We can reproduce the behaviour with a project that contains nothing but the standard replication call.
SqlCeReplication repl = new SqlCeReplication();
try
{
repl.ConnectionManager = true;
repl.InternetUrl = @"our url";
repl.Publisher = @"our publisher";
repl.PublisherDatabase = @"our db";
repl.PublisherSecurityMode =
SecurityType.DBAuthentication;
repl.PublisherLogin = @"loginname";
repl.PublisherPassword = @"password";
repl.Publication = @"publKFPMobileMHD_LFD";
repl.Subscriber = @"LFDabo";
repl.HostName = "SW0031";
repl.SubscriberConnectionString =
@"Data Source=""" +
DatabasePath +
@""";Max Database Size=128;Password=our password;Default Lock Escalation =100";
repl.AddSubscription(AddOption.CreateDatabase);
repl.Synchronize();
repl.Dispose();
The error only occurs on slow connections (GPRS or Edge) and when the size of the database created with this call is above 500 Kb or so. Its not reproducible in HSDPA or when I use the desktop connection in emulator.
The repl.Synchronize() works perfectly. The replication is finished and correct, there are no errors in the webserver log, in SQLCESALOG or on the publisher.
There is no excepion raised at any point, just reboot.
If I omit the call to Dispose(), the reboot is delayed until I close the app or until I restart the app after closing. Obviously this is when the garbage collection calls dispose.
To me it looks more than a problem with the communication stack than with replication itself, but I may be wrong. I would be very thankful for any suggestions or tips for further debugging.
We use SQL CE 3.5 Components on device, webserver and database, since we ran into the "reconciler failed" problem describe in a other thread here when using SQL CE 3.5 SP1. The pda is a T-Mobile MDA Compact IV (GER-Rom). With other PDAs we didnīt get this error.
Perhaps someone can help me.
Best regards,
Rainer
we have a hard time with a replication project. A call to
SqlCeReplication.Dispose() reboots the device 100% reproducable. We can reproduce the behaviour with a project that contains nothing but the standard replication call.
SqlCeReplication repl = new SqlCeReplication();
try
{
repl.ConnectionManager = true;
repl.InternetUrl = @"our url";
repl.Publisher = @"our publisher";
repl.PublisherDatabase = @"our db";
repl.PublisherSecurityMode =
SecurityType.DBAuthentication;
repl.PublisherLogin = @"loginname";
repl.PublisherPassword = @"password";
repl.Publication = @"publKFPMobileMHD_LFD";
repl.Subscriber = @"LFDabo";
repl.HostName = "SW0031";
repl.SubscriberConnectionString =
@"Data Source=""" +
DatabasePath +
@""";Max Database Size=128;Password=our password;Default Lock Escalation =100";
repl.AddSubscription(AddOption.CreateDatabase);
repl.Synchronize();
repl.Dispose();
The error only occurs on slow connections (GPRS or Edge) and when the size of the database created with this call is above 500 Kb or so. Its not reproducible in HSDPA or when I use the desktop connection in emulator.
The repl.Synchronize() works perfectly. The replication is finished and correct, there are no errors in the webserver log, in SQLCESALOG or on the publisher.
There is no excepion raised at any point, just reboot.
If I omit the call to Dispose(), the reboot is delayed until I close the app or until I restart the app after closing. Obviously this is when the garbage collection calls dispose.
To me it looks more than a problem with the communication stack than with replication itself, but I may be wrong. I would be very thankful for any suggestions or tips for further debugging.
We use SQL CE 3.5 Components on device, webserver and database, since we ran into the "reconciler failed" problem describe in a other thread here when using SQL CE 3.5 SP1. The pda is a T-Mobile MDA Compact IV (GER-Rom). With other PDAs we didnīt get this error.
Perhaps someone can help me.
Best regards,
Rainer