|
Home > Archive > BizTalk Server > August 2005 > What is SQL SPID (Blocked By -2)?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
What is SQL SPID (Blocked By -2)?
|
|
|
| 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
| |
| Paul Somers\(MVP\) 2005-08-12, 5:57 pm |
| 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
>
>
>
>
|
|
|
|
|