Microsoft KB Archive/908160

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

Article ID: 908160

Article Last Modified on 8/15/2007

-

APPLIES TO


 * Microsoft BizTalk Server 2004 Standard Edition
 * Microsoft BizTalk Server 2004 Partner Edition
 * Microsoft BizTalk Server 2004 Enterprise Edition
 * Microsoft BizTalk Server 2004 Developer Edition

-





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.

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



CAUSE
This issue occurs because you submitted the same task two times.



WORKAROUND
To work around this issue, delete the duplicate record from the Hws_TaskReassignment and Hws_Tasks tables in the BizTalkDTADb database.



MORE INFORMATION
To identify the duplicate records, run the following query in SQL Query Analyzer: 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

Keywords: kbtshoot kbbug kbprb kbcode kbpubtypekc kbbtshws kbbts KB908160

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.