Troubleshooting Schemas

This section offers advice on how to identify and resolve common schema issues.

You receive error 'Namespace:Element1 cannot be a member of substitution group with head element Namespace:Element2' when compiling your solution

Problem

You receive the error 'Namespace:Element1 cannot be a member of substitution group with head element Namespace:Element2' when compiling your BizTalk Server 2006 solution.

Cause

This issue occurs if the schema contains the substitutionGroup element. This primarily affects EAN, UCC, and EDI schemas.

Resolution

Modify the schema so that the schema does not contain the substitutionGroup element. If required, implement similar functionality directly in the XSLT by using a custom functoid or custom script.

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
Show: