I have Row Filtered Transaction Replication setup - I want to breakout
a table by year so the filter is YEAR([datefield]] = 2005 for example.
There are 3 databases that subscribe to 3 separate publications; 1 for
each year. The databases are called D_2004, D_2005, D_2006 .
For a test to see if a record would go from subscriber to another by
changing the year of the datefield. I asked a peer to update a record
in the 1 article that is published with this row filter setting. He
updated the datefield itself for 1 row. The datefield's value was set
to '1/1/1999' and it previously was '1/1/2004'. The subscriber D_2004
had this record in it at the time the update was issued.
The log reader now reads the following.
2008-10-01 02:57:28.469 The process could not execute 'sp_replcmds' on
'QASQLCRM01\SQLQA'.
2008-10-01 02:57:28.469 Status: 0, code: 18764, text: 'Execution of
filter stored procedure 981942920 failed. See the SQL Server errorlog
for more information.'.
2008-10-01 02:57:28.469 Status: 0, code: 18805, text: 'The Log Reader
Agent failed to construct a replicated command from log sequence
number (LSN) {0013969f:00006154:001f}. Back up the publication
database and contact Customer Support Services.'.
2008-10-01 02:57:28.469 Status: 0, code: 22037, text: 'The process
could not execute 'sp_replcmds' on 'QASQLCRM01\SQLQA'.'.
The Log Read Agent is in a retry state. I have Cumulative Update 9
installed. The subscriber is on the same server as the distributor.
Can someone explain what happened?
Thank you,
Erik
>> Stay informed about: Error trying to update the value of a Row Filtered Column ..