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»»

Replication not workiing Expand / Collapse
Author
Message
Posted Tuesday, January 28, 2014 10:04 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 05, 2014 8:54 AM
Points: 294, Visits: 1,242
I was wondering if someone would be able to help me. Please note that my knowledge on replication is very limited, the replication was setup by someone other than myself who has now left the company.

We have two servers Server A and Server B

Server A has a number of publications and Server B subscribes.

The publications were reporting errors in Server A, so I reinitialised the subscription in the Replication Monitor.

The Replication Monitor then reported that the subscription was running fine. However the users have reported that they are not receiving new data on the subscriber.

Not sure how I should troubleshoot next.
Post #1535554
Posted Tuesday, January 28, 2014 1:44 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:08 PM
Points: 167, Visits: 325
Are you sure the reinitialization is complete? It's not waiting for response from the server? Do we have Undistributed commands ??

You can start by researching for these and getting back with your findings.

If users are still seeing old data I doubt the reinitialization started at all.
Post #1535623
Posted Wednesday, January 29, 2014 2:17 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:19 AM
Points: 1,101, Visits: 5,271
Right click on the subscription and select "View synchronization status"

Make sure that Log-Reader and Distribution Agent jobs are running.
Post #1535777
Posted Wednesday, January 29, 2014 3:32 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:38 AM
Points: 1,887, Visits: 1,177
MarvinTheAndriod (1/28/2014)

The publications were reporting errors in Server A


What errors were reported?
Post #1535800
Posted Wednesday, January 29, 2014 4:01 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 05, 2014 8:54 AM
Points: 294, Visits: 1,242
Suresh B. (1/29/2014)
Right click on the subscription and select "View synchronization status"



I clicked on the subscriptions and selected "View synchronization status"

For most of the subscriptions it said:
No replicated transactions are available.
One Said:
3 transaction(s) with 3 command(s) were delivered.
However for one it said:
The initial snapshot for publication is not yet available.

Not sure how to Make sure that Log-Reader and Distribution Agent jobs are running. Are these SQL jobs ? I can't see any by that name.

Also the undritbuted commands tab does not seem to exist in my replication montior GUI

Post #1535812
Posted Wednesday, January 29, 2014 8:39 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:19 AM
Points: 1,101, Visits: 5,271
Yes, these are SQL Agent jobs. Job name would be similar to the publication name.

Log-Reader job runs on the Publisher. Distribution Agent jobs run on the Distributor (on Subscriber if pull subscription)

There is one Log-Reader job per database. There would be a Distribution Agent job for each Subscriber.
These jobs should be working fine for the replication to work.
Post #1535949
Posted Wednesday, January 29, 2014 11:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:08 PM
Points: 167, Visits: 325
Can't you confirm if updated data is flowing by updating a record on Server A and querying for the same record in Server B.

If the value stands updated that clarifies the replication is working fine. If there aren't too many tables you can check 1 by 1 for all.

This will clearly identify if any table was missed.
Post #1536070
Posted Thursday, January 30, 2014 7:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 05, 2014 8:54 AM
Points: 294, Visits: 1,242
Ankit Mathur-481681 (1/29/2014)
Can't you confirm if updated data is flowing by updating a record on Server A and querying for the same record in Server B.

If the value stands updated that clarifies the replication is working fine. If there aren't too many tables you can check 1 by 1 for all.

This will clearly identify if any table was missed.


Not is not hence the problem.
Post #1536348
Posted Thursday, January 30, 2014 8:52 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 05, 2014 8:54 AM
Points: 294, Visits: 1,242
The Publication that say "The initial snapshot for publication is not yet available." is the one that isn't working.

Should I reintialise again. Is it worth starting the snapshot agent ?




Post #1536395
Posted Thursday, January 30, 2014 8:59 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:38 AM
Points: 1,887, Visits: 1,177
MarvinTheAndriod (1/30/2014)
The Publication that say "The initial snapshot for publication is not yet available." is the one that isn't working.

Should I reintialise again. Is it worth starting the snapshot agent ?


Yes! If the snapshot agent is not running then the snapshot will not be created. The subscription may be marked for reinitialisation, but nothing will happen until the snapshot agent runs. Do you have the snapshot agent set to run on a schedule - once per day for example?

Regards
Lempster
Post #1536400
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse