Tuesday, April 19, 2005

Checking for duplicate message types in Biztalk

Ever been annoyed with the following message in the event viewer after deploying your freshly created Biztalk 2004 project:

There was a failure executing the receive pipeline:
"Microsoft.BizTalk.DefaultPipelines.XMLReceive"
Source: "XML disassembler"
Receive Location: "AAA.BBB.CCC"
Reason: The disassembler cannot retrieve the document specification
by using this type: "http://foo.com/bar#something".
Either the schema is not deployed correctly, or more than one schema
is deployed for the same message type.

You can check for the assemblies that are causing this by querying the Biztalk Management database:

select
d1.id, d1.msgtype, d1.docspec_name, d1.clr_assemblyname
from
bt_DocumentSpec d1,
bt_DocumentSpec d2
where
d1.id != d2.id
and d1.msgtype = d2.msgtype

No comments: