Unanswered: The process could not execute 'sp_replcmds'
I know this one has shown up here before, and I have tried the various things to get past this error and they are not working for this situation. First of all I have tried setting the ReadBatchSize to 1 and secondly I have made the QueryTimeout paramter 2000 in case that were the problem.
In looking at the Error Details within the Log Reader Agent, the following is the message:
Error Message: "The process could not execute 'sp_replcmds'"
Error Details: "An invalid datetime value was encountered. Value exceeds the year 9999."
I can not seem to find any additional information based on the Error Details. If any of you has a suggestion, I would love to hear them.
Changing Batchsize and Querytimeout won't help in this situation. The error that you getting is relating to the data you have in the database. It seems to me that you may have map the transformation from the publication to the subscription or you may have somehow change the DDL in publication without reinitialize it. The mapping is causing problems because a column was not able to convert to datetime. I would try to see what can find in the schema that a varchar or char being used as a datetime column. If you couldn't find any, reinitialize the subscription. The snapshot error log should tell you which table and which column was incorrect, or it may fix the problem because the DDL changes was published down.