• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2125
  • Last Modified:

process could not execute sp_msadd_replcmd

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
0
bibi92
Asked:
bibi92
  • 5
  • 2
1 Solution
 
lcohanDatabase AnalystCommented:
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.
0
 
lcohanDatabase AnalystCommented:
because you are limited to a 3gig maximum - sorry I hit submit by accident....
0
 
bibi92Author Commented:
It's enterprise edition and there is enough space in db distribution.

Thanks

bibi
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
lcohanDatabase AnalystCommented:
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.
0
 
lcohanDatabase AnalystCommented:
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?
0
 
lcohanDatabase AnalystCommented:
Did you checked the query timepout like per article below:

http://support.microsoft.com/kb/811030
0
 
bibi92Author Commented:
Thanks bibi
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now