SQL Server Performance Forum – Threads Archive
Transactional Repliction with update subscription
We have a transactional replication with updatable subscription. this is on sql server 2005 and with SP1 and hotfix 2153 which was applied yesterday. Today this replication, queue reader failed with below mentioned error messages and I couldn’t find any thing on internet for this error message. Queue reader agent failed with below mentioned error message. Nzsrvsql01 is server name. Replication-Replication Transaction Queue Reader Subsystem: agent [NZSRVSQL01].5 failed. Unexpected Synctran Procedure sp_MSsync_del_fr_extract_4 provided by Queued triggers. Replication-Replication Transaction Queue Reader Subsystem: agent [NZSRVSQL01].5 failed. Failed while applying queued message to publisher Replication-Replication Transaction Queue Reader Subsystem: agent [NZSRVSQL01].5 failed. Queue Reader abortingWhy don’t you apply service pask 2
http://support.microsoft.com/kb/913089 There ar efew replication bus fixed in this service pack
http://support.microsoft.com/kb/921896/ —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
Enable replication agent logging and see if you get any clue… How to enable replication agents for logging to output files in SQL Server
http://support.microsoft.com/kb/312292
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Have started all the relevant agents after applying that hotfix? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Thanks group, its resolved now. Based on above error it report a object missing.
Looks like this object(sp_MSsync_del_fr_extract_4 ) was dropped in SP1. So I executed this script sp_script_synctran_commands ‘NAME OF PUBLICATION’ AND THEN applied this script on to other server which was complaining of this sync object.
Everything seems to fine after that… Thanks There’s no point in installing SP2 when within few week times we have more than 10 hotfixes for SP2.
Sp2 itself creates more issues…
I don’t understand about you saying more than 10 hotfix for Sp2 to install, please explian. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
I believe he is trying to say that the SP2 (NOT RELIABLE) itself had issues which resulted released hotfixes fot fix issues in SP2…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Hi Satya, By this I mean that SP2 itself has a lot many issues, as cleared by MohammedU. Thanks
Most of the issues related to MP not replication I believe…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Correct, in fact there are good fixes with regard to the replication. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>