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.
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.