SQL Server Replication Error occured during the new article addtion

Question

HI All,

We are facing the Sql Server Replication error during the new article addition.

Msg 20027, Level 11, State 1, Procedure sp_MSadd_subscription, Line 223
The article '(null)' does not exist.
Msg 14070, Level 16, State 1, Procedure sp_MSrepl_changesubstatus, Line 1208
Could not update the distribution database subscription table. The subscription status could not be changed.
Msg 14057, Level 16, State 1, Procedure sp_MSrepl_addsubscription_article, Line 383
The subscription could not be created.
Msg 266, Level 16, State 2, Procedure sp_MSrepl_addsubscription, Line 0
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.
Msg 266, Level 16, State 2, Procedure sp_addsubscription, Line 0
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. 

Please help us to fix the error.

Regards,

Pawan Singh

---

Thanks

Answer 1

Sounds like there is an open transaction.

In the same window where you created this script you need to issue a rollback command and then try the operation again step by step.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 2

thanks Hilary..for quick reply i want to know to about the open transaction it's replication command or any other OLTP command can we use dbcc opentran () to find out open transaction or need to use any other way.please specify the way of rollback the command.

---

Thanks

Answer 3

Yes you can. Did you deploy this new article via script? It almost sound like there was an error in your script.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 4

yes, I added new article using the script may be that script contains error so please can you define the step to rollback the transaction

Regards,

Pawan Singh

---

Thanks

Answer 5

Hi All,

I have checked there in no open transaction exist. on more thing I want to specify I have configure two different subscription on mu publisher and one of the subscription have three distribution agent running on that this may be a subject of worry. Please suggest.

---

Thanks