sql2k sp3
win2k sp4
Im trying to create a Pull Subscription for replication and get "Error 8198:
Could not obtain information about Windows NT group/ user 'domain/ user'".
I read this:
http://support.microsoft.com/?kbid=834124
But both boxes are in the same domain and the same subnet. Both use the same
domain admin account for SQL Server and the Agent accounts.
I also read this:
http://support.microsoft.com/?kbid=838460
But Im not about to install sp4 Beta on anything.
Is there anything else I can do?
TIA, ChrisR
right click on your agent and make the agent owner sa. Restart your job.
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
"ChrisR" <noemail@.bla.com> wrote in message
news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> sql2k sp3
> win2k sp4
> Im trying to create a Pull Subscription for replication and get "Error
8198:
> Could not obtain information about Windows NT group/ user 'domain/ user'".
> I read this:
> http://support.microsoft.com/?kbid=834124
> But both boxes are in the same domain and the same subnet. Both use the
same
> domain admin account for SQL Server and the Agent accounts.
> I also read this:
> http://support.microsoft.com/?kbid=838460
> But Im not about to install sp4 Beta on anything.
> Is there anything else I can do?
> TIA, ChrisR
>
|||Which Agent are you referring too? All of the jobs are owned by SA.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23RPeZF2SFHA.3544@.TK2MSFTNGP12.phx.gbl...
> right click on your agent and make the agent owner sa. Restart your job.
> --
> 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
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> 8198:
> same
>
Showing posts with label subscription. Show all posts
Showing posts with label subscription. Show all posts
Thursday, March 22, 2012
error 8198
sql2k sp3
win2k sp4
Im trying to create a Pull Subscription for replication and get "Error 8198:
Could not obtain information about Windows NT group/ user 'domain/ user'".
I read this:
http://support.microsoft.com/?kbid=834124
But both boxes are in the same domain and the same subnet. Both use the same
domain admin account for SQL Server and the Agent accounts.
I also read this:
http://support.microsoft.com/?kbid=838460
But Im not about to install sp4 Beta on anything.
Is there anything else I can do?
TIA, ChrisRright click on your agent and make the agent owner sa. Restart your job.
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
"ChrisR" <noemail@.bla.com> wrote in message
news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> sql2k sp3
> win2k sp4
> Im trying to create a Pull Subscription for replication and get "Error
8198:
> Could not obtain information about Windows NT group/ user 'domain/ user'".
> I read this:
> http://support.microsoft.com/?kbid=834124
> But both boxes are in the same domain and the same subnet. Both use the
same
> domain admin account for SQL Server and the Agent accounts.
> I also read this:
> http://support.microsoft.com/?kbid=838460
> But Im not about to install sp4 Beta on anything.
> Is there anything else I can do?
> TIA, ChrisR
>|||Which Agent are you referring too? All of the jobs are owned by SA.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23RPeZF2SFHA.3544@.TK2MSFTNGP12.phx.gbl...
> right click on your agent and make the agent owner sa. Restart your job.
> --
> 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
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> 8198:
> same
>sql
win2k sp4
Im trying to create a Pull Subscription for replication and get "Error 8198:
Could not obtain information about Windows NT group/ user 'domain/ user'".
I read this:
http://support.microsoft.com/?kbid=834124
But both boxes are in the same domain and the same subnet. Both use the same
domain admin account for SQL Server and the Agent accounts.
I also read this:
http://support.microsoft.com/?kbid=838460
But Im not about to install sp4 Beta on anything.
Is there anything else I can do?
TIA, ChrisRright click on your agent and make the agent owner sa. Restart your job.
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
"ChrisR" <noemail@.bla.com> wrote in message
news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> sql2k sp3
> win2k sp4
> Im trying to create a Pull Subscription for replication and get "Error
8198:
> Could not obtain information about Windows NT group/ user 'domain/ user'".
> I read this:
> http://support.microsoft.com/?kbid=834124
> But both boxes are in the same domain and the same subnet. Both use the
same
> domain admin account for SQL Server and the Agent accounts.
> I also read this:
> http://support.microsoft.com/?kbid=838460
> But Im not about to install sp4 Beta on anything.
> Is there anything else I can do?
> TIA, ChrisR
>|||Which Agent are you referring too? All of the jobs are owned by SA.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23RPeZF2SFHA.3544@.TK2MSFTNGP12.phx.gbl...
> right click on your agent and make the agent owner sa. Restart your job.
> --
> 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
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> 8198:
> same
>sql
error 8198
sql2k sp3
win2k sp4
Im trying to create a Pull Subscription for replication and get "Error 8198:
Could not obtain information about Windows NT group/ user 'domain/ user'".
I read this:
http://support.microsoft.com/?kbid=834124
But both boxes are in the same domain and the same subnet. Both use the same
domain admin account for SQL Server and the Agent accounts.
I also read this:
http://support.microsoft.com/?kbid=838460
But Im not about to install sp4 Beta on anything.
Is there anything else I can do?
TIA, ChrisR
right click on your agent and make the agent owner sa. Restart your job.
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
"ChrisR" <noemail@.bla.com> wrote in message
news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> sql2k sp3
> win2k sp4
> Im trying to create a Pull Subscription for replication and get "Error
8198:
> Could not obtain information about Windows NT group/ user 'domain/ user'".
> I read this:
> http://support.microsoft.com/?kbid=834124
> But both boxes are in the same domain and the same subnet. Both use the
same
> domain admin account for SQL Server and the Agent accounts.
> I also read this:
> http://support.microsoft.com/?kbid=838460
> But Im not about to install sp4 Beta on anything.
> Is there anything else I can do?
> TIA, ChrisR
>
|||Which Agent are you referring too? All of the jobs are owned by SA.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23RPeZF2SFHA.3544@.TK2MSFTNGP12.phx.gbl...
> right click on your agent and make the agent owner sa. Restart your job.
> --
> 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
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> 8198:
> same
>
win2k sp4
Im trying to create a Pull Subscription for replication and get "Error 8198:
Could not obtain information about Windows NT group/ user 'domain/ user'".
I read this:
http://support.microsoft.com/?kbid=834124
But both boxes are in the same domain and the same subnet. Both use the same
domain admin account for SQL Server and the Agent accounts.
I also read this:
http://support.microsoft.com/?kbid=838460
But Im not about to install sp4 Beta on anything.
Is there anything else I can do?
TIA, ChrisR
right click on your agent and make the agent owner sa. Restart your job.
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
"ChrisR" <noemail@.bla.com> wrote in message
news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> sql2k sp3
> win2k sp4
> Im trying to create a Pull Subscription for replication and get "Error
8198:
> Could not obtain information about Windows NT group/ user 'domain/ user'".
> I read this:
> http://support.microsoft.com/?kbid=834124
> But both boxes are in the same domain and the same subnet. Both use the
same
> domain admin account for SQL Server and the Agent accounts.
> I also read this:
> http://support.microsoft.com/?kbid=838460
> But Im not about to install sp4 Beta on anything.
> Is there anything else I can do?
> TIA, ChrisR
>
|||Which Agent are you referring too? All of the jobs are owned by SA.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23RPeZF2SFHA.3544@.TK2MSFTNGP12.phx.gbl...
> right click on your agent and make the agent owner sa. Restart your job.
> --
> 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
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> 8198:
> same
>
error 8198
sql2k sp3
win2k sp4
Im trying to create a Pull Subscription for replication and get "Error 8198:
Could not obtain information about Windows NT group/ user 'domain/ user'".
I read this:
http://support.microsoft.com/?kbid=834124
But both boxes are in the same domain and the same subnet. Both use the same
domain admin account for SQL Server and the Agent accounts.
I also read this:
http://support.microsoft.com/?kbid=838460
But Im not about to install sp4 Beta on anything.
Is there anything else I can do?
TIA, ChrisRright click on your agent and make the agent owner sa. Restart your job.
--
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
"ChrisR" <noemail@.bla.com> wrote in message
news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> sql2k sp3
> win2k sp4
> Im trying to create a Pull Subscription for replication and get "Error
8198:
> Could not obtain information about Windows NT group/ user 'domain/ user'".
> I read this:
> http://support.microsoft.com/?kbid=834124
> But both boxes are in the same domain and the same subnet. Both use the
same
> domain admin account for SQL Server and the Agent accounts.
> I also read this:
> http://support.microsoft.com/?kbid=838460
> But Im not about to install sp4 Beta on anything.
> Is there anything else I can do?
> TIA, ChrisR
>|||Which Agent are you referring too? All of the jobs are owned by SA.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23RPeZF2SFHA.3544@.TK2MSFTNGP12.phx.gbl...
> right click on your agent and make the agent owner sa. Restart your job.
> --
> 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
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
>> sql2k sp3
>> win2k sp4
>> Im trying to create a Pull Subscription for replication and get "Error
> 8198:
>> Could not obtain information about Windows NT group/ user 'domain/
>> user'".
>> I read this:
>> http://support.microsoft.com/?kbid=834124
>> But both boxes are in the same domain and the same subnet. Both use the
> same
>> domain admin account for SQL Server and the Agent accounts.
>> I also read this:
>> http://support.microsoft.com/?kbid=838460
>> But Im not about to install sp4 Beta on anything.
>> Is there anything else I can do?
>> TIA, ChrisR
>>
>
win2k sp4
Im trying to create a Pull Subscription for replication and get "Error 8198:
Could not obtain information about Windows NT group/ user 'domain/ user'".
I read this:
http://support.microsoft.com/?kbid=834124
But both boxes are in the same domain and the same subnet. Both use the same
domain admin account for SQL Server and the Agent accounts.
I also read this:
http://support.microsoft.com/?kbid=838460
But Im not about to install sp4 Beta on anything.
Is there anything else I can do?
TIA, ChrisRright click on your agent and make the agent owner sa. Restart your job.
--
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
"ChrisR" <noemail@.bla.com> wrote in message
news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> sql2k sp3
> win2k sp4
> Im trying to create a Pull Subscription for replication and get "Error
8198:
> Could not obtain information about Windows NT group/ user 'domain/ user'".
> I read this:
> http://support.microsoft.com/?kbid=834124
> But both boxes are in the same domain and the same subnet. Both use the
same
> domain admin account for SQL Server and the Agent accounts.
> I also read this:
> http://support.microsoft.com/?kbid=838460
> But Im not about to install sp4 Beta on anything.
> Is there anything else I can do?
> TIA, ChrisR
>|||Which Agent are you referring too? All of the jobs are owned by SA.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23RPeZF2SFHA.3544@.TK2MSFTNGP12.phx.gbl...
> right click on your agent and make the agent owner sa. Restart your job.
> --
> 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
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
>> sql2k sp3
>> win2k sp4
>> Im trying to create a Pull Subscription for replication and get "Error
> 8198:
>> Could not obtain information about Windows NT group/ user 'domain/
>> user'".
>> I read this:
>> http://support.microsoft.com/?kbid=834124
>> But both boxes are in the same domain and the same subnet. Both use the
> same
>> domain admin account for SQL Server and the Agent accounts.
>> I also read this:
>> http://support.microsoft.com/?kbid=838460
>> But Im not about to install sp4 Beta on anything.
>> Is there anything else I can do?
>> TIA, ChrisR
>>
>
Error 8102, Cannot update identity
Hi,
I have setup unidirectional transaction replication between two SQL2k
servers. On the subscription database I have set the PK as (Indentity not
for Replication).
I can insert and delete records on the publisher and they get replicated
without any errors, but on the updates I get an error.
The issue I belieive is with the generated sp_MSupd stored procedure. For
some reason it is tring to execute the first block even if the logic is
false.
Can someone please advise how to get around this issue.
Thanks
This problem is caused by updating the PK. You have to look at exactly what
the application which is modifying the data on the publisher is doing.
For some applications (including ones using the .net DataGrid component),
any update of any column in a table results in the update of all columns.
This is translated as a delete followed by an insert.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"mm" <postto@.news.com> wrote in message
news:%23lUTk14mEHA.1296@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have setup unidirectional transaction replication between two SQL2k
> servers. On the subscription database I have set the PK as (Indentity not
> for Replication).
> I can insert and delete records on the publisher and they get replicated
> without any errors, but on the updates I get an error.
> The issue I belieive is with the generated sp_MSupd stored procedure. For
> some reason it is tring to execute the first block even if the logic is
> false.
> Can someone please advise how to get around this issue.
> Thanks
>
>
I have setup unidirectional transaction replication between two SQL2k
servers. On the subscription database I have set the PK as (Indentity not
for Replication).
I can insert and delete records on the publisher and they get replicated
without any errors, but on the updates I get an error.
The issue I belieive is with the generated sp_MSupd stored procedure. For
some reason it is tring to execute the first block even if the logic is
false.
Can someone please advise how to get around this issue.
Thanks
This problem is caused by updating the PK. You have to look at exactly what
the application which is modifying the data on the publisher is doing.
For some applications (including ones using the .net DataGrid component),
any update of any column in a table results in the update of all columns.
This is translated as a delete followed by an insert.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"mm" <postto@.news.com> wrote in message
news:%23lUTk14mEHA.1296@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have setup unidirectional transaction replication between two SQL2k
> servers. On the subscription database I have set the PK as (Indentity not
> for Replication).
> I can insert and delete records on the publisher and they get replicated
> without any errors, but on the updates I get an error.
> The issue I belieive is with the generated sp_MSupd stored procedure. For
> some reason it is tring to execute the first block even if the logic is
> false.
> Can someone please advise how to get around this issue.
> Thanks
>
>
Labels:
database,
error,
identity,
indentity,
microsoft,
mysql,
notfor,
oracle,
replication,
server,
setup,
sql,
sql2kservers,
subscription,
transaction,
unidirectional,
update
Friday, March 9, 2012
Error 5 when creating a subscription
Hi,
After pushing a subscription I get an error:
SQL Server Enterprise Manager could not start the service 'SQLSERVERAGENT' on server '***'.
5 - (Access is denied)
How can I fix that?
Thanks in advance,
MikeSounds like the account on the publisher needs rights on the subscriber...
just a shot in the dark...|||How do I set these rights? I am not sure where I need to look for that information. I have admin rights on both servers.
After pushing a subscription I get an error:
SQL Server Enterprise Manager could not start the service 'SQLSERVERAGENT' on server '***'.
5 - (Access is denied)
How can I fix that?
Thanks in advance,
MikeSounds like the account on the publisher needs rights on the subscriber...
just a shot in the dark...|||How do I set these rights? I am not sure where I need to look for that information. I have admin rights on both servers.
Labels:
creating,
database,
enterprise,
error,
errorsql,
manager,
microsoft,
mysql,
oracle,
pushing,
server,
service,
sql,
sqlserveragent,
subscription
Friday, February 17, 2012
Error 21776 [SQL-DMO] name XXXX not found in Transpublication table.
Hi,
Does anyone know how to get over this problem in SQL 2000 without
removing all replication then adding back in?
Could not create a Pull subscription to publication XXX
Error 21776 [SQL-DMO] name XXXX not found in Transpublication table.
Thanks
Dave
Is the pull subscriber in the dbo role on the publisher and the distributor?
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
"David Gray" <grayd@.turpin-distribution.com> wrote in message
news:28j6s25v4j97onbjvg6j05pdv1uq56pmob@.4ax.com...
> Hi,
> Does anyone know how to get over this problem in SQL 2000 without
> removing all replication then adding back in?
> Could not create a Pull subscription to publication XXX
> Error 21776 [SQL-DMO] name XXXX not found in Transpublication table.
> Thanks
> Dave
|||On Fri, 2 Feb 2007 10:37:32 -0500, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:
>Is the pull subscriber in the dbo role on the publisher and the distributor?
Hi,
I'm not sure what you mean. I'm not able to add the subscriber
because of the error mentioned in the subject line.
The other strange thing is that none of the other subscribers on this
SQL 2K box appear in the Replication | Subscriptions tree (EM Console)
even after I refresh.
Dave
Does anyone know how to get over this problem in SQL 2000 without
removing all replication then adding back in?
Could not create a Pull subscription to publication XXX
Error 21776 [SQL-DMO] name XXXX not found in Transpublication table.
Thanks
Dave
Is the pull subscriber in the dbo role on the publisher and the distributor?
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
"David Gray" <grayd@.turpin-distribution.com> wrote in message
news:28j6s25v4j97onbjvg6j05pdv1uq56pmob@.4ax.com...
> Hi,
> Does anyone know how to get over this problem in SQL 2000 without
> removing all replication then adding back in?
> Could not create a Pull subscription to publication XXX
> Error 21776 [SQL-DMO] name XXXX not found in Transpublication table.
> Thanks
> Dave
|||On Fri, 2 Feb 2007 10:37:32 -0500, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:
>Is the pull subscriber in the dbo role on the publisher and the distributor?
Hi,
I'm not sure what you mean. I'm not able to add the subscriber
because of the error mentioned in the subject line.
The other strange thing is that none of the other subscribers on this
SQL 2K box appear in the Replication | Subscriptions tree (EM Console)
even after I refresh.
Dave
Labels:
adding,
back,
create,
database,
error,
incould,
microsoft,
mysql,
oracle,
pull,
replication,
server,
sql,
sql-dmo,
subscription,
table,
transpublication,
withoutremoving,
xxxx
Error 21074: Subscriptions being made inactive
Hi,
In my Single subscriber setup with Transactional Replication, i have
received this error on Distribution agent:
"The subscription(s) have been marked inactive and must be
reinitialized. NoSync subscriptions will need to be dropped and
recreated."
I know that this error occurs when the pull agent is unable to
transfer transactions to the Subscriber and the distribution DB is
piling up with transactions. And this happens for more than 48hrs
(default).
1. Can someone help in finding the possible reasons for my
distribution DB not running?
Am unable to see any errors, since all my log entries in the
Distribution Agent History have got cleaned because this issue occured
some one month back. All maintenance agents are run at default
settings.
2. As a solution, i just made the subscription status to Active by
running the below query:
update distribution..MSsubscriptions set status=2 where
publisher_id='x' and
publisher_db='x' and publication_id='x' and subscriber_id='x' and
subscriber_db='x'
However, the transactions which were run between subscription turning
from inactive to Active does not get synchronised. This causes some of
them to be lost. And only new transactions from the time it is made
active are being sent. Is this by design or changeable?
Please help me asap.
Thanks in advance,
Lavanya
On Apr 3, 12:07 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Have a look at the schedule of the distribution agent on the subscriber. If
> it's on demand then this is quite understandable and setting the transaction
> retention period, the history retention period and the publication's
> reinitialization period all to a suitably high value will prevent this
> occurring next time.
> At this stage you'll need to reinitialize rather than try to fix the status,
> as some commands might have been cleaned-up so there could be
> non-convergence occurring.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
Thanks Paul.
Distribution agents run continuously from all publishers to this
centralized subscriber.
Due to some reason, the distribution agent was in retrying state for
more than the transaction retention period and hence the subscription
got marked as inacive.
Does History retention period cause subscription to become inactive?
Hope it does not.
Another clarification is whether setting transaction retention period
as 365 days, how do i measure/expect the transactional replication
performance to be affected? I use multiple publishers and a
centralised subscriber.
|||On Apr 3, 11:57 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> The History retention period needs to be set to be consistant with the
> transaction retention period.
> If the retention period is set to be 1 year, the distribution database can
> balloon up and the distribution agent can take progressively longer finding
> the commands to be sent to the subscriber.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
Let me know what do you mean by maintaining the history retention
period as consistent.
Can i set something like this? Will this have an impact on
performance?
History retention = 100 hours
Transaction retention = 72 hours.
Also, Does History retention period cause subscription to become
inactive?
Thanks,
Lavanya
In my Single subscriber setup with Transactional Replication, i have
received this error on Distribution agent:
"The subscription(s) have been marked inactive and must be
reinitialized. NoSync subscriptions will need to be dropped and
recreated."
I know that this error occurs when the pull agent is unable to
transfer transactions to the Subscriber and the distribution DB is
piling up with transactions. And this happens for more than 48hrs
(default).
1. Can someone help in finding the possible reasons for my
distribution DB not running?
Am unable to see any errors, since all my log entries in the
Distribution Agent History have got cleaned because this issue occured
some one month back. All maintenance agents are run at default
settings.
2. As a solution, i just made the subscription status to Active by
running the below query:
update distribution..MSsubscriptions set status=2 where
publisher_id='x' and
publisher_db='x' and publication_id='x' and subscriber_id='x' and
subscriber_db='x'
However, the transactions which were run between subscription turning
from inactive to Active does not get synchronised. This causes some of
them to be lost. And only new transactions from the time it is made
active are being sent. Is this by design or changeable?
Please help me asap.
Thanks in advance,
Lavanya
On Apr 3, 12:07 am, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> Have a look at the schedule of the distribution agent on the subscriber. If
> it's on demand then this is quite understandable and setting the transaction
> retention period, the history retention period and the publication's
> reinitialization period all to a suitably high value will prevent this
> occurring next time.
> At this stage you'll need to reinitialize rather than try to fix the status,
> as some commands might have been cleaned-up so there could be
> non-convergence occurring.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
Thanks Paul.
Distribution agents run continuously from all publishers to this
centralized subscriber.
Due to some reason, the distribution agent was in retrying state for
more than the transaction retention period and hence the subscription
got marked as inacive.
Does History retention period cause subscription to become inactive?
Hope it does not.
Another clarification is whether setting transaction retention period
as 365 days, how do i measure/expect the transactional replication
performance to be affected? I use multiple publishers and a
centralised subscriber.
|||On Apr 3, 11:57 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> The History retention period needs to be set to be consistant with the
> transaction retention period.
> If the retention period is set to be 1 year, the distribution database can
> balloon up and the distribution agent can take progressively longer finding
> the commands to be sent to the subscriber.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
Let me know what do you mean by maintaining the history retention
period as consistent.
Can i set something like this? Will this have an impact on
performance?
History retention = 100 hours
Transaction retention = 72 hours.
Also, Does History retention period cause subscription to become
inactive?
Thanks,
Lavanya
Labels:
agent,
database,
distribution,
error,
havereceived,
inactive,
microsoft,
mysql,
oracle,
replication,
server,
setup,
single,
sql,
subscriber,
subscription,
subscriptions,
transactional
Wednesday, February 15, 2012
Error 208
Running - SQL 2K Win2K
When I attempt to create a pull subscription from Server A to Server B,
I get the error message,
Error 208:Invalid object name 'syspublications'.
Invalid object name 'sysextendedarticlesview'.
I have done some research & have read everything from remove replicaton
to copy these objects from another server and create them on Server A.
All I am looking for is...
1. What caused this.
2. How do I fix it.
AHIA,
Larry...
This error is most frequently caused by restoring a published database.
The best fix is to copy the objects from a database of the same version
where they are present. Right click on them in EM, and select copy. Then
paste them into QA with the focus on the problem db and execute it.
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
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1134404027.880653.314400@.g43g2000cwa.googlegr oups.com...
> Running - SQL 2K Win2K
> When I attempt to create a pull subscription from Server A to Server B,
> I get the error message,
> Error 208:Invalid object name 'syspublications'.
> Invalid object name 'sysextendedarticlesview'.
> I have done some research & have read everything from remove replicaton
> to copy these objects from another server and create them on Server A.
> All I am looking for is...
> 1. What caused this.
> 2. How do I fix it.
> AHIA,
> Larry...
>
When I attempt to create a pull subscription from Server A to Server B,
I get the error message,
Error 208:Invalid object name 'syspublications'.
Invalid object name 'sysextendedarticlesview'.
I have done some research & have read everything from remove replicaton
to copy these objects from another server and create them on Server A.
All I am looking for is...
1. What caused this.
2. How do I fix it.
AHIA,
Larry...
This error is most frequently caused by restoring a published database.
The best fix is to copy the objects from a database of the same version
where they are present. Right click on them in EM, and select copy. Then
paste them into QA with the focus on the problem db and execute it.
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
"LPR-3rd" <lreames@.gmail.com> wrote in message
news:1134404027.880653.314400@.g43g2000cwa.googlegr oups.com...
> Running - SQL 2K Win2K
> When I attempt to create a pull subscription from Server A to Server B,
> I get the error message,
> Error 208:Invalid object name 'syspublications'.
> Invalid object name 'sysextendedarticlesview'.
> I have done some research & have read everything from remove replicaton
> to copy these objects from another server and create them on Server A.
> All I am looking for is...
> 1. What caused this.
> 2. How do I fix it.
> AHIA,
> Larry...
>
Subscribe to:
Posts (Atom)