Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Error 5103 : Unable to append to m_BSReply

I have an agent job that is scheduled to run every 3 minutes, who's first task is to refresh a SF object to a local SQL server table.
Yesterday, every 15 minutes, (or every 5th, 3 minute run) the job would fail with the message, "for linked server "SALESFORCE" returned message "Error 5103 : Unable to append to m_BSReply" After a couple of hours of failing every 15 minutes, the job stated failing every time, (i.e. every three minutes).

I googled that error and found this posting:
https://getsatisfaction.com/dbamp/top...

I took the actions that Mr. Emerson suggested,
(i.e, do replicate, wait 30 minutes and resume refresh schedule) to no effect.

Further down, I see that Mr. Emerson asks:

1. Is CLR enabled on this SQL Server ?
2. What other linked servers are installed on this SQL Server ?
3. Does a SQL instance restart help the issue ?

Our answers are:
1. Yes
2. several SQL servers, and an AS400/DB2 database
3. Does a SQL instance restart help the issue ? Yes, we rebooted the server last night and I have not had this problem since.

Yesterday, I ran the sf_VasQuery proc that Emerson recommend, here were the results, (before and after reboot):

12376 1024 0 0 0 0 7/16/2013 19:28
219912 91328 0 0 0 0 7/17/2013 8:21

We know that something is chewing up our memory, but we don't know what. Is it dbAmp?
How do I prevent this from happening again?
1 person has
this problem
+1
Reply
  • What version of DBAmp do you have installed ?

    CLR is a massive VAS memory hog and makes a very difficult memory environment for linked servers. In fact, Microsoft recommends that if you are using the CLR extensively that you migrate to a 64 bit SQL Server. Is this a possibility ?

    Finally, are you sure you have the latest version of the AS/400 driver installed ?

    Finally, do you use a 3rd party SQL backup tool like SQL Safe ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned sad, anxious, confused, frustrated