Verifying Schemas after deployment


After a developer builds and deploys the BizTalk application one verifies that the assembly of the application is present in the GAC. Sometimes when we test our solution we often get these errors below.

There was an error executing receive pipeline: Finding the document specification by
message type [MessageType] failed.Verify the schema deployed properly.

Or

There was a failure executing receive pipeline: Cannot locate document specification
because multiple schemas matched this message type [MessageType]

This error occurs when the BizTalk runtime cannot find the schema which conforms to the type of the message. To BizTalk the type of message is a combination of target namespace of the schema and the root node separated by pound (#) sign. for e.g. http://mycompany.schema#orders.

The BizTalkMgmtDb is the database where the application information is saved. The error mentioned above means that the schema is not deployed in BizTalk. The records of all the schemas that are deployed to BizTalk are in the bt_DocumentSpec table.  To check that the schema exists and is deployed properly open the query analyser on your BizTalk Server and use the BizTalkMgmtDb and run the query below. In the where clause place the correct target namespace and root node name which is being reported in the error log from the Event Viewer.

Select msgtype, assemblyid, clr_namespace, clr_assemblyname
from bt_documentspec
where msgtype = ‘http://mycompany.schema#orders’

If the record is present this verifies that the schema is deployed properly to BizTalk, if not the project containing the schema should be redeployed.

Advertisements

One Response to Verifying Schemas after deployment

  1. sindhu says:

    How to open uery analyser on your BizTalk Server and use the BizTalkMgmtDb?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: