Forum Replies Created
-
AuthorPosts
-
Thanks for replaying
I have change the minoccurs and MaxOccurs to Unbound. but even its not working.
And the Stored Procedure Working Fine. It’s returning all the Orders.But In generated XML File It returns only first order.
So what should be the solutions.
Regards
JigneshWell i dont know how you created the binding file and did you modify it after creating it.The only solution i would tell you to try is delete the send port.Create a new binding file through wizard. Edit this file in notepad,rename the password and then try importing it. I may not check this forum regularly,so better mail me.
Regards
NISHIL
http://biztalkblogs.com/nishil/default.aspxApril 25, 2006 at 6:28 AM in reply to: How to extract multiple XML attachments from a POP3 message #14529Thanks
Even if I would have been happier if I was on the right track
I will try to solve it with a custom componentJohan
Well you can control your receive port from your orchestration provided you know to which port is your orchestration binded to.If you carefully see your recieve port properties,we notice start date and stop date.
So what all you need to do is as soon as the first receive shape gets executed just write a code to stop the recieve Port and before the orchestrations terminates just start it.Regards
NISHIL
http://biztalkblogs.com/nishil/default.aspxWhat happens to the Xml file after it is created. Who reads the file.
The main problem with your orchestration is it has to be active forever. It will be initiated by receiving the trigger message and loop continuously. If the orchestration ever has an exception it will fail. You will need additional code to handle this failure and send another trigger message otherwise the process will stop. e.g. if the Oracle server is down the Web Service call will fail and the orchestration will be suspended.
An alternative would be to have an OracleDb receive location that queries the Oracle Db every minute and receives the Xml data and saves the Xml data into a file.
The xml file is just created and put into a local folder.Besides,nothing happened to it.
What happens to the Xml file
Reply to greg.forsythe:
I have tried to do as what you said.But the steps in the loop runs just one time yet.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.Best regards!
April 25, 2006 at 1:05 AM in reply to: How to extract multiple XML attachments from a POP3 message #14530When you receive a POP3 message, you can specify the decode happens in the POP3 adapter or add a MIME/SMIME decoder to your receive pipeline.
Either way you get one message with multiple parts. The pipeline will not split the parts into individual messages. Even calling a pipeline from the orchestration will not split the message parts into individual messages.If you have a fixed number of attachments then you can declared a multipart message with the same number of message parts in your orchestration and access the attachments as parts of the incoming message.
If you have a variable number of message parts, then you will probably need some custom code.
One possibility is a custom disassembler for splitting the message parts. This could be added to the receive pipeline from the POP3 adapter.
The is an example disassembler for handling multipart message on GotDotNet. It does not exactly what you need but it could be modified
[url]http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=0DE372FE-ADB5-41AD-802B-D5FABA71AE6D[/url]Just some things to check:
– Make sure you create an instance of your .net component
– Make sure your rule is getting called
– Make sure you are not using static methods (unless you create an instance of them first)I’m guessing your missing an instance creation. That’s usually my problem.
April 24, 2006 at 11:30 PM in reply to: Suspended Message Routing and Error Reporting in Biztalk2006 #14527The suspended message routing is a feature of the send and receive pipelines only.
You will need to handle exceptions in the orchestration yourself.
Rather than use the Suspend Message shape, create a copy of the message, set the appropriate context properties and send it to a direct port.No clue on this one. Sorry.
Did you build the schema manually or use the SQL adapter to build it?
Check your min occurs/max occurs properties on the \”record\” (group elements). Have you tried using SQL profiler to verify that stored proc is running as you expect, the proper parms are being passed, etc…Neal Walters
http://Biztalk-Training.comWhat is the purpose of the loop? You receive one message, why do you need to call the webservice multiple times?
Neal Walters
http://Biztalk-Training.comMy first question would be why do you want to write to a database from a map. It would have to be a very compelling reason – using the SQL adapter would be the preferred method.
But if you really have to…
Anything you can do in .Net code can be executed in a map.
You can write code in an external assembly, inline C#/VB, Javascript even, to write to a SQL database.
You code can be called using the scripting functoid. -
AuthorPosts