The DELETE statement conflicted with the REFERENCE constraint
"adm_ReceiveLocation_fk_Pipeline". The conflict occurred in database
"BizTalkMgmtDb", table "dbo.adm_ReceiveLocation", column
'ReceivePipelineId'.
The statement has been terminated."
To fix this you can delete and the associated BizTalk applications. Load the MSI and then reload the other applications. I will copy the needed artifacts , in the other application and give them a different name.
