Building a Composite Oracle Schema

 Uncategorized  Comments Off on Building a Composite Oracle Schema
Jan 282015

I am going to write a ‘visual’ example of the article documented here: Performing Composite Operations on Oracle Database by Using BizTalk Server

I have a schema already created from Oracle that defines all of the stored procedures we are planning on calling from within BizTalk

The issue is that I need to send multiple of the same calls to the stored procedure and multiple stored procedure calls.

Now we are going to create the composite Schema Definition.

Let’s import the original schema, and for whatever reason, I needed to add the ns0 to the prefix.


So let’s change the root node name to Request (like it asks us to in the instruction)

And start adding the things we want to the Request node (making them repeatable), however, unlike the instructions, I am not naming it, because once I choose the correct node, it is going to rename it anyway:

Make it min 0 and max * and we are done with the first one.

And do it for the rest of the stored proc calls.

Let’s create the Response and do the same thing, except choosing all of the Response nodes. Here is the final schema


Now you can start mapping…

Disable Auto Scrolling

 Uncategorized  Comments Off on Disable Auto Scrolling
Jan 232015

One of the biggest beef’s I have with the BizTalk mapper (other than functiods in general) is the ‘feature’ where, for sale when you click on a source node, it will ‘highlight all of the links and center the destination to show you the links.

For small maps, this is ‘hardly’ noticeable.

However, for maps that are large, and the same input node is used in multiple destination nodes, it becomes hair pulling-ly frustrating.

To disable this, in Visual Studio go to Tools –> Options –> BizTalk Mapper and uncheck the two default checks.

You then need to restart Visual Studio (perhaps just close the currently opened Maps) for this to finally not scroll.


Mapper Hack: ‘ns0 is an undeclared prefix’

 Uncategorized  Comments Off on Mapper Hack: ‘ns0 is an undeclared prefix’
Jan 232015

I am sure I am the last to figure this out, so pardon me for my late entry to the game of XSL goodness.

A few years ago, I discovered the power of XSL, and now I never use any of the out of the box functiods, in fact, I am hard pressed to try to remember the last time I even used inline C# in my maps.

So here is how I have ALWAYS coded inline XSLT:

I need to create an output node


So, what I have always done is created the XSL like this:

<xsl:value-of select="count(/s1:Batch/s0:Form)" />

Which should work. However, when I either Validate the map or compile it, I get the following error:

MakeMessages.btm: error btm1023: Exception Caught: ‘ns2’ is an undeclared prefix. Line 1, position 2

So then I open up the map and go find the ns2 definition up at the top of the generated xsl


Copy the namespace down into the script like this:

<ns2:P_BATCH_ITEM_CNT xmlns:ns2="http://Microsoft.LobServices.OracleDB/2007/03/BIZTALK/Procedure">
<xsl:value-of select="count(/s1:Batch/s0:Form)" />

However, there is an ‘easier’ way to do this:

Use the xsl:element command, this way you don’t have to ‘care’ about declaring the namespace in all of your custom XSL scripts

<xsl:element name="ns2:P_BATCH_ITEM_CNT">
<xsl:value-of select="count(/s1:Batch/s0:Form)" />

Updgrading StackExchange

 Uncategorized  Comments Off on Updgrading StackExchange
Jan 222015

So I just was notified that the StackExchange Redis NuGet package was upgraded, sales so here is my experiences:

There isn’t anything on the site’s home page that says anything about upgrading, decease so it must be easy!

I opened up my solution and in the NuGet console, cost I pointed to my project that uses Redis and put the command to get the latest Strong Name in:


And here are the results


Just as I thought: EASY