Has anyone run in to this SQL SPID (Blocked By -2) problem on the BizTalk
SQL Server?  It all starts when we get this error "Error Info: There was a
failure executing the receive pipeline: Source: "Flat file disassembler"
Receive Location: Reason: Failed to validate the document: "The element has
an invalid value according to its data type. An error occurred at , (1,
13293).".  Then the SPID -2 blocks access to BiztalkMsgBoxDB.dbo.spool
table.  Then the SQL Server scheduled BizTalk Jobs get blocked.  These SQL
jobs get installed with BizTalk and they are scheduled to run every minute.
I don't know where this SPID -2 is coming from and I can't see a -2 in the
SQL Server / Management / Current Activity / Process Info view.  I can't
find any documentation on it.

Thanks,

Val

[ Post a follow-up to this message ]

I am sure someone will come and correct me, as this was a while back,
however I have seen this, and I believe its an orphaned process, we tracked
it to one of the sql agent jobs eventually. It occurs when something is
switched off mid way through.


"Val" <vmarz@lance.com> wrote in message
news:%232OlZMRnFHA.2472@TK2MSFTNGP15.phx.gbl...
> Has anyone run in to this SQL SPID (Blocked By -2) problem on the BizTalk
> SQL Server?  It all starts when we get this error "Error Info: There was a
> failure executing the receive pipeline: Source: "Flat file disassembler"
> Receive Location: Reason: Failed to validate the document: "The element
> has an invalid value according to its data type. An error occurred at ,
> (1, 13293).".  Then the SPID -2 blocks access to BiztalkMsgBoxDB.dbo.spool
> table.  Then the SQL Server scheduled BizTalk Jobs get blocked.  These SQL
> jobs get installed with BizTalk and they are scheduled to run every
> minute. I don't know where this SPID -2 is coming from and I can't see
> a -2 in the SQL Server / Management / Current Activity / Process Info
> view.  I can't find any documentation on it.
>
> Thanks,
>
> Val
>
>
>
>

[ Post a follow-up to this message ]