Semaphore Media and Development

There will be a time when BizTalk databases need to be migrated to a new SQL server i.e. hardware upgrade or configuring a new cluster. Before restoring the SSODB database, the original master secret need to be restored. In a SQL cluster environment, make sure to check off “Use Network Name for computer name” option [...]

When working with BAM, if you try to run the BAM_AN_ SSIS package in SQL Server 2008 in order to load the activity data to the cube and get “the binary code for the script is not found” error, then it is most likely due to missing SQL Server component. Make sure to install the [...]

At some point all BizTalk developer will run into this pesky issue. You try to create a new BizTalk project and you get an “… project creation failed” error in Visual Studio. This is because, perhaps after a VS update or other installation, the “PossibleProjectExtensions” attribute in Windows registry get replaced by the default value. [...]

The interface need to first check to see if a folder already exists on FTP server. If not it needs to create the folder first before the FTP adapter sends the message. After spending a day trying all sorts of methods, I finalized on the following approach: 1. create a helper class that establish a [...]

When selecting a recordset for update or delete from a DB2 table using the DB2 adapter, you may run into the following error when attempting to execute the update/delete statement: ” <DB2 table> ?<DB2 schema> ?3 in *N not valid for operation.” This is because the table is not journaled and that DB2 adapter expects [...]

My client has a new requirement that calls for saving the inbound AS2-based message in it’s original file name, and that the file must be saved to a specified file folder if the inbound file name’s first 14 characters matches a string pattern. Reading this post http://blogs.msdn.com/biztalkb2b/archive/2009/08/05/as2-filename-preservation.aspx it implies that the AS2Receive pipeline component should [...]

I ran into a challenge having to map a flattened file data, from SAP’s RFC call, to a hierarchically structured canonical schema. Source: <YITAB> <RecType /> <CDATA /> </YITAB> Canonical: <Header> <Detail> <DetailSpecialInstruction /> </Detail> <HeaderSpecialInstruction /> </Header> rules: 1. if RecType = 001 then header record; if RecType = 002 then Detail Record 2. [...]

When calling a RFC function via a two-way WCF send port in BizTalk, you may notice that there are not result returned.  In this case, take a look at the generated RFC schema and verify if there is <ITAB> node in the schema.  If it exists, then you need to pass in an empty <ITAB> [...]

There are a plethora of blogs and help files on the net on the subject of WCF adapter and ESB.  However I couldn’t find any info on how to setup a BRE policy called by an ESB itinerary to configure a dynamic WCF-custom send port using SAPBinding.  After hours of trial and hair-jerking moments, I [...]

Although this is not directly related to BizTalk, but I do run across this issue many times since I mainly work with virtual images that host various configuration types of BizTalk environment. I was able to convert an existing Virtual PC image to VMWare image via VMWare’s Converter. However, upon launching the converted VMWare image, [...]