An HWS task may be reassigned to two distinct TaskID identifiers at the same time in BizTalk Server 2004 (908160)

SYMPTOMS

In Microsoft BizTalk Server 2004, a TaskID identifier for a Human Workflow Services (HWS) task may be reassigned to two distinct TaskID identifiers at the same time. For example, TaskID identifier A may be reassigned to TaskID identifier B and TaskID identifier C in the Hws_TaskReassignment table in BizTalkDTADb database.

When this issue occurs, the Hws_TaskReassignment table in the BizTalkDTADb database may appear similar to the following. In this example, A, B, and C are TaskID identifier GUIDs.

TaskID	ReassignedToTaskID	FirstTaskID
A	B	A
B	NULL	A
C	NULL	A

Additionally, you may receive an error message when you call the GetAllTasksForUser function from the Microsoft BizTalk Server 2004 SDK.

select trAll.*
from Hws_TaskReassignment tr
inner join Hws_TaskReassignment trAll
on tr.FirstTaskID = trAll.FirstTaskID
where tr.TaskID NOT IN
(
SELECT ReassignedToTaskID
FROM Hws_TaskReassignment
WHERE ReassignedToTaskID IS NOT NULL
)
and tr.ReassignedToTaskID IS NULL
order by trAll.FirstTaskID