Mike Taulty's Blog
Bits and Bytes from Microsoft UK
BizTalk & Correlation again

Blogs

Mike Taulty's Blog

Elsewhere

Someone asked me about Correlation sets in BizTalk 2004 again today and I went back to my previous posting to notice that my import of my previous postings has left them in a bit of a mess - formatting is horrible on anything before January. I'll have to fix this at some point but in the meantime I thought I'd put up a (rough) sample of using correlation.

The sample's here  - it was zipped up with WinZip 9.0 so take care.

What's in it? Essentially, an orchestration which receives an "expense" document, submits it to a web service (which logs it into SQL) and then waits for a response which it correlates back on the employee's first and last names.

To make it run. Deploy the web service. Hack the code in there to setup a connection to your DB and create a table in that DB called expenses which needs to have at least one column called expensereport of type vchar(2048) or similar. Any other columns need to be nullable or have defaults.

Having done that, deploy the BizTalk assembly and bind the orchestration. It's up to you what transports you use but files make it easier for pretty much everything. Note - you'll probably need to update the web references in the orchestration depending on how you deploy the web service.


Posted Fri, Jan 23 2004 10:04 PM by mtaulty

Comments

mtaulty wrote re: BizTalk & Correlation again
on Tue, Mar 2 2004 3:37 AM
Mike I tried your example but I get the following error when i run the sample....

F:\TEMP\correlation\CorrelateMe\Correlation.odx(446): message data property 'CorrelateMe.EmployeeFirstName' in correlation 'CorrelateMe.Correlation.SubmitterCorrelationSet' does not exist in message 'WebServiceCall'
mtaulty wrote re: BizTalk & Correlation again
on Fri, Mar 12 2004 7:11 AM
Hi Patrick,

Sounds to me like the property has not been promoted in the schema for the web service. Find the message schemas for the web service in your project and open up the request and promote that first name property in there as the EmployeeFirstName property. That should work for you.
mtaulty wrote re: BizTalk & Correlation again
on Tue, Mar 23 2004 12:59 PM
I am getting the above exact issue but do not really get what you are saying with "promote that first name property in there as the EmployeeFirstName property".. Can you explain a little more? Thank you
mtaulty wrote re: BizTalk & Correlation again
on Tue, Mar 30 2004 5:51 PM
hi everybody

Do you know about default pass thru transmit pipeline and xml transmit pipeline (both of these are for sending).
That is the difference?
Some example I work on only work on one pipeline, not the other.
Same question for default pass thru receive and xml receive pipeline (both of these are for receiving).
What is the difference? What is the reason to pick one over other in some situation?

I also have problem with MSMQT (serialization problem).
I can not get message MSMQ (regular queue) from remote machine to work with MSMQT from a local biztalk machine.
I can work with them individually, but when they have to send/receive from each other, the serialization format got stuck (I tried every from custom serialization to etc..)

Basically, I don’t want MSMQ and MSMQT any more, I will use SQL adapter with biztalk 2004.
My main question here (this question has been asked before by others on some forum but biztalk 2004 is so now, no answer yet):
I want to save the whole message (XML message from a file receive function).
The XML message should be able to save as a whole string inside some SQL server table.
I came a cross some example but only field by field example.
I need to whole message as a string to work with SQL Adapter for Biztalk.
Any recommendation?
Thanks,
Hung
mtaulty wrote re: BizTalk & Correlation again
on Tue, Mar 30 2004 6:57 PM
One question on the example zip file:
Inside the webserivce in that example, there is a file call ExpenseClaim.cs

Inside this file, the comment said this:
//------------------------------------------------------------------------------
// <autogenerated>
// This code was generated by a tool.
// Runtime Version: 1.1.4322.916
//
// Changes to this file may cause incorrect behavior and will be lost if
// the code is regenerated.
// </autogenerated>
//------------------------------------------------------------------------------
What tools did you use to generate this?
I am from VB.Net world, so the syntax is c# is not familiar to me (even though I have C++ experience).
Is this generated by generating strongly typed dataset?
What tools is it?
Not only i read your example, I want to use the same tool and steps to recreate it. Once I understand everything, then I will be able to build a complex biztalk solution.
mtaulty wrote re: BizTalk & Correlation again
on Tue, Mar 30 2004 7:32 PM
I think I got the xsd.exe as the answer for the previous question.

Now, the Web service solution insize correlation.zip does not include
ExpenseApprovalClient Project

Can you update the zip file so that we have a complete example?
mtaulty wrote re: BizTalk & Correlation again
on Wed, Mar 31 2004 2:31 PM
I've had a few questions about this sample so I thought I'd better get a reply posted :-)

I've answered hung's question in a separate email but I'll make a posting around XML receive and pass through so that's understood.

The answer around XSD.exe was correct - that's how ExpenseClaim.xsd was brought into the ASP.NET environment so I can write a web service around it.

I'll make a new posting around how to set up this sample and hopefully it will then be clear.