Symptoms
After you install Microsoft BizTalk Server, and then you redeploy a schema that's referenced by maps, you may 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 partiesDatabase Error:The DELETE statement conflicted with the REFERENCE constraint "bts_sendport_transform_foreign_transformid". The conflict occurred in database "BizTalkMgmtDb", table "dbo.bts_sendport_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_sendport_transform_foreign_transformid". The conflict occurred in database "BizTalkMgmtDb", table "dbo.bts_sendport_transform", column 'uidTransformGUID'.
Resolution
Cumulative update information
The fix that resolves this issue is included in the following cumulative update for BizTalk Server:
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
References
Learn about the service pack and cumulative update list for BizTalk Server.Learn about BizTalk Server hotfixes and cumulative update support.
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.
