Forum Replies Created
-
Posts
-
The Xml is being generated by SQLXML. The only place the schemas are used are if you are doing debatching in the pipeline i.e. the schema has been defined as an Envelope and you are using the XmlDisassembler or you are using the XML Validator component in your pipeline.
What pipeline are you using, if it is a custom pipeline what are the components.
Have you set the schema Envelope property to Yes, if so you need to change this to No.
Otherwise the problem is in the stored procedure/SQLXML code.
I would recommend web services, more state of the art and probably easier to implement than HTTP.
1. Use the Biztalk Web Service Publishing wizard to publish your orchestration as a web service. You will need to set the Type Modifier on the orchestration Receive Port to Public.
This will create and build a VS Web Service project. Open IIS Admin and add an Application Pool for this virtual directory. Set the App Pool idenity to your BiztalkIsolated account.2. I assume you are using VS.NET to build your app. Open up your MyApp project and Add a web reference. You need to specify the URL of the web service e.g. http://biztalkserver/Service/Service.asmx. VS will create the class files you require – a class for the service and classes that make up the message. Make an instance of the message class, populate the fields, create an instance of the service class and call the required method passing your message. You don’t have to touch any Xml in the whole process. All the serialization code is created for you.
This is fairly high level. You could try one of the Web Service turtorials that will step you through publishing a web service from Biztalk.
While there is nothing wrong with the HTTP interface, in fact it is slightly easier to set up on Biztalk, it requires a lot more code within your application, including handcrafting the Xml either by using XmlDocument or creating your own classes and using XmlSerialization.
Repling to previous
[quote:1a95afb647]Reply to Neal Walters:
The purpose of loop is to invoke the web service every 1 minute.Once the web service is invoked,it will execute a query in an oracle data source and create a .xml file in a local folder. [/quote:1a95afb647]If you just want to extract data every x minutes, there probably is a much easier way.
If you were using a Microsoft SQL adapter, you could just set up a receive port to poll ever x minutes, then use a send port to receive the ouput. No orchestration would be required. But obviously, that will not help with Oracle. Does 2006 include an Oracle adapter? Are you running 2004 or 2006?
Neal Walters
http://Biztalk-Training.comUse HAT as follows:
First, check \”Queries\” then \”Most recent 100 service instances\”.
Do you see your error there or in the event log or both?Second, in HAT, click \”Operations\” then \”Service Instances\”,
change \”Class\” to \”All\”, then \”Run Query\”.
Do you have \”Routing failure reports\” in the Service Class column.Probably, your root element and/or namespace isn’t matching anything in your BiztalkMgmtDB database. Have you deployed your assemblies? Are you running on your own machine or a server (if a server, did you deploy it there correctly?, Are the assemblies in the GAC?).
Sometimes it is just a misspelled word, such as letter that is upper or lower case mistyped. Also, check your namespace and \”type\” in you schema? What if you right-click generate an XML instance from inside visual studio using your schema? How does that message compare to your message (do a WinDiff type utility). Try dropping the auto-generated message and see if you get the same error.
You can also use some queries in my blog:
http://nealwalters.blogspot.com/2005_01_01_nealwalters_archive.html
(Jan 6, 2005).Neal Walters
http://Biztalk-Training.comJust like you created a Receive Port and added a flat-file Receive Location, you can add a second Receive Location which would have a transport-protocol of HTTP.
The Biztalk documentation gives a nice [b:7acc4ae94e]long [/b:7acc4ae94e]checklist of how to properly setup the HTTP receive location (one set for IIS5 and another set for IIS6). You have to set up IIS and even COM+ and application pools to get it to work (you will need Admin rights). It works great, but at least for me, it rarely works properly the first time, usually some security settings somewhere are wrong. So while getting a flat file receive may take 10 minutes, you’d better plan for one to four hours to get the http receive working the first time you try it.
My suggestion is that you create a script to test your http post and be sure and check the http status code.
Shameless Plug: I have a video that walks through the entire process on the Biztalk CD/ROMs that I sell at the website below.
Neal Walters
http://Biztalk-Training.com[quote:3272a1fec5=\”Mallikarjun \”]Hi,
I am new to Biztalk Server. I want to know about Biztalk server. Can anybody suggest me which site is good for beginners?.
Thanks,
Mallikarjun[/quote:3272a1fec5]Hi,
the following was helpful for me:
http://blogs.msdn.com/luke/articles/380519.aspx
(The QuickStart Guide to Learning BizTalk Server 2004). It’s kinda small course on learning BTS 2004, with references to basic papers and small examples to build your first BTS applications.
Cheers,
Slash
mysteriesly it is solved i don’t know how but it suddenly did.
but new problem:
[quote:ca96c0ad89]<Root xmlns=\”http://Webshop.Receive_FlatFile_Body\”>
<Body xmlns=\”\”>
<Order_ID>gsgs</Order_ID>
<Productnaam>sdgfsdgf</Productnaam>
<Aantal>456..dfsfds,fzerj,789..raez,ezrytu,123</Aantal>
</Body>
</Root>
[/quote:ca96c0ad89]
that is my xml output that i get in my queue.instead of putting the rest in <Aantal> he should create a new XML document with the same root and everything, but other values.
hmmm…
Regards ThomasI don’t know what else to suggest, I’ve done it and I know it works.
Again, I would recommend SQL profiler just to verify.Neal Walters
http://Biztalk-Training.comThe send port is enlisted and started.
The message disappears from my \”in\” folder but I am not sure it get past the receive shape as I put a delay shape in the diagram (after the receive) and this is not logged in the message flow.
[/url]
yeah hi,
thx for your e-mail, i corrected them but still no working…
now i have an error in my event:
[quote:cd8a574d2f]There was a failure executing the receive pipeline: \”Webshop.ReceiveFlatFilePipeline, Webshop, Version=1.0.0.0, Culture=neutral, PublicKeyToken=bac8947f50b16b59\” Source: \”Flat file disassembler\” Receive Port: \”Webshop_1.0.0.0_Webshop.MainProcess_Receive_FlatFile_Ordersysteem_bac8947f50b16b59\” URI: \”d:\\FlatFile\\OrderSysteem_Output.txt\” Reason: Unexpected data found while looking for:
‘\\r\\n’
The current definition being parsed is Body. The stream offset where the error occured is 55. The line number where the error occured is 3. The column where the error occured is 7.
[/quote:cd8a574d2f]I have no idea what it could be…
Thx for looking.
ThomasHi,
I am new to biztalk and trying to work my way through the biztalk server unleashed book.
I am getting a problem with a very simple orchestration which takes in an XML file from a receive port with a given message type, transforms it to another XML format and writes it out to another send port. All using the FILE adaptor.
The error I am getting is \”Could not find a matching subscription for the message\” I am using the Microsoft.BizTalk.DefaultPipelines.XMLReceive pipleline so it should be able to work out the message type from the XML schema.
Any ideas what I am doing wrong?
Thanks,
Richard
