FIX: Redeployment of schema referenced by maps fails after you install BizTalk Server

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

Third-party information disclaimer

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.

Properties

Article ID: 3167704 - Last Review: 10/10/2016 21:29:00 - Revision: 3.0

Microsoft BizTalk Server 2013 R2 Branch, Microsoft BizTalk Server 2013 R2 Developer, Microsoft BizTalk Server 2013 R2 Enterprise, Microsoft BizTalk Server 2013 R2 Standard, Microsoft BizTalk Server 2013 Branch, Microsoft BizTalk Server 2013 Developer, Microsoft BizTalk Server 2013 Enterprise, Microsoft BizTalk Server 2013 Standard

  • kbqfe kbsurveynew kbfix kbexpertiseadvanced kbbts KB3167704
Feedback