We are using transactional replication with queued updating between
SQL2000 Servers (Win 2003).
1) The queue reader has failed with the error message "Queue Reader
aborting. The step failed."
The error details stack shows (from last to first):
Queue Reader aborting. The step failed
Processed 53 queued trans, 105 cmds, 1 conflicts
Failed while applying queued message to publisher
CQueueRdrRowChange: ApplyCommand: Failed to create instance of
pMessage->pParams(ProcParams)
What's causing this? How can I restart the Queue Reader Agent after the
failure?
thanks,
Fabio
I take it that the error repeats next time you run the queue reader. To
restart it after failure I would put it on a schedule of every 5 minutes.
You can have it return to job step 1 on failure.
How many subscribers do you have? Also queued is designed for less than 10
subscribers and where the majority of the DML occurs on the publisher - does
your topology fit into this case?
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
<fabio.pliger@.gmail.com> wrote in message
news:1164187151.581038.182820@.j44g2000cwa.googlegr oups.com...
> Hi,
> We are using transactional replication with queued updating between
> SQL2000 Servers (Win 2003).
> 1) The queue reader has failed with the error message "Queue Reader
> aborting. The step failed."
> The error details stack shows (from last to first):
> Queue Reader aborting. The step failed
> Processed 53 queued trans, 105 cmds, 1 conflicts
> Failed while applying queued message to publisher
> CQueueRdrRowChange: ApplyCommand: Failed to create instance of
> pMessage->pParams(ProcParams)
> What's causing this? How can I restart the Queue Reader Agent after the
> failure?
> thanks,
> Fabio
>
|||Yes, the error repeates everytime i re-run the queue reader.. and it
always returns me those actions:
- Queue reader aborting...
- Processing ## queued trans, ## cmds, ## conflicts
- Failed whiale applying queued message to publisher
- CQueuedRdrRowChange::ApplyCommand: Failed.... bla bla...
- Queue Reader Agent blabla Started
- Starting agent
I do have 5 subscribers. 4 of those have a filter by column on only one
table.
Much DML occurs also at the subscribers...
I see that after the agentes fails... data from 2 of the subscribers is
sent to the publisher (and their Ms_replication_queue table il empty,
but no data from the others subscribers is sent to the publisher and
their replication queue table is unchanged... Can help if i delete all
the records in those tables at the subscribers?
What kind of error is that? Any hint on what i can look at to solve it?
thanks,
Fabio
Hilary Cotter ha scritto:
[vbcol=seagreen]
> I take it that the error repeats next time you run the queue reader. To
> restart it after failure I would put it on a schedule of every 5 minutes.
> You can have it return to job step 1 on failure.
> How many subscribers do you have? Also queued is designed for less than 10
> subscribers and where the majority of the DML occurs on the publisher - does
> your topology fit into this case?
> --
> 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
>
> <fabio.pliger@.gmail.com> wrote in message
> news:1164187151.581038.182820@.j44g2000cwa.googlegr oups.com...
|||Can you enable logging? Follow these steps
http://support.microsoft.com/default.aspx?scid=kb;en-us;312292&sd=tech
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
<fabio.pliger@.gmail.com> wrote in message
news:1164207423.995497.310220@.h48g2000cwc.googlegr oups.com...
> Yes, the error repeates everytime i re-run the queue reader.. and it
> always returns me those actions:
> - Queue reader aborting...
> - Processing ## queued trans, ## cmds, ## conflicts
> - Failed whiale applying queued message to publisher
> - CQueuedRdrRowChange::ApplyCommand: Failed.... bla bla...
> - Queue Reader Agent blabla Started
> - Starting agent
> I do have 5 subscribers. 4 of those have a filter by column on only one
> table.
> Much DML occurs also at the subscribers...
> I see that after the agentes fails... data from 2 of the subscribers is
> sent to the publisher (and their Ms_replication_queue table il empty,
> but no data from the others subscribers is sent to the publisher and
> their replication queue table is unchanged... Can help if i delete all
> the records in those tables at the subscribers?
> What kind of error is that? Any hint on what i can look at to solve it?
> thanks,
> Fabio
>
> Hilary Cotter ha scritto:
>
|||Here's what i get:
Connecting to QueueReader 'WN055.distribution'
Queue Reader Agent [WN055].8 (Id = 5) started
[11/22/2006 4:32:11 PM]WN055.distribution: execute
dbo.sp_MShelp_profile 5, 9, N''
Connecting to WN046 'WN046.FDF'
[11/22/2006 4:32:11 PM]WN055.distribution: exec
dbo.sp_helpdistpublisher @.publisher = N'WN055'
Connecting to WN055 'WN055.FDF'
SQL Command : <exec [dbo].[sp_MSsync_ins_Aut_LogBatch_3] N'WN046',
N'FDF', 250008816, 250000361, N'AUTO', '2006-11-22 16:19:32.000',
N'34B4', '5992D20D-A9E7-40AF-AB71-43F650E4E8AC', 1>
Disconnecting from WN055 'WN055'
Disconnecting from WN046 'WN046'
Connecting to WN030 'WN030.FDF'
[11/22/2006 4:32:26 PM]WN055.distribution: exec
dbo.sp_helpdistpublisher @.publisher = N'WN055'
Connecting to WN055 'WN055.FDF'
CQueueRdrRowChange::ApplyCommand:Failed to create instance of
pMessage->pParams(ProcParams)
Failed while applying queued message to publisher
Disconnecting from WN055 'WN055'
Worker Thread 540 : Task Failed
Disconnecting from WN030 'WN030'
Processed 29 queued trans, 57 cmds, 0 conflicts
Queue Reader aborting
It seem's like the subscriber WN030has some problems comunicating with
publisher-... right? Any hint?
Fabio
Hilary Cotter ha scritto:
[vbcol=seagreen]
> Can you enable logging? Follow these steps
> http://support.microsoft.com/default.aspx?scid=kb;en-us;312292&sd=tech
> --
> 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
>
> <fabio.pliger@.gmail.com> wrote in message
> news:1164207423.995497.310220@.h48g2000cwc.googlegr oups.com...
|||I've shutedown the sqlserveragent at the subscriber WN030 (the one
generating the error...) and the queue reader agent don't fails
anymore... So.. bypassing this subscriber the agent is able to run..
but my goal is to solve the problem and reconnect the subscriber...
Deleting the MS_replicationqueue at tje subscriber can help? I would
prefer to don't loose those transactions... but if it's the only way i
can delete it...
thanks,
Fabio
fabio.pliger@.gmail.com ha scritto:
[vbcol=seagreen]
> Here's what i get:
> Connecting to QueueReader 'WN055.distribution'
> Queue Reader Agent [WN055].8 (Id = 5) started
> [11/22/2006 4:32:11 PM]WN055.distribution: execute
> dbo.sp_MShelp_profile 5, 9, N''
> Connecting to WN046 'WN046.FDF'
> [11/22/2006 4:32:11 PM]WN055.distribution: exec
> dbo.sp_helpdistpublisher @.publisher = N'WN055'
> Connecting to WN055 'WN055.FDF'
> SQL Command : <exec [dbo].[sp_MSsync_ins_Aut_LogBatch_3] N'WN046',
> N'FDF', 250008816, 250000361, N'AUTO', '2006-11-22 16:19:32.000',
> N'34B4', '5992D20D-A9E7-40AF-AB71-43F650E4E8AC', 1>
> Disconnecting from WN055 'WN05
> Disconnecting from WN046 'WN046'
> Connecting to WN030 'WN030.FDF'
> [11/22/2006 4:32:26 PM]WN055.distribution: exec
> dbo.sp_helpdistpublisher @.publisher = N'WN055'
> Connecting to WN055 'WN055.FDF'
> CQueueRdrRowChange::ApplyCommand:Failed to create instance of
> pMessage->pParams(ProcParams)
> Failed while applying queued message to publisher
> Disconnecting from WN055 'WN055'
> Worker Thread 540 : Task Failed
> Disconnecting from WN030 'WN030'
> Processed 29 queued trans, 57 cmds, 0 conflicts
> Queue Reader aborting
>
> It seem's like the subscriber WN030has some problems comunicating with
> publisher-... right? Any hint?
> Fabio
>
>
> Hilary Cotter ha scritto:
|||No, it looks like it is crashing on a single command. Almost like there is a
command in the queue causing it to crash.
Deleting the contents of the queue will cause you to lose work. I would stop
all users working on the subscriber database and try to flush the queue and
see if there is a command stuck in there.
keep logging, and run the queue until one command remains and then I would
consider deleting that one command.
Something is very wrong here. I think you should open a support incident
with Microsoft on this one. Where is Raymond when you really want him?
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
<fabio.pliger@.gmail.com> wrote in message
news:1164210515.241841.233780@.f16g2000cwb.googlegr oups.com...
> Here's what i get:
> Connecting to QueueReader 'WN055.distribution'
> Queue Reader Agent [WN055].8 (Id = 5) started
> [11/22/2006 4:32:11 PM]WN055.distribution: execute
> dbo.sp_MShelp_profile 5, 9, N''
> Connecting to WN046 'WN046.FDF'
> [11/22/2006 4:32:11 PM]WN055.distribution: exec
> dbo.sp_helpdistpublisher @.publisher = N'WN055'
> Connecting to WN055 'WN055.FDF'
> SQL Command : <exec [dbo].[sp_MSsync_ins_Aut_LogBatch_3] N'WN046',
> N'FDF', 250008816, 250000361, N'AUTO', '2006-11-22 16:19:32.000',
> N'34B4', '5992D20D-A9E7-40AF-AB71-43F650E4E8AC', 1>
> Disconnecting from WN055 'WN055'
> Disconnecting from WN046 'WN046'
> Connecting to WN030 'WN030.FDF'
> [11/22/2006 4:32:26 PM]WN055.distribution: exec
> dbo.sp_helpdistpublisher @.publisher = N'WN055'
> Connecting to WN055 'WN055.FDF'
> CQueueRdrRowChange::ApplyCommand:Failed to create instance of
> pMessage->pParams(ProcParams)
> Failed while applying queued message to publisher
> Disconnecting from WN055 'WN055'
> Worker Thread 540 : Task Failed
> Disconnecting from WN030 'WN030'
> Processed 29 queued trans, 57 cmds, 0 conflicts
> Queue Reader aborting
>
> It seem's like the subscriber WN030has some problems comunicating with
> publisher-... right? Any hint?
> Fabio
>
>
> Hilary Cotter ha scritto:
>
|||Sorry for my bad english..
but what do you mean by flushing thequeue? comand queue at the distributor or the queue table at the
subscriber? Do u mean i should delete records one by one?
Hilary Cotter ha scritto:
> No, it looks like it is crashing on a single command. Almost like there is a
> command in the queue causing it to crash.
> Deleting the contents of the queue will cause you to lose work. I would stop
> all users working on the subscriber database and try to flush the queue and
> see if there is a command stuck in there.
> keep logging, and run the queue until one command remains and then I would
> consider deleting that one command.
> Something is very wrong here. I think you should open a support incident
> with Microsoft on this one. Where is Raymond when you really want him?
> --
> 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
>
>
No comments:
Post a Comment