Importing bindings Error: Cannot insert duplicate key row in object 'tpm.BusinessIdentity'

Question

I successfully deployed an application and am trying to import bindings.
However - during the import I get the following error:

• ## TITLE: Export Bindings

  Failed to update binding information. (mscorlib)

  ADDITIONAL INFORMATION:

  An error occurred while updating the entries. See the inner exception for details. (System.Data.Entity)

  Cannot insert duplicate key row in object 'tpm.BusinessIdentity' with unique index 'UK_Qualifier_Value_NonNullProfile'. The duplicate key value is (44, eInvoice.Ident , 933012867).
  The statement has been terminated. (Microsoft SQL Server, Error: 2601)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=15.00.4138&EvtSrc=MSSQLServer&EvtID=2601&LinkId=20476

  BUTTONS:

  OK

I checked the following table [BizTalkMgmtDb].[tpm].[BusinessIdentity] and it looks like this:

How to deal with this error please?

Answer 1

I would think that your bindings have party information in it, and those parties already exist.

If you just want the ports, either re-export the bindings from where you exported them originally and untick global parties, or manually edit the binding file to remove the party information