Wednesday, September 14, 2011

Biztalk error:Cannot locate document specification because multiple schemas matched the message type

I have two biztalk application querying data from oracle database one of them connecting to testing db and other staging db.both db have the objects with same schema, tables,views,packages,procedures,functions.....

so when i start the orchestartion and test the application i get error

There was a failure executing the response(receive) pipeline: "Microsoft.BizTalk.DefaultPipelines.XMLReceive, Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=4FbH8369ad789B92" Source: "XML disassembler" Send Port: "SENDPORTNAME" URI: "oracledb://connectionstring/" Reason: Cannot locate document specification because multiple schemas matched the message type "http://Microsoft.LobServices.OracleDB/2007/03/SCHEMA/View/VIEW_NAME#SelectResponse".

i could easily understand the error is due to the same object name in both databases because other application is already using the message type.

what i could do is

go to BizTalk Administration - Applications - Application Name - Send Ports - open SENDPORTNAME - click on Receive Pipeline properties

and set AllowUnrecognisedMessage to True

click ok  and apply . check the orchestration again by dropping a message or calling the webservice . it works !!

1 comment: