SQL 2005 Mobile - Merge Replication - Failure initializing Reconceiler

Hi folks

Right now I am stuck with the folowing situation: I have configured merge replication between SQL 2005 RC and SQL Mobile 2005. The SQL Server 2005 Mobile Edition Pack Beta 1 is installed and the publication is configured correctly. The sdf is copied correctley and the data is available on the mobile client and the subscription was added

When I test the url http://myserver/sync/sqlcesa30.dll diag all tests are ok. In the mobile client I use the folowing syntax

Private void GetReplConnection()

{

// Set the url to access the data

cashflowRepl.InternetUrl = "http://myserver/sync/sqlcesa30.dll";

// Set the publisher server

cashflowRepl.Publisher = "...";

// Set the published database

cashflowRepl.PublisherDatabase = "...";

// Set the publisher credentials

cashflowRepl.PublisherLogin = "sa";

cashflowRepl.PublisherPassword = "...";

// Set the publication title

cashflowRepl.Publication = "...";

// Set the internet credentials

cashflowRepl.InternetLogin = "user";

cashflowRepl.InternetPassword = "pwd";

// Set the local connection string

cashflowRepl.SubscriberConnectionString = cashflowMobileDB;

// Set the name of the subscription

cashflowRepl.Subscriber = "...";

}

and

private void btnReplicate_Click(object sender, EventArgs e)

{

MessageBox.Show(cashflowMobileDB);

GetReplConnection();

// Synchronize

cashflowRepl.Synchronize();

// Release resources

cashflowRepl.Dispose();

MessageBox.Show("replication finished");

}

or

private void ResynchronizationButton_Click(object sender, EventArgs e)

{

try

{

// set teh replication metadata

GetReplConnection();

// Create the callback Delegates

AsyncCallback completedCallback = new AsyncCallback(this.SyncCompletedCallback);

OnStartTableUpload onStartTableUpload = new OnStartTableUpload(this.OnStartTableUploadCallback);

OnStartTableDownload onStartTableDownload = new OnStartTableDownload(this.OnStartTableDownloadCallback);

OnSynchronization onSynchronization = new OnSynchronization(this.OnSynchronizationCallback);

MessageBox.Show("Starting Synchronization");

//Begin asynchronous sync.

IAsyncResult ar =

cashflowRepl.BeginSynchronize

(completedCallback, onStartTableUpload,

onStartTableDownload, onSynchronization,

cashflowRepl);

//Wait for synchronization to complete.

ar.AsyncWaitHandle.WaitOne();

//Complete synchronization

cashflowRepl.EndSynchronize(ar);

MessageBox.Show("Synchronization Complete!");

cashflowRepl.Dispose();

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

}

When I start Replication the tables are downloaded to 100% and then I keep on getting "Failure initializing reconceiler".

Please help - I am realy stuck :((

Alex



Answer this question

SQL 2005 Mobile - Merge Replication - Failure initializing Reconceiler

  • Ben Miller

    Hi Alex,

    Are you using Filtering If so, what is the Hostname you are using Not sure if you using one as I did not see it in your code above.
    Also try the URL without specifying the sqlcesa30.dll
       cashflowRepl.InternetUrl = http://myserver/syncr;

  • SQL 2005 Mobile - Merge Replication - Failure initializing Reconceiler