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 parties
Database 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'.
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_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'.