You can’t remove all data related with Cross-Referencing from the BizTalk Server database

Problem

When you delete all of the information related through cross-referencing from the BizTalk Server database, you receive an error.

Cause

The xref_IDXREF and xref_ValueXRef tables must have at least one empty row.

Solution

Insert one blank row into the xref_IDXREF and xref_ValueXRef tables using the following SQL script:

use BizTalkMgmtDb; set IDENTITY_INSERT xref_IDXRef ON insert xref_IDXRef (idXRefID, idXRef) values (1, '') set IDENTITY_INSERT xref_IDXRef OFF set IDENTITY_INSERT xref_ValueXRef ON insert xref_ValueXRef (valueXRefID, valueXRefName) values (1, '') set IDENTITY_INSERT xref_ValueXRef OFF

Source: Microsoft