Merge replication update timing

I am new to replication and have setup Merge replication (SQL2k) to synch
with laptops. I made some data changes on the Publisher and then synched
with the laptop and it got the new data. Then, I added a test table and 2
rows of data on the Publisher. After a few minutes I tried to synch again
and did not get the table changes. Is there something I have to do with the
Snapshot Agent in order to make that new table and data get to the laptop?
Thanks.
David
David - you'll need to run the snapshot agent then the merge agent to have
this new table included.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Is there a way that I can do this with system stored procedure? if so,
do you know what they are? e.g. sp_?
Thanks.
David
*** Sent via Developersdex http://www.codecomments.com ***
|||David - sp_start_job.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Boy, when I create Microsoft Access replication it just automatically
grabbed the new table and data without me doing anything. I guess SQL
Server takes more work?
David
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OvgdFn1$FHA.1028@.TK2MSFTNGP11.phx.gbl...
> David - sp_start_job.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Paul,
How do I run the Merge Agent manually? Can I do it in EM? I was able to
run the Snapshot Agent but I do not see where I can run the Merge Agent.
Can you help?
p.s. The same server is both publisher and Distributor, if that helps.
David
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OvgdFn1$FHA.1028@.TK2MSFTNGP11.phx.gbl...
> David - sp_start_job.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Interesting - I never knew Access did this. I'm not too sure that this is
ideal though. If you added a completely unrelated and large table it would
be a pain if it was automatically added.
Cheers,
Paul
"David" <dlchase@.lifetimeinc.com> wrote in message
news:OdjxfH2$FHA.3136@.TK2MSFTNGP15.phx.gbl...
> Boy, when I create Microsoft Access replication it just automatically
> grabbed the new table and data without me doing anything. I guess SQL
> Server takes more work?
> David
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:OvgdFn1$FHA.1028@.TK2MSFTNGP11.phx.gbl...
>
|||David,
you should see the merge agent when you expand the replication monitor. If
the subscription is pull, then just run the job on the subscriber (merge
agent is synonomous with a job that runs merge.exe).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Use the conflict viewer to determine if these changes were conflicts and
were rolled back.
Also are you using any filtering? It is possible that these changes where
filtered out by the filter.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"David" <dlchase@.lifetimeinc.com> wrote in message
news:%23%23JQ5N0$FHA.4012@.TK2MSFTNGP10.phx.gbl...
>I am new to replication and have setup Merge replication (SQL2k) to synch
>with laptops. I made some data changes on the Publisher and then synched
>with the laptop and it got the new data. Then, I added a test table and 2
>rows of data on the Publisher. After a few minutes I tried to synch again
>and did not get the table changes. Is there something I have to do with
>the Snapshot Agent in order to make that new table and data get to the
>laptop? Thanks.
> David
>
|||I see that in Replication Monitor but it has a red X on the folder and also
on the Publishers folder. I don't know where to look for why the red X is
there. Also, ALL subscribers will be anonymous as they are laptops that
will be disconnected from the network from time to time. Did I do anything
wrong? This is my first (test) laptop and I want to get this right before
deploying into production.
p.s. Data changes are replicating, but the new table is still not getting to
the anonymous subscriber. Also, I tried running the start from the merge
agents folder and it prompted me for a username and password for the laptop
database.
David
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OUkYiy2$FHA.2652@.TK2MSFTNGP09.phx.gbl...
> David,
> you should see the merge agent when you expand the replication monitor. If
> the subscription is pull, then just run the job on the subscriber (merge
> agent is synonomous with a job that runs merge.exe).
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>

Merge replication error on the subscriber - call sys.sp_MSmakegeneration timing out

We are running on SQL Server 2005 SP2. Merge replication is on for one publisher and one subscriber.

Merge replication is throwing following error

"The process is waiting for a response from the query '{call sys.sp_MSmakegeneration (?)}"

It is hung on there for atleast couple hour or so. I decrease uploadbatches and downloadbatches settings as recommended but no positive results.

Let us know if any insight on the above issue.

Thanks

Is it actually hung on as in waiting for a response or is this what you are seeing in Replication Monitor. Keep in mind that if you are seeing this in Replication Monitor, the title of that dialog is the LAST error message that was received. It could very well have finished many synch cycles successfully and everything is moving through, however, the last time it had an error raised, it was this particular error. If it is in fact still waiting, then you need to check the publisher and subscriber and make sure that you don't have any blocking.|||I have ran sp_lock as don't see any blocking through sp_who , out put of the sp_lock shows that it is holding key locks on tables such as MSmerge_genhistory and MSmerge_contents.|||

Now I am running the sys stored procedure

exec sp_MSmakegeneration

from SQL Management Studio to see if it gives out any different output.

|||sp_MSmakegeneration will not return any information unless it errors out. If you want to see exactly what's going on, your best bet is to run profiler to trace it.|||

That would mean that it isn't hung and that data is moving through the system. If you look at the VERY bottom of the Replication Monitor window, in the status bar at the bottom, do you see a message that says something like "Waiting 60 seconds to poll for changes" or something else indicating that it is either uploading, download, connecting, or checking for stuff?

The part of the Replication Monitor that you are looking at just shows the last error message encountered. That error message could have occured 10 days ago and everything since then is running correctly without any errors.

|||What is the status of this thread? Were you able to resolve the issue? We are currently experiencing the same problem and could use some help, thanks!

Merge replication error on the subscriber - call sys.sp_MSmakegeneration timing out

We are running on SQL Server 2005 SP2. Merge replication is on for one publisher and one subscriber.

Merge replication is throwing following error

"The process is waiting for a response from the query '{call sys.sp_MSmakegeneration (?)}"

It is hung on there for atleast couple hour or so. I decrease uploadbatches and downloadbatches settings as recommended but no positive results.

Let us know if any insight on the above issue.

Thanks

Is it actually hung on as in waiting for a response or is this what you are seeing in Replication Monitor. Keep in mind that if you are seeing this in Replication Monitor, the title of that dialog is the LAST error message that was received. It could very well have finished many synch cycles successfully and everything is moving through, however, the last time it had an error raised, it was this particular error. If it is in fact still waiting, then you need to check the publisher and subscriber and make sure that you don't have any blocking.|||I have ran sp_lock as don't see any blocking through sp_who , out put of the sp_lock shows that it is holding key locks on tables such as MSmerge_genhistory and MSmerge_contents.|||

Now I am running the sys stored procedure

exec sp_MSmakegeneration

from SQL Management Studio to see if it gives out any different output.

|||sp_MSmakegeneration will not return any information unless it errors out. If you want to see exactly what's going on, your best bet is to run profiler to trace it.|||

That would mean that it isn't hung and that data is moving through the system. If you look at the VERY bottom of the Replication Monitor window, in the status bar at the bottom, do you see a message that says something like "Waiting 60 seconds to poll for changes" or something else indicating that it is either uploading, download, connecting, or checking for stuff?

The part of the Replication Monitor that you are looking at just shows the last error message encountered. That error message could have occured 10 days ago and everything since then is running correctly without any errors.

|||What is the status of this thread? Were you able to resolve the issue? We are currently experiencing the same problem and could use some help, thanks!