Log reader failed with error ''The step did not generate any output. The step failed''

Question

Post reply

Log reader failed with error ''The step did not generate any output. The step failed''

sqlquery-101401

SSCarpal Tunnel

Points: 4951
More actions
February 24, 2006 at 5:17 am

#189360

Hi ,

on my production server suddenly log reader agent is showing error 'The step did not generate any output. The step failed' for one of the publisher for other servers log reader is running fine.

but despite of the error replication is happening with out any issue ,but log reader agent reflects it is failed with red mark with the above error,any suggetion?i tried to rerun manually but no luck.

version:

sqlserver2000 with sp4

Thanks
February 27, 2006 at 8:00 am

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Mubeen Mohammed-203067 SSC Eights! Points: 817 More actions · Answer 1

I believe the replication has stopped for a while and it appears the red cross mark. It also happens when the publisher disconnects from subscribers for a while (like timeout or if you reboot) but when it sees the subscriber's and the connection re-establishes, then it starts posting the transactions and commands. If you right click on that Publisher and see whether Start Agent is enabled.