Forum Replies Created
-
Posts
-
Stephen, this is awesome, thanks alot. Funny thing is, i have exactly what you have in your article except I have a sequential convoy. I also have a Merge schema setup like that, i just wasn’t sure how to create a map to transform merge schema into the end result, like you have there with a loop node, now i know, thanks alot.
Just one last question, you have a correlation set setup with \”ID\” field in each schema, this is exactly what I have except i set the \”Fixed\” property of the field to \”1\”. My question is, who sets the ID and how is it able to correlate. In your project it seems like it’s untouched and I guess it is left upto biztalk engine to setup that field? I guess the engine knows it’s a paralell convoy? How is it done? because as you know in my case, i can’t link the messages by any field, i think they have to be linked by orchestration instance?….let me know please.
Thanks alot
Sure you can. Check out this sample and see if it helps: http://www.biztalkgurus.com/Samples/Concurrent-Parallel-Convoy-Orchestration.html
You need to set this up inside the Orchestration and use the transform shape to create the map for you.
Thanks Stephen,
when I set the timeout for the request object in ASP.NET application, it worked fine. however it’s not a long running orchestration, it should take around 2 sec.
I am trying to find out the difference between setting it in machine.config file and setting timeout for particular request.
Anyway the current issue has been solved.
Thanks again.
Nope, I do not know any way to print them but you should be able to export them as XML.
Then, you could print the XML or write a little .net component to format it in a better manner for printing.
Best of luck.
1. I don’t know if you can do this. I would go about this using .net code inside an Orchestration to call your Stored Procedure. The adapter is really intended to bring data into BizTalk and send data to SQL.
2. As far as I know, you need the ide to run the wizard. It creates the asp.net projects for you and set them up in iis. You might want to look at this: http://www.masteringbiztalk.com/blogs/jon/PermaLink,guid,3998ad88-372b-4daa-8544-c32cda32c922.aspx
Hope this helps.
Sorry I have not looked at that lab or BAS for that matter.
About the only think I can think of would be a problem with the user account not have access to the page (make sure the app domain is a member of BizTalk Users and Administrator is also in the BizTalk Admin group).
Can you call this with a .net component?
Did you try using a file drop instead?
As I understand it, the Oracle Adapter is using a System DSN rather then the user id and password setting you put inside the adapter configuration.
I do not know if it is possible to have this dynamic – might want to try adding an additional field in the table and pass in the user id as a value (if this is possible).
If the Oracle Adapter doesn’t work for you, you might want to use simple .net call inside an Orchestration. You have more flexibility to pass in user id and passwords.
ESS could be used to store passwords and I think it could be used to do some type of validation but I have not used it enough to know if this would really help you. I don’t think you would have to use it in your scenario.
Hope this helps.
This is now all available inside the BizTalk Server Admin console. Just open the admin tool, click on the BizTalk Group node, and click Refresh. This will give you a view of the health of your biztalk group.
You can then follow the links to your suspended message where you can see the body and context properties. Also, you can do bulk deleted.
This is so much better then HAT in BizTalk 2004
I think you can also change the timeout inside your calling .net app. It should be a property on httprequest if I remember correctly.
But, I guess the question is why is the call not returning? Is it a long running process that will return something? i.e. how long does it take for the process to run?
I would probably do this in sequence rather then parallel. You talk about receiving the FTP file first, then calling SQL. That sounds sequential to me.
Then, use a .net component or possible the SQL Adapter to return your next set of data.
You can use a map to map 2 messages into 1. This can only be done inside the Orchestration and if you have the two input schema and output BizTalk will generate the start of the map for you when you define the input/output using the transform shape.
So, I would try something like:
Receive FTP
Send SQL – Receive SQL response (think you can do this)
Map Two Received Message into One using Transform Shape
Send to SQLHope this helps you out.
Thanks again for your reply. I still doesn’t work however. I hope you can spend some more minutes helping me out.
The solution you mentioned in your reply resembles my scenario 1, which is working fine.
Scenario 2 however, which is still not working, is about request response.
So a client sends a message to the webservice and waits for a response from that same webservice. In order to do this you have both configure a incoming (request) and outgoing (response) message schema in the webservice publishing wizard. The wizard than creates a two way receive port which is also used to send back the result to the client.The wizard works fine and nicely creates a two way receive port.
When I test this I still encounter the problem.This is what I did exactly for scenario 2:
– Create a simple xsd.
– Deploy an assembly with this xsd to biztalk.
– Use webservice wizard to publish the schema as a webservice.
In the wizard set the xsd for both the request and response.
Let the wizard create the receive location.
– Call the webservice using a simple C# client app.Thanks a lot,
R vS
This is probably because you do not have the right service packs installed for SQL.
Make sure you have 3a. I do not think it works with just 3 and there is no way that I know of to tell if you have 3 or 3a installed.
You also need 3a installed for Analysis Services.
