I have replitation setup from sql 2008r2 publication to 2012 subscriber
it was working fine and after 4h i faced error:
Error messages: The process could not execute 'sp_replcmds' on 'PB01PROD'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Get help: http://help/MSSQL_REPL20011 Could not locate text information records for the column "Komentarz", ID 5 during command construction. (Source: MSSQLServer, Error number: 18773) Get help: http://help/18773
this column is text datatype…
I found similar problem here
Replication Error when adding small table as new article
but i was not adding new table
and potential solution is kb 2655789
but this kb does not exists anymore and as far as i googled it is only for 2012 only.
Is there solution for 2008r2 also ?
Or perhaps can it be this subscriber 2012 issue? we will try sp4 on this 2012 that contain this KB but i think that this is publication – if subscription would be the problem then this message would apear in distributor to subscriber logs.