Situation In some scenarii, you must poll a datatable and you use WCF-SQL. This polling must update a column for rows which are red. Due to the pollingfrequency you might encounter deadlock. Consequence there is no more activity in your BizTalk Server, and you can loose some newly data which are never inserted So you […]
Blog Post by: Jeremy Ronk
This was a guest post by Michael Stephenson. Michael Stephenson is a UK based integration specialist who has worked with many consultancies and customers delivering integration solutions based on Microsoft technologies such as BizTalk and Windows Azure.Michael is heavily involved in community activities such as the UK Connected Systems User Group and speaking at events […]
The post What are the different types of alarms (alerts) you should configure in BizTalk360? appeared first on BizTalk360 Blog.
Blog Post by: Saravana Kumar
I have had a frustrating weekend trying to install the Talk Adapter Service Runtime environment on my development environment and am going to write about it here. I am following "Installing the Windows Azure BizTalk Services SDK – June 2013 Preview" and keep on getting the error below when I tried to install the BizTalk […]
Blog Post by: mbrimble
I am currently involved in a project where I need to integrate Dynamics AX with a 3rd party payroll system. Dynamics AX 2012 provides a rich integration framework called Application Integration Framework or (AIF). One of the core strengths of this framework is the ability to generate a typed schema through a configuration wizard. Combine that with a AX’s ability to create inbound and outbound ports and you now have the ability to generate export(and import if interested) files rather quickly.
When I mentioned in the previous paragraph “typed messages” I meant that AX will generate XSD schemas that we can include in our BizTalk projects. This is a breath of fresh air compared to some other ERP systems where you get handed a CSV flat file that you have to build a flat file schema for.
In my scenario I was receiving a list of Work Orders so a colleague working on the AX side was able to provide me with the Work Order Schema and an imported schema that includes AX types. At this point I add the schemas into my solution, build my map and wire everything up. Go to run an initial test and was presented with the following error:
Details:The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted.
This is a pretty standard error message that basically comes down to BizTalk received a message that it was not expecting. The reason why BizTalk was not expecting it was because AX wraps outbound messages with a SOAP Envelope as you can see in the image below.
SOAP Envelopes are certainly nothing new but I didn’t expect AX to use them when writing a file to the file system. When receiving Web/WCF Services BizTalk automatically takes care of extracting the message body from the incoming SOAP message for us. With the FILE Adapter that facility just does not exist.
You will notice in screenshot below that there is a namespace that is specific to AX. This got me thinking that AX probably has an XSD for this message type as well.
After digging around a bit I did find the location of the AX schemas to be in the Program files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\Application\Share\Include folder. The schema that I was looking for was called Message.xsd
Just adding this the BizTalk project was not enough. I needed to make a few small tweaks to the schema:
/*[local-name()=’Envelope’ and namespace-uri()=’http://schemas.microsoft.com/dynamics/2011/01/documents/Message’]/*[local-name()=’Body’ and namespace-uri()=’http://schemas.microsoft.com/dynamics/2011/01/documents/Message’]/*[local-name()=’MessageParts’ and namespace-uri()=’http://schemas.microsoft.com/dynamics/2011/01/documents/Message’]
We can now deploy our application. When it comes to our Receive Location that will be picking up this message, we want to ensure that we are using the XMLReceive Pipeline. Within this Pipeline the XML Disassembler stage will take care of the SOAP envelope so that when the message body is presented to the MessageBox that any subscribers will receive the expected message body.
Conclusion
When I first discovered that I was receiving a SOAP wrapped message my instincts said maybe AX could just use a WCF port instead of a FILE port. This just wasn’t the case, there are only two options when it comes to configuring an outbound port: FILE and MSMQ. Using MSMQ would not of helped me in this case as the same issue would have existed.
AX certainly does provide the ability to call a WCF service but it is a more custom based approach. I would have had to expose this schema as a WCF service but then my AX colleagues would have had to write code against the proxy to populate all of the different data elements. This would have defeated the purpose of using the AIF framework in order to expedite the ability to delver a solution under very tight timelines. Luckily with a little tinkering we were able to come up with a reasonable solution without writing custom code.
I have to think that AX is wrapping these messages in a SOAP Envelope for a reason. Perhaps a WCF outbound port is coming in an upcoming release?
A few days ago I blogged that I had put together an unofficial update to the BizTalk PowerShell Provider. I joined up with the project on CodePlex and they put me to work quick! Tonight I checked in some updates and now we have a new release, 1.3.0.0, which works on BizTalk 2013. I will […]
Blog Post by: clineer
In the past I developer a demo on “How to Call Orchestration from another project or from another BizTalk Application” that you can read here and download the source code from Code Gallery here. This demo was compose by one Visual Studio Solution with two different projects: Project1 Orch1 Schema1 Project2 Orch2 However there were […]
Blog Post by: Sandro Pereira
This post is the fourth in a weekly series intended to briefly spotlight those things that you need to know about new features in BizTalk Server 2013. In the Support for new Adapters section of the new features list for BizTalk Server 2013, you will find a very brief note without much explanation about the […]
Blog Post by: Nick Hauenstein
Reblogged from shadabanwer: While working on the BTS2013 project, I started writing unit test for Schemas and Maps. I found that unit test for maps do not work anymore with the BTS2013 upgrade. I keep on getting “Transform failure” error messages. I with the help of one of my colleague figure out actually Microsoft had […]
Blog Post by: Johann
A customer asked me recently if the BizTalk business rules engine was a good place to search for repeating elements containing duplicate values in an XML message that is received on a one way BizTalk hosted WCF service and to throw an exception back to a service consumer if a duplicate is found. My initial […]
Blog Post by: Johann
Continuing my foray into the world of Azure I started playing with using my Azure VM as an ADFS server with the goal of using it as an identity provider in Windows Azure ACS for the appropriate candidate azure services. I followed the instructions on this fantastic step by step walkthrough by Haishi Bai (he […]
Blog Post by: Johann