We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

process could not execute sp_msadd_replcmd

bibi92
bibi92 asked
on
Medium Priority
2,413 Views
Last Modified: 2012-06-21
Hello,

In the log reader agent, I see that there are some errors process could not execute sp_msadd_replcmd.
The parameters from the job are  -ReadBatchSize 10000 -MaxCmdsInTran 10000.
How can I explain these errors?

Thanks

bibi
Comment
Watch Question

lcohanDatabase Analyst
CERTIFIED EXPERT

Commented:
Check and make sure you have enough disk space for the files to grow especialy Distribution database.
Are you using SQL2005 express by any chance? If yes then I think you will see this error in the log no matter what.
lcohanDatabase Analyst
CERTIFIED EXPERT

Commented:
because you are limited to a 3gig maximum - sorry I hit submit by accident....

Author

Commented:
It's enterprise edition and there is enough space in db distribution.

Thanks

bibi
lcohanDatabase Analyst
CERTIFIED EXPERT

Commented:
Hmmmmm....Is this happeneing on any bacth size? Could you change the batch size to 1000 instead of  10,000? Obviously this should not be done directly in a prod environment as much as possible but in testing.
lcohanDatabase Analyst
CERTIFIED EXPERT

Commented:
Could you post the actual error if possible? Cleanup any sensitive info before that.
Is this error happeneing all the time or on some large batch UPDATE for instance?
Database Analyst
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks bibi
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.