Symptoms
Assume that you have Cumulative Update 6 (CU6) for BizTalk Server 2010 installed on a computer. When you redeploy some map DLL files that are referenced on receive or send ports to BizTalk Server 2010 by using Visual Studio, MSI import or Windows PowerShell, you will receive the following error messages:
Removal of the assembly failed. Make sure that all items in the assembly you are trying to remove fulfill the following conditions:
1. Pipelines, maps, and schemas are not being used by Send Ports or Receive Locations in the same or referenced application(s)
2. Roles have no enlisted parties
Database Error:
The DELETE statement conflicted with the REFERENCE constraint "bts_receiveport_transform_foreign_transformid". The conflict occurred in database "BizTalkMgmtDb", table "dbo.bts_receiveport_transform", column 'uidTransformGUID'.
The DELETE statement conflicted with the REFERENCE constraint "fk_bt_mapspec_bts_item". The conflict occurred in database "BizTalkMgmtDb", table "dbo.bt_MapSpec", column 'itemid'.
The DELETE statement conflicted with the REFERENCE constraint "bts_receiveport_transform_foreign_transformid". The conflict occurred in database "BizTalkMgmtDb", table "dbo.bts_receiveport_transform", column 'uidTransformGUID'.
The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
Resolution
Cumulative update information
BizTalk Server 2010
This issue was first fixed in the following cumulative update of BizTalk Server 2010:
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.