Replication problem

Hi.

I am using SQL Server 2005 at the back-end, with a database published for merge replication; Windows Mobile-based handheld devices running a .NET 2.0 CF application, and SQL Mobile 2005.

Intermittently, when initialising the subscription on a device, the app cycles through the tables multiple times, or even endlessly.

Can anyone shed some light on why this is happening?

Try to check the Replication Monitor (server side) for status, including number of records submitted. There are some issues with merge replication in the SQL Server 2005 RTM, that have been fixed in SQL Server 2005 SP2.|||

Thanks for the response.

I checked the replication monitor as a matter of course - no problems there, everything looks fine.

Interesting what you say about SP2 - the box in question is running RTM, so maybe updating it will help. Is there anywhere that goes into detail on what these issues that you mention were, and if/how they have been addressed in SP2?

|||

There are various merge/SQL Compact fixes, all documented at: http://support.microsoft.com/default.aspx?scid=kb;en-us;921896
Amongst others:

919949 (http://support.microsoft.com/kb/919949/) FIX: The sp_MSinitDynamicSubscriber stored procedure is called more than one time by using the same parameters in SQL Server 2005

|||

Erik,

Thanks for that. I am recommending to my client that they upgrade to SP2, and will post back here with the results.

|||

My client is hoping to install SP2 in a couple of weeks. In the meantime, they applied the hotfix, but the problem still exists.

They applied the hotfix to the server running the instance of SQL 2005, but not to the machine with the SQL Mobile server tools (and SQL 2005 client components). Is this correct?

I am hoping that, despite the failure of the hotfix to resolve the issue, the full SP2 update will make a difference...

|||

Erik,

SP2 has now been applied to both servers, and the problem is now resolved.

Thanks very much for your help.

|||

We are facing the same problem... so suggested client to apply for Sp2.... still the problem pesrsists,,,,

Any idea as how to resolve it... please let me know if anything need to be changed after applying Sp2...

Waiting for an answer..

|||It is important to apply SP2 on all servers, including IIS (web) servers (replication components)|||

How to apply SQL server 2005 Service pack 2 on IIS web servers...

I really didnt understand this..can u please telll me what is it

|||If you are running IIS on a separate server, you need to update the replciation components to SP2, see this for info http://msdn2.microsoft.com/en-us/library/ms172937.aspx|||

I will update the replication componets on IIS servers, but what abt the "SQLCSA30.dll" contained in the virtual directory... HOw to update this dll with Service pack 2....

Please correct me if i am using the wrong concepts.. I am new to these concepts..

|||

I will update the replication componets on IIS servers, but what abt the "SQLCESA30.dll" contained in the virtual directory... HOw to update this dll with Service pack 2....

Please correct me if i am using the wrong concepts.. I am new to these concepts..

|||

Thank You Erik...

My Problem solved after applying SP2

GOKI