Showing posts from February, 2017

BizTalk Server 2016/Visual Studio 2015 - Pipeline Component Wizard Update

Hello BizTalk Techies,
This is an update to the BizTalk Server Pipeline Component Wizard to work for BizTalk Server 2016 in Visual Studio 2015. Original version from the Codeplex supports only till BizTalk Server 2010 in Visual Studio 2010. This is an community effort to improve development efforts.
For more details of description and download link please visit below URL,
BizTalk Server 2016/Visual Studio 2015 - Pipeline Component Wizard Update

The hard Purge interval cannot be less than the soft purge interval

On one of the BizTalk env(non prod) there arouse a space crunch scenario which was call for purging the data from BizTalk tracking database(DTA DB).(dtasp_BackupAndPurgeTrackingDatabase is not configured on this env)

So do that, we decided to purge/delete only those instance which are completed and are older than 30 days and incomplete instances of only past day.
Note: No archiving was needed so instead of dtasp_BackupAndPurgeTrackingDatabase we used dtasp_PurgeTrackingDatabase
Thus the parameters set were: @nHours tinyint(Any completed instance) :0 @nDays tinyint(Any completed instance) : 30 @nHardDays tinyint(Any including incomplete instance): 1 @dtLastBackup(Set this to GetUTCDate() to purge data): CurrentDateTime
For more details on parameters :

And when started the job, it failed at second step and to check the reason went through history and found the error as below

The error says that 3rd parameter should be greater than 2nd paramet…

How to check what BizTalk Server 2016 Cumulative Updates are installed in your Servers with PowerShell

Information about all installed BizTalk Cumulative Updates on the Server (see here).  Now it is time to update this script to BizTalk Server 2016.
Checking what CU are installed it is not a difficult task to do, but without a doubt it is one of the most annoying task to do as an administrator because, and once again: You can do it manually by checking "Control Panel\Programs\Programs and Features" and then view the "Installed Updates", try find them in the list can be sometimes very confuse because they are not organized in a category BizTalk;Or rely in tools like BizTalk MsgBoxViewer, which sometimes are not up to date, to check and provide that information;
Probably there are other ways, nevertheless, this simple task should be simple, extremely easy and fast to do, what you really want to know is what are the BizTalk Cumulative Updates installed like: 1 2

7 Lessons learnt from the first production Azure Logic Apps project

Article posted by Stephen Thomas on BizTalk 360 Blog.

For starters, I need to start out saying I am very new to working with Windows Azure Logic Apps; so a lot of the issues we faced were just from lack of experience. That said, since it is a relatively new technology, most people are going to be new to it as well.
In general, the experience was straight forward and we were able to build an Enterprise class EDI solution in a short amount of time at a huge cost saving as compared to a new BizTalk Server installation. For clients who already have BizTalk up and running, the cost savings would not be as significant.
Overall, the Azure Logic Apps platform is fantastic. It gives great details into current and the past running instances with complete auditing on a per-shape basis. We were able to track down issues very quickly using all the tools provided. The monitoring features are extensive. Dev-Ops is challengingThe big trade off at this point comes in terms of Dev-Ops. While the Dev-Ops s…