Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Transactional replication problem Expand / Collapse
Author
Message
Posted Tuesday, March 19, 2013 2:49 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 3:34 PM
Points: 24, 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.

Post #1432905
Posted Tuesday, March 19, 2013 3:10 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 5:20 PM
Points: 237, Visits: 763
What is the error in the previous job step history message?
Post #1432909
Posted Tuesday, March 19, 2013 3:33 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 3:34 PM
Points: 24, Visits: 177
The problem is that there is no previous message at all. In replication monitor it says - check the job.
Post #1432916
Posted Tuesday, March 19, 2013 3:45 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 5:20 PM
Points: 237, Visits: 763
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)
Post #1432922
Posted Wednesday, March 20, 2013 8:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 3:34 PM
Points: 24, 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.
Post #1433251
Posted Wednesday, March 20, 2013 9:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 5:20 PM
Points: 237, Visits: 763
I don't see the subscriber.
What job category is it? REPL-Distribution?
Post #1433301
Posted Wednesday, March 20, 2013 9:20 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 5:20 PM
Points: 237, Visits: 763
Did you generate a new snapshot?
Post #1433302
Posted Wednesday, March 20, 2013 9:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 3:34 PM
Points: 24, 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.
Post #1433306
Posted Wednesday, March 20, 2013 9:26 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 5:20 PM
Points: 237, Visits: 763
Which agent job has the error. There should be a separate distributor job for each subscription
Post #1433308
Posted Wednesday, March 20, 2013 9:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 3:34 PM
Points: 24, Visits: 177
True. Each job (for publication we are trying to add subscriptions) gives the same error
Post #1433310
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse