Welcome to dbForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Error trying to update the value of a Row Filtered Column ..

 
   Database Forums (Home) -> Replication RSS
Next:  Create tables problem  
Author Message
info

External


Since: Jan 23, 2008
Posts: 16



(Msg. 1) Posted: Tue Sep 30, 2008 9:02 pm
Post subject: Error trying to update the value of a Row Filtered Column value
Archived from groups: microsoft>public>sqlserver>replication (more info?)

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 .. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Cannot update a timestamp column replication error on subs.. - I have recently followed the document http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog03.mspx to setup transactional replication in our current SQL Server 2000 production environment. Everything appeared to work correctly but when I...

accumulating the result of a snapshot replication filtered.. - hi all, Im running a snapshot replication on table. first, i gonna copy the entire table with a regional filter other than date second i'm going to replicate a days worth of data by using both the regional filter and date filter (getdate) to..

What is best way to update subscriber - Hi Freinds, SQL 2000 I have a publication with more than 800 articles and so often I get a structure update for publisher database.Sometime we have new table too. I am using transactional and merger replications to push the data to 2 subscribers. ..

UPDATE ROWGUID - I have two table with the same data but rowguid are different. I have a conflict with violation of primary key. How can I align rowguid without delete row (they are in foreign key with other table) ?

How not to replicate update statement - Hi, In a merge replicaton, how can I configure it so that the update statements will not be replicated to subscriber database? Thanks. Pingx
   Database Forums (Home) -> Replication All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]