by community-syndication | Jun 18, 2008 | BizTalk Community Blogs via Syndication
Just a quick post to those of you planning to use the BizTalk Accelerator for RosettaNet 3.5. There are a few little “issues” that you need to know about before you get started.
Accounts, Hosts & Host Instances
BTARN 3.5 requires the use of Hosts that have the Authentication Trusted option enabled. This has to be configured BEFORE you create any Host Instances. I recommend creating a new Service Account, a new In-Process Host, a new Isolated Host and then a new Host Instance for each of these as shown in the table below. You will also need to create new HTTP and SQL Send Handlers and Receive Handlers as well.
Note: The In-Process Host Instance account and Isolated Host Instance account must be the same for BTARN to work properly!
| Service Account: |
Domain\AccountName |
| In-Process Host: |
RosettaNetApplication |
| In-Process Host Instance: |
RosettaNetApplication |
| Isolated Host: |
RosettaNetIsolatedHost |
| Isolated Host Instance: |
RosettaNetIsolatedHost |
| SQL Send Handler: |
RosettaNetApplication |
| SQL Receive Handler: |
RosettaNetApplication |
| HTTP Receive Handler: |
RosettaNetIsolatedHost |
| HTTP Send Handler: |
RosettaNetApplication |
Installation & Configuration
Don’t use “localhost” for your BizTalk Server or Web Server name when running the Configuration Wizard. Use the NetBIOS name of your BizTalk Server machine and the NetBIOS name of your Web Server machine instead. The Configuration Wizard will fail with a strange error if you use default “localhost”.
Why? I have no earthly idea but I will be submitting this to the BizTalk team as a bug!
One final note
All the BTARN bits are deployed to the BizTalk Application 1 by default. I’m still trying to find a way to isolate the RosettaNet bits (schemas, maps, pipelines, ports and orchestrations) in their own BizTalk Apllication much like the new EDI/AS2 bits are. I’ll post if I find an easy way to accomplish this.
Happy Integrations!
Currently listening to: Dave Koz – Castle of Dreams
by community-syndication | Jun 16, 2008 | BizTalk Community Blogs via Syndication
I installed an SP2 upgrade over the weekend on BizTalk 2004. Here were the take aways.
1. Always have the BizTalk user account as God mode for the SQL server that hosts the BizTalk Databases.
2. Shrink the MsgBox and Tracking Databases before installing the SP2 upgrade. (http://msdn2.microsoft.com/en-us/library/bb203857.aspx for the MsgBoxDb and KB894253 for the Tracking DB)
3. If the database file sizes don’t decrease use the following SQL methods:
dbcc shrinkdatabase(<DatabaseName>)
dbcc shrinkfile (<DatabaseName>, <size in MB>)
by community-syndication | Jun 16, 2008 | BizTalk Community Blogs via Syndication
For those that missed it and those hungry to see it again – check out this video from TechEd IT Pro last week in Orlando. Greg Leake demo’d his .NET StockTrader 2.0 during Bob Muglia’s keynote with industry partner, WS02, highlighting our commitment to of interoperability.
.NET StockTrader 2.0 demo at TechEd IT Pro 2008
by community-syndication | Jun 16, 2008 | BizTalk Community Blogs via Syndication
The Issue Earlier this week Bennie Wentzel , a developer from a customer I was engaged with last year, posed me a question which went something like this: If I have a synchronous web service receive port, how can I return the result of a map on this receive…(read more)
by community-syndication | Jun 15, 2008 | BizTalk Community Blogs via Syndication
This is a quick post for my future reference and I hope it helps someone in the future…
If you deploy a view to BAM then try to add a user or windows group to the view using the “bm.exe add-account” command and it fails telling you that “The SQL role for the specified view is […]
by community-syndication | Jun 15, 2008 | BizTalk Community Blogs via Syndication
After much promise, and many requests, the web site for the South African BizTalk User Group has now been launched. Please pay us a visit at http://www.biztalkug.co.za/ . Thanks to Ryan Crawcour for taking the initiative on this, and thanks to all those…(read more)
by community-syndication | Jun 14, 2008 | BizTalk Community Blogs via Syndication
I’ve just uploaded a new extensions to the SmartTools for SharePoint project on CodePlex. This extension adds Copy and Paste functionality to SharePoint Document Libraries. You can download the extension from the Releases section. For more info and screenshots see the CopyPaste Wiki page on CodePlex.
Technorati Tags: sharepoint,wss,moss,copypaste,smarttools,copy,paste
by community-syndication | Jun 13, 2008 | BizTalk Community Blogs via Syndication
I just came across this excellent material on Technet – the Biztalk Server Performance Optimization Guide. Whats even cooler about this paper is that it goes into some pretty good depth on how to use BizUnit in conjunction with LoadGen to do performance testing. This is really good stuff. I was just thinking how good […]
by community-syndication | Jun 13, 2008 | BizTalk Community Blogs via Syndication
Day 3 in my RosettaNet implementation nightmare and I still can’t see the end of the road!
As you may or may not know, the American Petroleum Institute (API) has it’s own set of XML schemas and transport standards know as the Petroleum Industry Data Exchange or PIDX for short. This is the actual “standard” that my current RosettaNet project is really all about. The interesting about these schemas is the fact that they use their own unique namespace and prefix as shown below:
xmlns:pidx=http://www.api.org/pidXML/1.0
Since the BizTalk Mapper tool always generates XML document with the “ns0″ prefix and there is no property you can set to change this, you’ll need to use a little “XSLT slight-of-hand” to get this to work.
Step 1: Create your BizTalk Map as you normally would using the mapper tool.
Step 2: Validate your map and open the xslt generated by BizTalk Server 2006 in your favorite text editor. This file can usually be found in the “\temp\_mapdata” folder.
Step 3: Replace all instances of the namespace prefix “ns0″ with the prefix you require (which in this case is “pidx”) as shown below.
Step 4: Save the result as an .xslt file and include it (or add it) into your BizTalk project.
Step 5: Create a new map using the same source and destination schemas you used in Step 1 but use the external xslt you generated by setting the “Custom XSLT Path” property on your new map.
The results are shown in the figure below. Viola! The “ns0″ namespace prefix has been replaced by the desired “pidx” prefix.
Click below for more information about using external xslt in your maps.
Custom XSLT in BizTalk Maps
Take Away: There is always more than one way to skin a cat! In BTS2006 it may not be obvious how to do something a little unusual.
by community-syndication | Jun 13, 2008 | BizTalk Community Blogs via Syndication
This question and response came up on a forum. I’ve never seen this referenced before so I thought it was worth blogging.
Problem:
BizTalk is receiving a flat file (can contain up to a million records) and doing a disassemble in a pipeline using a flat file schema. The individual messages are processed by a sequential convoy (Singleton) based on a correlation. The orchestration receives the message in a loop that follows the correlation set from the receive port where receive location split the flat file into smaller messages.
To specify a proper exit criteria to exit the loop and stop the convoy I need to know the number of messages in the flat file. But since I am using the default flat file disassembler, I have no clue how many messages are in the file.
Solution:
There’s a property promoted in the last of the disassembled messages in an interchange: BTS.LastInterchangeMessage = true. This tells you the last message in the interchange and in conjunction with BTS.InterchangeSequenceNumber you can tell the total number of messages in the interchange (in case you get them out of order).
