I've been fighting with merge replication for the past few days over the same hurdle and I can't seem to figure this one out. I create the publication that publishes 36 articles (28 of which are download only). After creating the publication,
I can replicate perfectly normal as expected. When replicating, I pass in a project number through the host_name() variable and filter the data based on that value and all works great. I've replicated about 10 different projects, modified data,
and merged the changes back without issue.
Where I'm running into an issue is when I add a new project to the mix. I have an SSIS project that takes data and puts the data into a staging area. From there, I have an ETL that pulls the data from the staging area and inserts it into the
the database that is set up with merge replication. Being that these new records will need to be replicated in the future, I do a simple insert into, select from so that the replication triggers are fired and these rows are tracked.
After the data load (~150,000 rows in total among 5 tables), I go to replicate this new project however it never gets past the step
"Retrieving subscription information."
It eventually times out and never transfers the data. When I go back and try to rep
View Complete Post