March 19, 2013 at 2:49 pm
Hi everyone,
We encountered some strange error when we were trying to add a subscriber.
Following steps were performed:
1. Publsher and distributor (2 different machines) were created
2. Publication was created
3. Few (12) subscribers were successfully added to the publication
When some time after everything is successfully running we tried to add 2 or more subscribers and got an error:
Message
The replication agent encountered a failure. See the previous job step history message or Replication Monitor for more information. The step failed.
Checking replication monitor it sends us to job and job sends us to replication monitor. Removing newly added subscribers make everything looks good again.
Any ideas if we need to check some settings?
Thanks.
March 19, 2013 at 3:10 pm
What is the error in the previous job step history message?
March 19, 2013 at 3:33 pm
The problem is that there is no previous message at all. In replication monitor it says - check the job.
March 19, 2013 at 3:45 pm
The error is in the job history of the SQL Server Agent job that is the Distribution Agent (named <distributor_name>-<publication_name>-<subscriber_name>).
Possibly it will tell you the distributor cannot connect to the Subscriber database (make sure the user that the Distribution Agent is in the dbo role in the Subscriber database)
March 20, 2013 at 8:28 am
this is exactly where I took a look:
-Publisher [ASH2VCL05INST4\CLSAVCL05INST4] -PublisherDB [VS_VALIDATION] -Distributor [ASH2VCL05INST3\CLSAVCL05INST3] -Publication [VS_VALIDATION] -DistributorSecurityMode 1 -Continuous
The replication agent encountered an error and is set to restart within the job step retry interval. See the previous job step history message or Replication Monitor for more
information.
Previous step doesn't have any message at all.
March 20, 2013 at 9:18 am
I don't see the subscriber.
What job category is it? REPL-Distribution?
March 20, 2013 at 9:20 am
Did you generate a new snapshot?
March 20, 2013 at 9:23 am
yes. When we setup everything first time with n number of subscribers it went through without problems. Replication is working perfectly. When later on we tried to add another subscribers and initialize the subscription with new snapshot creation - this is where it happens.
March 20, 2013 at 9:26 am
Which agent job has the error. There should be a separate distributor job for each subscription
March 20, 2013 at 9:31 am
True. Each job (for publication we are trying to add subscriptions) gives the same error
March 20, 2013 at 9:36 am
What happens if you restart one of the existing Distribution jobs.
You may get cleaner errors in the job history.
March 21, 2013 at 8:33 am
Still experiencing a problem. Maybe someone can give us any directions.
All I found online was about some user/persmissions issues. We dropped everything and re-created from the scratch publisher-distributor-subscriber using 1 user with DBA role.
Adding several subscriptions went well and everything is working. The minute we add another subscription we have a problem.
We have 10 publications with 12 subscribers to each running successfully. Adding new subscribers is an issue.
Is it any capacity problem? Should we modify any parameters?
Any input will be welcome.
Thanks.
March 21, 2013 at 9:37 am
we tried to restart job which failed. No luck, the same error messages
March 21, 2013 at 10:33 am
Do all the subscriptions fail, or only the new ones you add?
March 21, 2013 at 12:40 pm
all old subscriptions are working, just the added one shoes agent failure when we try to initialize it.
Viewing 15 posts - 1 through 15 (of 18 total)
You must be logged in to reply to this topic. Login to reply