SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Transactional replication problem


Transactional replication problem

Author
Message
iashurova
iashurova
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
Points: 50 Visits: 177
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.
arnipetursson
arnipetursson
Say Hey Kid
Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)

Group: General Forum Members
Points: 677 Visits: 1019
What is the error in the previous job step history message?
iashurova
iashurova
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
Points: 50 Visits: 177
The problem is that there is no previous message at all. In replication monitor it says - check the job.
arnipetursson
arnipetursson
Say Hey Kid
Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)

Group: General Forum Members
Points: 677 Visits: 1019
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>Wink.

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)
iashurova
iashurova
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
Points: 50 Visits: 177
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.
arnipetursson
arnipetursson
Say Hey Kid
Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)

Group: General Forum Members
Points: 677 Visits: 1019
I don't see the subscriber.
What job category is it? REPL-Distribution?
arnipetursson
arnipetursson
Say Hey Kid
Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)

Group: General Forum Members
Points: 677 Visits: 1019
Did you generate a new snapshot?
iashurova
iashurova
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
Points: 50 Visits: 177
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.
arnipetursson
arnipetursson
Say Hey Kid
Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)Say Hey Kid (677 reputation)

Group: General Forum Members
Points: 677 Visits: 1019
Which agent job has the error. There should be a separate distributor job for each subscription
iashurova
iashurova
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
Points: 50 Visits: 177
True. Each job (for publication we are trying to add subscriptions) gives the same error
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search