Replication: Non-logged Agent Shutdown Errors

If you have ever had your distributor crash because of one of these, you have felt my pain.  My distributor just had a stroke, and I don’t even know where to start!  Replication is hurting.  Business users put their angry eyebrows on while they drum their fingers.  You have no idea what (if anything) changed on your publisher tables. You get online to research the issue, and you are likely to see that you will be directed to open a ticket with Microsoft. 

Don’t get me wrong; you may have to still do that.  But before you do, ask to see the application logs.  You might see something like this:

Msg:java.sql.SQLException: Length of LOB data (67992) to be replicated exceeds configured maximum 65536. Use the stored procedure sp_configure to increase the configured maximum value for max text repl size option, which defaults to 65536. A configured value of -1 indicates no limit, other that the limit imposed by the data type.

In other words, this is your problem:

Dilemma: Do you squeeze the elephant out, or enlarge the hole? Discuss.

Following the advice in the message above may just get you where you want to go…

Nobody puts Dumbo in a corner!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s