I can upload data, but cant download??

Question

I can upload data, but cant download??

jono_davis747

SSC Journeyman

Points: 76
More actions
September 10, 2003 at 5:09 am

#82421

Hi all, this is my first post here..nice site!!
I am running Merge replication on several SQL 2000 boxes, all SP 2 (Windows 2000 Server SP 3)
When I try and replicate with one of my subscribers it times out?
Upon running profiler on the machine the ONLY SP that runs is
==========================
declare @P1 int
set @P1=7078706
exec sp_MScheckexistsgeneration 'C405D3FD-172A-443A-919B-81D6D2184D35', @P1 output
select @P1
==========================
The server runs through the generations incrementally. This takes hours and as a result the agent times out. I have
increased the timeout values for the agents profile but it still wont begin the actual process of running the update
and insert procedures to make some replication inserts.
I tried re-indexing the merge tables
msmerge_contents
msmerge_tombstone
msmerge_genhistoy so as to speed up the queries but still no visible improvement??
The strange thing is that if I put a ' exchangetype' switch into the agent it will upload data without a problem ?
As soon as I try to download data to this subscriber it simply does what I mention above.
ANY IDEAS/SUGGESTIONS AS TO HOW I CAN GET IT TO DOWNLOAD THE DATA TO THE SUBSCRIBER, or at least an explanation as to why
the subscriber ONLY runs the procedure above??
THANKS!!!
CHEERS
Jon 🙂

CHEERS
Jon 🙂

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

Not sure if I can be of any help, but I experienced about the same problem about a year ago. Suddenly, out of the blue the merge agent only updated the subscribers, but didn't get any changes back. At the same time CPU usage went to 100% which slowed down the server. We contacted MS PSS but the real reason was never found. In the end I had to recreate all subscriptions.

You might also try to install SP3 because it contains some new and (hopefully) improved SP's for merge replication.

Good luck

Markus

[font="Verdana"]Markus Bohse[/font]

jono_davis747 SSC Journeyman Points: 76 More actions · Answer 2

Hi Markus,

Thanks tremendously for your input, should I need to go this route I would need to ask you another question that

I have been trying to solve for a few weeks now ??

How can I go about delivering the initial snapshot to the merge subscribers using a CD ?

I experimented with the -AltSnapshotFolder switch on the agent and it did indeed run from the alternate location, is this the same process for CD's ? I have never successfully used a CD to apply snapshots.

PS - We run Frame Relay and these are some hefty snapshot files !! 🙂

THANKS AGAIN

CHEERS

Jon 🙂

CHEERS
Jon 🙂

McBoof Newbie Points: 5 More actions · Answer 3

Hi,

I've got pretty much the same problem. From what I can tell, the query:

exec sp_MSenumgenerations 0, '2CBA70B1-30C1-408F-860D-6F03C00CD6C9', 1

is timing out, and so the agent dies horribly, with the following message:

The process could not check existence of generation at the 'Subscriber'.

(Source: Merge Replication Provider (Agent); Error number: -2147201003)

---------------------------------------------

General network error. Check your network documentation.

(Source: AAMS-ASPECT (Data source); Error number: 11)

---------------------------------------------

Has anyone had any luck with this yet?

Thanks,

Jon

Nick1pub Grasshopper Points: 11 More actions · Answer 4

Jon, or anyone from this post...

Have you had any luck with the "existence of generation at the 'subscriber'" error? I am getting these all of a sudden after a year or so of smooth merge replication. The problem clears up with a reboot, sometimes on both ends, but there has to be a better solution!!

Thanks all for any help,

Nick

govind-211283 SSC Eights! Points: 962 More actions · Answer 5

HI,

I am facing the same problem too, any help please