Forum Replies Created
-
AuthorPosts
-
Thanks Richard
This post from the BizTalk Chalk Talk blog covers a lot of additional BizTalk Learning Resources: http://www.biztalkgurus.com/blogs/biztalksyn/archive/2006/07/30/BizTalk-Server-2006-Learning-Resources.aspx
Can you email me the schema for this message.
Can you also save the message that errors and send that as wellYou now have SSIS jobs instead. Just run those (or do a scheduled task to run the automatically).
I’d probably argue that the best two sources of BizTalk info (short of Stephen’s great forums here!) are the BizTalk Documentation (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/BTS06CoreDocs/html/cadd3bdd-f13b-427d-8979-b2541aa5e21d.asp?frame=true) and the full list of technical articles (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/BTS_2004WP/html/90a5261b-a220-41bf-bf7f-fd759239242c.asp?frame=true). Of the whitepapers, the \”Understandind BizTalk\” is good to start with, \”Messaging Engine Overview\” is a great read if you want to learn BizTalk’s guts, \”Using XML Schemas\” is a must.
I have to learn Biztalk 2006. My employer is implement biztalk and what is the best way to come up to speed on this tool.
I have about 15 years of programming experience in IT field.
Please point me to any good tutorials for beginers.
thanks
This code returns null:
[code:1:3089b7d000]//ContraxMSgs/ContraxMSg/MESSAGEID[/code:1:3089b7d000]
This code returns the exception:
[code:1:3089b7d000]
/*[local-name()=’ContraxMSgs’ and namespace-uri()=’http://MyCompany.MyApp.Messaging.BizTalk’]/*[localname=’ContraxMSg’ and namespace-uri()=’http://MyCompany.MyApp.Messaging.BizTalk’]/*[localname=’MESSAGEID’ and namespace-uri()=’http://MyCompany.MyApp.Messaging.BizTalk’]
[/code:1:3089b7d000]
I thought maybe I’m making some mistake with what I think the schema and/or xml message should look like but in my orchestration I have a receive shape with the correct message and then I have a send shape that just sends the message out to some folder as an xml file.Hope this helps (especially as I’m getting desperate)
Bill NWhich xpath string produced this error.
[code:1:465b2e19ff]//ContraxMSgs/ContraxMSg/MESSAGEID[/code:1:465b2e19ff]
Or
[code:1:465b2e19ff]/*[local-name()=’ContraxMSgs’ and namespace-uri()=’http://MyCompany.MyApp.Messaging.BizTalk’]/*[localname=’ContraxMSg’ and namespace-uri()=’http://MyCompany.MyApp.Messaging.BizTalk’]/*[localname=’MESSAGEID’ and namespace-uri()=’http://MyCompany.MyApp.Messaging.BizTalk’][/code:1:465b2e19ff]Do both xpath strings return the same error?
Check this page out:
http://msdn.microsoft.com/biztalk/downloads/samples/Scroll down to the sample titled \”Consuming Web Services\”.
Thanks. I finally got it to work by dropping the transform piece of the orchestration and recreating it. This forced me to reconfigured the Orchestration on the server, it then worked ok.
Will continue on!
Thanks
Thanks Greg for the reply.
Again, in XMLSpy the xpath works correctly. However I’m getting this application error in the event viewer:
[code:1:de243100e0]
Event Type: Error
Event Source: XLANG/s
Event Category: None
Event ID: 10034
Date: 8/30/2006
Time: 3:17:58 PM
User: N/A
Computer: XXXXXXX
Description:
Uncaught exception terminated service MyCompany.MyApp.Messaging.BizTalk.orcContraxMessaging(e237b0e3-03ee-fc5f-2329-c8bf6a14c367), instance 99654c57-2c08-493f-a2f2-2725c84698f1There is an error in the XML document.
Exception type: InvalidOperationException
Source: System.Xml
Target Site: System.Object Deserialize(System.Xml.XmlReader, System.String, System.Xml.Serialization.XmlDeserializationEvents)
Help Link:
Additional error information:<MESSAGEID xmlns=’http://MyCompany.MyApp.Messaging.BizTalk’> was not expected.
Exception type: InvalidOperationException
Source: ranywu4r
Target Site: System.Object Read2_string()
Help Link:
Additional error information:
[/code:1:de243100e0]Looking in HAT I found the message 99654c57-2c08-493f-a2f2-2725c84698f1 as:
[code:1:de243100e0]
{817C3D69-744D-4F28-B3EA-D24106632501} {99654C57-2C08-493F-A2F2-2725C84698F1} MyCompany.MyApp.Messaging.BizTalk.orcContraxMessaging http://MyCompany.MyApp.Messaging.BizTalk#ContraxMSgs Receive prtContraxMessages 1/30/2006 3:17:53 PM 1 588 BizTalk Utilities Adapter for Databases Transport database://Oracle Data Provider for .NET/ContraxMsgs/ContraxMsg
[/code:1:de243100e0]
A little deeper into HAT, I get:
[code:1:de243100e0]System.InvalidOperationException: There is an error in the XML document. —> System.InvalidOperationException: <MESSAGEID xmlns=’http://MyCompany.MyApp.Messaging.BizTalk’> was not expected. at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderString.Read2_string() — End of inner exception stack trace — at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events) at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, XmlDeserializationEvents events) at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader) at Microsoft.XLANGs.Core.Part.XPathLoad(Part sourcePart, String xpath, Type dstType) at MyCompany.MyApp.BizTalk.orcContraxMessaging.segment1(StopConditions stopOn) at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s, StopConditions stopCond, Exception& exp)
System.InvalidOperationException
[/code:1:de243100e0]I don’t know if any of this helps. Any ideas what could cause the xpath to error?
Thanks, Bill N
You need to do the opposite process to retrieve the message from SQL.
Query the database using the SQLAdapter – the xml message is returned in a single field.
xmlDoc.LoadXml(SQLQuery.XmlMessageField);
newMessage = xmlDoc;where xmlDoc is a XmlDocument variable and SQLQuery.XmlMessageField is the distinguished field in the SQL message containing the xml message.
To view the subscriptions:
[url]http://www.winterdom.com/weblog/PermaLink,guid,9141d901-b0e6-4fd7-bb17-d9f086ae26e3.aspx[/url]You can then check the message context values from the failing message to find the mismatch
Help!
I’m fairly new to BizTalk and am attempting to put together my first fully fledged orchestration, but have run into a problem I can’t resolve.
I have one orchestration calling another, using one input parameter message and one output parameter message. The called orchestration uses some decide shapes to determine what should go in the output parameter message, then creates it. All fairly simple stuff.
When trying to compile my sample I get three strange errors:
[code:1:711d2d28d2]’System.Xml.XmlDocument’ does not contain a definition for ‘Source’
‘System.Xml.XmlDocument’ does not contain a definition for ‘Source’
‘System.Xml.XmlDocument’ does not contain a definition for ‘EndDate'[/code:1:711d2d28d2]These are the distinguished properties on my input argument that I’m testing in the expressions.
Looking at the generated .cs code I see something like this:
[code:1:711d2d28d2]__condition__ = __ctx1__.__Message_CollateralLine.part.TypedValue.Source.StartsWith(\"REPO\");[/code:1:711d2d28d2]
So it looks like the ‘TypedValue’ of my message argument is XmlDocument, when it should be the type of the schema. The arguments are set up as being the correct type.
I’ve been banging my head against this for ages to no avail, could anyone give me any pointers on where to look, what to check, or how to debug this problem?
Any help will be much appreciated!
Ok.. I created a promoted field. I have code to update it as follows…
[code:1:facfe57dbe]strFileName = WorkInProgressFlatFile(FILE.ReceivedFileName);
WorkInProgressFileImportSqlRequest.FileImport.File = strFileName;[/code:1:facfe57dbe]If the file contains only one record all works fine. When there is more than one record in the file (ie message) I get the following error.
[code:1:facfe57dbe]The result set for the XPath expression ‘/*[local-name()=’RecordInsertRequest’ and namespace-uri()=’http://XYZ.BizTalk.Schemas’]/*[local-name()=’FileImport’ and namespace-uri()=’http://XYZ.BizTalk.Schemas’]/@*[local-name()=’File’ and namespace-uri()=”]’ contains more than a single node. [/code:1:facfe57dbe]
How do I get it to update all promoted fields? Or just the one its on? I want to set the promoted field to the file name it came in on so I can store it in the database.
Thanks.
Guys,
I am going insane!
Here is the problem:
1 – I read a binary file from an FTP directory using the FTP adapter, then
2 – I use a custom pipeline with a custom IDisassembler component (Disassemble, GetNext methods overriden)
to convert the binary message (batch of binary msgs) into several Xml BizTalk messages (IBaseMessage), during this stage
I promote the properties required by the messeging engine to recognize the messages
NOTE: I am able to see the messages are being passed successfully to the orchestration
3 – I use a map to convert the passed message from the pipeline into the orchestration
to the schema of an SP request (Generated by BizTalk to use the SQL Adapter)
4 – I send the result of the map, that is SQLMsg.procedureRequest to the send adapter (SQL) in order
to invoke an SP on the local SQL server 2005 instance
5 – I get the following error:There was a failure executing the send pipeline:
\”Microsoft.BizTalk.DefaultPipelines.XMLTransmit, Microsoft.BizTalk.DefaultPipelines,
Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\” Source:
\”XML assembler\” Send Port: \”SendPort2\” URI: \”SQL://ES-SYS371/BatelcoPOC/\” Reason:
Root element is missing.NO WAY, the map is supposed to construct the message, right?
This is really weirdANy Help plz
-
AuthorPosts