Hello,

we are unable to remove one of our deployed assemblies from the BiztalkMgmt
DB.

The Deployment Wizard states that the assembly is still bound to certain
Ports (that do not
exist anymore!)
We already tried running this script:

use BiztalkMgmtDB
go
declare @iAssemblyID int
select @iAssemblyID=nID from bts_assembly where nvcName = 'yourAssemblyName'
delete from bt_mapspec where assemblyid = @iAssemblyID
delete from bt_documentspec where assemblyid = @iAssemblyID
delete from bts_item where assemblyid = @iAssemblyID
delete from bt_properties where nassemblyid = @iAssemblyID
delete from bt_sensitiveproperties where assemblyid = @iAssemblyID
delete from bts_assembly where nID = @iAssemblyID

And we get the following error messages:
Server: Msg 547, Level 16, State 1, Line 3

DELETE statement conflicted with COLUMN REFERENCE constraint
 'bts_receiveport_transform_foreign_trans
formid'. The conflict occurred in
database 'BizTalkMgmtDb', table 'bts_receiveport_transform', column
'uidTransformGUID'.   The statement has been terminated.

(0 row(s) affected)

Server: Msg 547, Level 16, State 1, Line 5

DELETE statement conflicted with COLUMN REFERENCE constraint
'FK_bt_MapSpec_bts_item'. The conflict occurred in database 'BizTalkMgmtDb',
table 'bt_MapSpec', column 'itemid'.   The statement has been terminated.

(0 row(s) affected)

(0 row(s) affected)

Server: Msg 547, Level 16, State 1, Line 8

DELETE statement conflicted with COLUMN REFERENCE constraint
 'bts_receiveport_transform_foreign_trans
formid'. The conflict occurred in
database 'BizTalkMgmtDb', table 'bts_receiveport_transform', column
'uidTransformGUID'. The statement has been terminated.

Any suggestions would be greatly appreciated.

Thanks,
Philippe

[ Post a follow-up to this message ]