Biztalk SQL Adapter error

I am getting the following error when I try to call a stored proc
using a SQL Adapter.

A message sent to adapter "SQL" on send port "ASCSQL" with URI "SQL://
KVASC/myDB/" is suspended.
 Error details: HRESULT="0x80040e14" Description="XML parsing: line 1,
character 94, equal expected"


The stored proc takes one parameter - an XML document - used to insert
or update a table(s). When I view the message in HAT, the parameters
value is set to (I've posted an abbreviated version b/c it's very
long):


<ns0:Loan_Request xmlns:ns0="http://
LoanTracker.Schemas.PowersellerUpdate">
  <ns0:spMIG_BTPwrSlrDirect LoanRecord="&lt;ns0:ASCLoans
xmlns:ns0=&quot;http://
LoanTracker.Schemas.ASCFlatFile&quot;&gt;&lt;Records&gt;...(a bunch of
elements and values)...&lt;/Records&gt;" />
</ns0:Loan_Request>


LoanRecord is the single parameter for the stored proc. The value
being assigned to this looks correct. The only thing different I did
was to create a new port type (separate from the one generated with
the SQL adapter) and use it to send the messages. I did this b/c the
port type generated by the SQL adapter wizard was a send-receive port
and I don't need to receive. When I tried to use it, it wouldn't
compile since I was hooking up the receive portion. So I created
another send only port type that used the same message type (Request)
as the generated one did. I don't know if this has anything to do with
it or not.


Is this an actual BizTalk error or is the SQL server throwing it back?
I'm at a loss.
Start Free Trial