|
|
You're in the
sql server replication
group:sql2005 merge subs suddenly expired--
sql server replication:
All my laptop subscribers suddenly expired? also the replication monitor looks strange... the sub names are blank Anyone recover from this without re-subscribing?... no changes to the server for 27days... Thanks!! TITLE: Replication Monitor ------------------------------ Replication Monitor could not open the Detail Window. ADDITIONAL INFORMATION: Specified cast is not valid. (ReplicationMonitor)
history retension: 48 hours... (this is in the distributor properties)-- are
you talking about a different history retension? subscription retension: 31 days all subs sync daily-- [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:uwITpIrdHHA.4688@TK2MSFTNGP04.phx.gbl... > What is your history retention setting? This should be equal or greater > than your subscription retention setting. > > There is no way to recover without re-initializing or re-subscribing. > There is an option to upload subscriber changes when doing a > re-initialization which will upload any changes which have occurred on the > subscriber since the last sync. > > -- > Hilary Cotter > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message > news:ac531$4612f883$a227293b$20710@ALLTEL.NET... >> Please help! >> >> All my laptop subscribers suddenly expired? also the replication monitor >> looks strange... the sub names are blank >> >> Anyone recover from this without re-subscribing?... no changes to the >> server >> for 27days... >> >> Thanks!! >> >> >> >> >> TITLE: Replication Monitor >> ------------------------------ >> >> Replication Monitor could not open the Detail Window. >> >> ADDITIONAL INFORMATION: >> >> Specified cast is not valid. (ReplicationMonitor) >> >> > >
They both have to be the same. Make history 31 days as well.
-- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message news:5681b$461397c9$a227293b$8129@ALLTEL.NET... > history retension: 48 hours... (this is in the distributor properties)-- > are you talking about a different history retension? > subscription retension: 31 days > > all subs sync daily-- > > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:uwITpIrdHHA.4688@TK2MSFTNGP04.phx.gbl... >> What is your history retention setting? This should be equal or greater >> than your subscription retention setting. >> >> There is no way to recover without re-initializing or re-subscribing. >> There is an option to upload subscriber changes when doing a >> re-initialization which will upload any changes which have occurred on >> the subscriber since the last sync. >> >> -- >> Hilary Cotter >> >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> >> >> >> "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message >> news:ac531$4612f883$a227293b$20710@ALLTEL.NET... >>> Please help! >>> >>> All my laptop subscribers suddenly expired? also the replication monitor >>> looks strange... the sub names are blank >>> >>> Anyone recover from this without re-subscribing?... no changes to the >>> server >>> for 27days... >>> >>> Thanks!! >>> >>> >>> >>> >>> TITLE: Replication Monitor >>> ------------------------------ >>> >>> Replication Monitor could not open the Detail Window. >>> >>> ADDITIONAL INFORMATION: >>> >>> Specified cast is not valid. (ReplicationMonitor) >>> >>> >> >> > >
ok,
what problems could this cause... unexpected expired subs, or the wierd view in replication monitor -- also i think it thinks the subs do not exist... (not expired--) 1.jpg is the error message all of a sudden on laptops.. 2.jpg is what the repl monitor looks like all of a sudden (T3000 is my laptop, I subscriped to the same pub after this happened... no problems) 3.jpg is another system running normally-- http://162.39.41.50/temp/1.jpg http://162.39.41.50/temp/2.jpg http://162.39.41.50/temp/3.jpg Thanks!!! [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:O4Q2ddrdHHA.4964@TK2MSFTNGP04.phx.gbl... > They both have to be the same. Make history 31 days as well. > > -- > Hilary Cotter > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message > news:5681b$461397c9$a227293b$8129@ALLTEL.NET... >> history retension: 48 hours... (this is in the distributor properties)-- >> are you talking about a different history retension? >> subscription retension: 31 days >> >> all subs sync daily-- >> >> >> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >> news:uwITpIrdHHA.4688@TK2MSFTNGP04.phx.gbl... >>> What is your history retention setting? This should be equal or greater >>> than your subscription retention setting. >>> >>> There is no way to recover without re-initializing or re-subscribing. >>> There is an option to upload subscriber changes when doing a >>> re-initialization which will upload any changes which have occurred on >>> the subscriber since the last sync. >>> >>> -- >>> Hilary Cotter >>> >>> Looking for a SQL Server replication book? >>> http://www.nwsu.com/0974973602.html >>> >>> Looking for a FAQ on Indexing Services/SQL FTS >>> http://www.indexserverfaq.com >>> >>> >>> >>> "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message >>> news:ac531$4612f883$a227293b$20710@ALLTEL.NET... >>>> Please help! >>>> >>>> All my laptop subscribers suddenly expired? also the replication >>>> monitor >>>> looks strange... the sub names are blank >>>> >>>> Anyone recover from this without re-subscribing?... no changes to the >>>> server >>>> for 27days... >>>> >>>> Thanks!! >>>> >>>> >>>> >>>> >>>> TITLE: Replication Monitor >>>> ------------------------------ >>>> >>>> Replication Monitor could not open the Detail Window. >>>> >>>> ADDITIONAL INFORMATION: >>>> >>>> Specified cast is not valid. (ReplicationMonitor) >>>> >>>> >>> >>> >> >> > >
OK, now i'm in the middle of piecing this back together... I can drop the
sub, & resubscribe... but in repl monitor those wierd entris remain, I'm considering dropping & recreating the publication-- http://162.39.41.50/temp/4.jpg [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:O4Q2ddrdHHA.4964@TK2MSFTNGP04.phx.gbl... > They both have to be the same. Make history 31 days as well. > > -- > Hilary Cotter > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message > news:5681b$461397c9$a227293b$8129@ALLTEL.NET... >> history retension: 48 hours... (this is in the distributor properties)-- >> are you talking about a different history retension? >> subscription retension: 31 days >> >> all subs sync daily-- >> >> >> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >> news:uwITpIrdHHA.4688@TK2MSFTNGP04.phx.gbl... >>> What is your history retention setting? This should be equal or greater >>> than your subscription retention setting. >>> >>> There is no way to recover without re-initializing or re-subscribing. >>> There is an option to upload subscriber changes when doing a >>> re-initialization which will upload any changes which have occurred on >>> the subscriber since the last sync. >>> >>> -- >>> Hilary Cotter >>> >>> Looking for a SQL Server replication book? >>> http://www.nwsu.com/0974973602.html >>> >>> Looking for a FAQ on Indexing Services/SQL FTS >>> http://www.indexserverfaq.com >>> >>> >>> >>> "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message >>> news:ac531$4612f883$a227293b$20710@ALLTEL.NET... >>>> Please help! >>>> >>>> All my laptop subscribers suddenly expired? also the replication >>>> monitor >>>> looks strange... the sub names are blank >>>> >>>> Anyone recover from this without re-subscribing?... no changes to the >>>> server >>>> for 27days... >>>> >>>> Thanks!! >>>> >>>> >>>> >>>> >>>> TITLE: Replication Monitor >>>> ------------------------------ >>>> >>>> Replication Monitor could not open the Detail Window. >>>> >>>> ADDITIONAL INFORMATION: >>>> >>>> Specified cast is not valid. (ReplicationMonitor) >>>> >>>> >>> >>> >> >> > >
more...
It synced fine, notice those empty entries still stick in repl monitor... what are those??? http://162.39.41.50/temp/5.jpg http://162.39.41.50/temp/6.jpg [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:O4Q2ddrdHHA.4964@TK2MSFTNGP04.phx.gbl... > They both have to be the same. Make history 31 days as well. > > -- > Hilary Cotter > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message > news:5681b$461397c9$a227293b$8129@ALLTEL.NET... >> history retension: 48 hours... (this is in the distributor properties)-- >> are you talking about a different history retension? >> subscription retension: 31 days >> >> all subs sync daily-- >> >> >> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >> news:uwITpIrdHHA.4688@TK2MSFTNGP04.phx.gbl... >>> What is your history retention setting? This should be equal or greater >>> than your subscription retention setting. >>> >>> There is no way to recover without re-initializing or re-subscribing. >>> There is an option to upload subscriber changes when doing a >>> re-initialization which will upload any changes which have occurred on >>> the subscriber since the last sync. >>> >>> -- >>> Hilary Cotter >>> >>> Looking for a SQL Server replication book? >>> http://www.nwsu.com/0974973602.html >>> >>> Looking for a FAQ on Indexing Services/SQL FTS >>> http://www.indexserverfaq.com >>> >>> >>> >>> "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message >>> news:ac531$4612f883$a227293b$20710@ALLTEL.NET... >>>> Please help! >>>> >>>> All my laptop subscribers suddenly expired? also the replication >>>> monitor >>>> looks strange... the sub names are blank >>>> >>>> Anyone recover from this without re-subscribing?... no changes to the >>>> server >>>> for 27days... >>>> >>>> Thanks!! >>>> >>>> >>>> >>>> >>>> TITLE: Replication Monitor >>>> ------------------------------ >>>> >>>> Replication Monitor could not open the Detail Window. >>>> >>>> ADDITIONAL INFORMATION: >>>> >>>> Specified cast is not valid. (ReplicationMonitor) >>>> >>>> >>> >>> >> >> > >
What is your history retention setting? This should be equal or greater than
your subscription retention setting. There is no way to recover without re-initializing or re-subscribing. There is an option to upload subscriber changes when doing a re-initialization which will upload any changes which have occurred on the subscriber since the last sync. -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message news:ac531$4612f883$a227293b$20710@ALLTEL.NET... > Please help! > > All my laptop subscribers suddenly expired? also the replication monitor > looks strange... the sub names are blank > > Anyone recover from this without re-subscribing?... no changes to the > server > for 27days... > > Thanks!! > > > > > TITLE: Replication Monitor > ------------------------------ > > Replication Monitor could not open the Detail Window. > > ADDITIONAL INFORMATION: > > Specified cast is not valid. (ReplicationMonitor) > >
I have no idea. Are they from anonymous subscriptions?
-- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message news:88dba$4613be29$a227293b$30247@ALLTEL.NET... > more... > > It synced fine, > > notice those empty entries still stick in repl monitor... what are > those??? > > http://162.39.41.50/temp/5.jpg > http://162.39.41.50/temp/6.jpg > > > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:O4Q2ddrdHHA.4964@TK2MSFTNGP04.phx.gbl... >> They both have to be the same. Make history 31 days as well. >> >> -- >> Hilary Cotter >> >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> >> >> >> "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message >> news:5681b$461397c9$a227293b$8129@ALLTEL.NET... >>> history retension: 48 hours... (this is in the distributor properties)-- >>> are you talking about a different history retension? >>> subscription retension: 31 days >>> >>> all subs sync daily-- >>> >>> >>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>> news:uwITpIrdHHA.4688@TK2MSFTNGP04.phx.gbl... >>>> What is your history retention setting? This should be equal or greater >>>> than your subscription retention setting. >>>> >>>> There is no way to recover without re-initializing or re-subscribing. >>>> There is an option to upload subscriber changes when doing a >>>> re-initialization which will upload any changes which have occurred on >>>> the subscriber since the last sync. >>>> >>>> -- >>>> Hilary Cotter >>>> >>>> Looking for a SQL Server replication book? >>>> http://www.nwsu.com/0974973602.html >>>> >>>> Looking for a FAQ on Indexing Services/SQL FTS >>>> http://www.indexserverfaq.com >>>> >>>> >>>> >>>> "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message >>>> news:ac531$4612f883$a227293b$20710@ALLTEL.NET... >>>>> Please help! >>>>> >>>>> All my laptop subscribers suddenly expired? also the replication >>>>> monitor >>>>> looks strange... the sub names are blank >>>>> >>>>> Anyone recover from this without re-subscribing?... no changes to the >>>>> server >>>>> for 27days... >>>>> >>>>> Thanks!! >>>>> >>>>> >>>>> >>>>> >>>>> TITLE: Replication Monitor >>>>> ------------------------------ >>>>> >>>>> Replication Monitor could not open the Detail Window. >>>>> >>>>> ADDITIONAL INFORMATION: >>>>> >>>>> Specified cast is not valid. (ReplicationMonitor) >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
yes they are anonymous...
btw, this setup has been solid for almost 1 year! [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:uG5%23rUtdHHA.3956@TK2MSFTNGP03.phx.gbl... >I have no idea. Are they from anonymous subscriptions? > > -- > Hilary Cotter > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message > news:88dba$4613be29$a227293b$30247@ALLTEL.NET... >> more... >> >> It synced fine, >> >> notice those empty entries still stick in repl monitor... what are >> those??? >> >> http://162.39.41.50/temp/5.jpg >> http://162.39.41.50/temp/6.jpg >> >> >> >> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >> news:O4Q2ddrdHHA.4964@TK2MSFTNGP04.phx.gbl... >>> They both have to be the same. Make history 31 days as well. >>> >>> -- >>> Hilary Cotter >>> >>> Looking for a SQL Server replication book? >>> http://www.nwsu.com/0974973602.html >>> >>> Looking for a FAQ on Indexing Services/SQL FTS >>> http://www.indexserverfaq.com >>> >>> >>> >>> "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message >>> news:5681b$461397c9$a227293b$8129@ALLTEL.NET... >>>> history retension: 48 hours... (this is in the distributor >>>> properties)-- are you talking about a different history retension? >>>> subscription retension: 31 days >>>> >>>> all subs sync daily-- >>>> >>>> >>>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>>> news:uwITpIrdHHA.4688@TK2MSFTNGP04.phx.gbl... >>>>> What is your history retention setting? This should be equal or >>>>> greater than your subscription retention setting. >>>>> >>>>> There is no way to recover without re-initializing or re-subscribing. >>>>> There is an option to upload subscriber changes when doing a >>>>> re-initialization which will upload any changes which have occurred on >>>>> the subscriber since the last sync. >>>>> >>>>> -- >>>>> Hilary Cotter >>>>> >>>>> Looking for a SQL Server replication book? >>>>> http://www.nwsu.com/0974973602.html >>>>> >>>>> Looking for a FAQ on Indexing Services/SQL FTS >>>>> http://www.indexserverfaq.com >>>>> >>>>> >>>>> >>>>> "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message >>>>> news:ac531$4612f883$a227293b$20710@ALLTEL.NET... >>>>>> Please help! >>>>>> >>>>>> All my laptop subscribers suddenly expired? also the replication >>>>>> monitor >>>>>> looks strange... the sub names are blank >>>>>> >>>>>> Anyone recover from this without re-subscribing?... no changes to the >>>>>> server >>>>>> for 27days... >>>>>> >>>>>> Thanks!! >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> TITLE: Replication Monitor >>>>>> ------------------------------ >>>>>> >>>>>> Replication Monitor could not open the Detail Window. >>>>>> >>>>>> ADDITIONAL INFORMATION: >>>>>> >>>>>> Specified cast is not valid. (ReplicationMonitor) >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |