SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The process could not execute ''sp_replcmds'' on PRODUCTION


The process could not execute ''sp_replcmds'' on PRODUCTION

Author
Message
Emmanuel-484799
Emmanuel-484799
Valued Member
Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)

Group: General Forum Members
Points: 63 Visits: 3

Hi Champs,

Thursday i run DDREINDEX on my Production Server, Next day i went to office i find out that Replication is not working, It Marked as RED Cross on Replication Monitor.

Production Server Transactional Replication to Subscriber Server (Reporting Server)

In the Log Reader Agent I seen the Message The process could not execute 'sp_replcmds' on 'servername'

Actually am new to this Replication, Now what can i do Please help me.

I Stop the Agent and Re-run but still the same error message is coming

Please help me it will be very greatefull.

Thanks

Emmanuel

emmanuel_canagallas@hotmail.co.uk


Jo Pattyn
Jo Pattyn
SSCertifiable
SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)

Group: General Forum Members
Points: 7101 Visits: 10009
It could be timing out. You can change batchsize & timeout in the replication agent profiles.
Emmanuel-484799
Emmanuel-484799
Valued Member
Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)

Group: General Forum Members
Points: 63 Visits: 3

Hi I Changed the timeout from 10 to 40, but still its giving same error message.

and my Log file is also filling before is like 2GB on (Thursday) now its increases to 18GB

I think all the Replication Transactions are stored in the Log file.

Every 15min Transaction Log Backup is running and Once a Full backup at mid night.

I really dont know what to do? Please can you help

Thanks..


Jo Pattyn
Jo Pattyn
SSCertifiable
SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)

Group: General Forum Members
Points: 7101 Visits: 10009
I would start with reducing the batch size.
It was needed at work to reduce it from 500 to 100 because our subscriber was slower in IO
Found the kb:
http://support.microsoft.com/kb/811030
Emmanuel-484799
Emmanuel-484799
Valued Member
Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)Valued Member (63 reputation)

Group: General Forum Members
Points: 63 Visits: 3

Ok i changed the batch size to 100.

I run the Agents am wating for the Result.

mean time What about the Log file its reached 18GB what can i do with it.

Cheers..


Jo Pattyn
Jo Pattyn
SSCertifiable
SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)

Group: General Forum Members
Points: 7101 Visits: 10009
You can perform a transaction log backup. It automatically truncates the inactive portion of the transaction log.
Aditya-474792
Aditya-474792
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 50
I think we cannot truncate transaction logs until log reader agent moves the transactions to teh subscriber
ps.
ps.
SSCertifiable
SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)

Group: General Forum Members
Points: 7105 Visits: 3668
Aditya (1/19/2009)
I think we cannot truncate transaction logs until log reader agent moves the transactions to teh subscriber


to the distribution database to be more specific.



Pradeep Singh
stamic
stamic
Old Hand
Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)Old Hand (319 reputation)

Group: General Forum Members
Points: 319 Visits: 482
Reducing the batch size did not work for me on this issue, however, by reapplying the snapshot to the subscriber I was able to get the log reader to function without the error. I assume this is because the bulk of the records in the log on the publisher that were marked for replication were brought over with the snapshot. Regardless, wanted to share this info on this subject.
Graeme100
Graeme100
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2352 Visits: 795
Yes applying a new snapshot is a last resort..

In your situation, you needed to let the logreader "catch up" as there were many transactions in the TLog. This may have meant stopping activity on your database...perhaps that would not have been viable.

Regards
Graeme



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search