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


The subscription(s) have been marked inactive.....


The subscription(s) have been marked inactive.....

Author
Message
jmittmann
jmittmann
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 1

Hallo,

from time to time my transactional (push) replications on SQL2000 SP3a servers send me the following error message:

Error Message : The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.

Error Detail : The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions
will need to be dropped and recreated. (Source: Server Name (Data source); Error number: 21074)

My subscriptions have been very active for at least 2 years and in the properties "Subscriptions never expire" is marked.

I know that I can restart replication by setting the status column in distribution..MSsubscriptions to 2 but can anyone tell me why this problem occurs and how I can prevent it in future?

Thank you for your help





magasvs
magasvs
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1497 Visits: 753
Some replication parameters require reinitialization of subscriptions. So, if you change something in replication make sure this settings do not require reinitialization.
Borik
Borik
SSC Journeyman
SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)

Group: General Forum Members
Points: 88 Visits: 1
Umm i just got this error "The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated."

any Help to get this working again would be appreciated...

thanks...
togi
togi
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 1

Hi All

I also got same error..I looked to the some forums on net and everybody say that its related with expiration time..its default 72 hours and it can be set longer..
What is that max value of expiration time?
Actuallly I want to set my replication as never expired..I mean it should be never expired..How can I set expire time as "unlimited"..

Thanks ..


Borik
Borik
SSC Journeyman
SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)

Group: General Forum Members
Points: 88 Visits: 1
Enterprise Manager ->
Replication Monitor ->
Publishers ->
ServerName ->
Right Click on Publisher ->
General Tab ->
at the bottom there is Radio button "Subscription never expires..."

P.S. Unfortenetly i did't find how to resolve the error, i think u will neet to redo Replication....

Hope it helps...

Borik
Todd Boothroyd
Todd Boothroyd
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 1

Hey, not sure all of the steps that I took to resolve my issue, but here's what I recall:

Under Replication Monitor at the Distributer, expand node.

Expand Publishers

Expland node next to server name (Blue-green book icon)

Right click on any of the publishers and choose Reinitialize all subscriptions. (alternately, you can choose properties and select reinitialize under the Subscriptions tab). This just marks the subscription to be reinitialized.

Next, on Status tab, I clicked Run Agent Now to trigger the snapshot; this is supposed to, in my setup, push the subscription but that didn't happen.

Closing the properties window (if open), I selected the publisher in question so the information appeared in the right pane. Selecting the Publish Folder with the red X, I right clicked and chose Start Synchronizing.

That did it for me; hopefully, I chose the right setting in properties so it doesn't happen again.

Cheers!


ShekharNaidu
ShekharNaidu
SSC-Enthusiastic
SSC-Enthusiastic (188 reputation)SSC-Enthusiastic (188 reputation)SSC-Enthusiastic (188 reputation)SSC-Enthusiastic (188 reputation)SSC-Enthusiastic (188 reputation)SSC-Enthusiastic (188 reputation)SSC-Enthusiastic (188 reputation)SSC-Enthusiastic (188 reputation)

Group: General Forum Members
Points: 188 Visits: 70

The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.

I am getting this error frequently .. and it requires me to go through all the process of creating subscriptions again and again...

i would be happy if anybody help in this regard.

I have "Subscription Expiration perios set to 336 hrs" ... even if it is set to 336 hrs i am getting the above error frequently i.e., bfore this expiration period.

Thank you

Shekhar




Thanks ,

Shekhar

Andy Warren
Andy Warren
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: Moderators
Points: 11365 Visits: 2730
I dont have a server with replication enabled with me at the moment, but there is a job that checks for expired pubs by looking at the date of the oldest open (undistributed) transaction and marks sub as expired if past x date. Try disabling the job. Though I suspect that may be bandaiding a bigger problem, probably worth digging more.

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Dinakar Nethi-176633
Dinakar Nethi-176633
SSC-Addicted
SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)SSC-Addicted (441 reputation)

Group: General Forum Members
Points: 441 Visits: 188
If you already have the error, the only solution I would think is to re-setup replication but make sure you check the "never expires" option as Borik mentioned. By default I think its around 336 hours of inactivity. For a production system it is rare to have such period of inactivity.

******************
Dinakar Nethi
Life is short. Enjoy it.
******************
Borik
Borik
SSC Journeyman
SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)

Group: General Forum Members
Points: 88 Visits: 1

Also u might want to try to increase number of retries for replication jobs...


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