WebSphere Transformation Extender vs BizTalk

I am not sure if the war over ’which product is better’ will ever be over, but the price battle sure has been won:

WebSphere TX

BizTalk

IBM Passport Advantage Express Microsoft BizTalk Server Pricing and Licensing Overview

Microsoft sure has made it easier to understand what you are getting, having worked for Mercator in my past, I sure am stumped as to what a client would need to buy.

(Thanks Barry for pointing this out)

BizTalk 2009 ISV Editions

BizTalk 2009 ISV Editions

As you might know Microsoft have recently revealed two new BizTalk 2009 editions for Independent Software Vendors (ISVs). Here are more details about them from the Microsoft World Wide Partner Conference 2009 two weeks ago (July 13th 2009):
ENTERPRISE RUNTIME EDITION

Only used with of unified ISV solution
Unlimited CPUs, limited to 5 BizTalk applications
Includes all capabilities, […]

BizTalk 2009 – Deploying Orchestration Project Throws EnvDTE FileLoadException (and other issues)

BizTalk 2009 – Deploying Orchestration Project Throws EnvDTE FileLoadException (and other issues)

We have a few BizTalk 2009 projects going on at the moment and are running into some issues. The latest is the that when deploying a project containing an orchestration from Visual Studio 2008 you see an exception similar to:
“xlang/s engine event log entry: FileLoadException exception occurred while the XLANG/s runtime enlisted a service. […]

Next Melbourne BizTalk User Group Meeting – Tuesday 4th August 2009

We will be holding the next Melbourne BizTalk User Group Meeting on Tuesday 4th August 2009 at 5:30pm

The venue and sponsor for the meeting will be Stargate Group at Level 3, 600 Victoria Street, Richmond

The topics will be: ESB 2.0 Toolkit

  • BizTalk Team from Stargate Global Consulting will do a presentation on Installing the ESB 2.0 Toolkit
  • BizTalk Team from Stargate Global Consulting will do a presentation on Introduction to Itineraries
  • BizTalk Team from Stargate Global Consulting will do a presentation on Exception Management Framework

Please note we are starting the meeting at 5:30pm and there will be food and drinks supplied

If you cannot attend the meeting it will also be available via Live Meeting (Join the Meeting), starting at 6:00pm

Please RSVP for [email protected] if you plan on attending the meeting.

Suspended Messages

Here is the stored procedure that needs to placed on the same server (but different database) as the MessageBoxDb. Then you simply have a job that runs this stored procedure (again, it never should need to be turned off)

This will check for new suspended messages every 30 seconds.

CREATE PROCEDURE [dbo].[MonitorBTSMessages] 
AS
BEGIN
    SET NOCOUNT ON;
    while(1=1)
    BEGIN
    WAITFOR DELAY '00:00:30'
        DECLARE @SUSPENDEDMESSAGES INT
        SELECT @SUSPENDEDMESSAGES=COUNT(*)
        FROM [BizTalkMsgBoxDb].[dbo].[InstancesSuspended]
        WHERE DtCreated between DATEADD(s,-30,GETUTCDATE()) and GETUTCDATE()
        IF (@SUSPENDEDMESSAGES>0)
        BEGIN
                declare @thisSubject varchar(100)
                select top 1 @thisSubject='Suspended message on '+  nvcErrorProcessingServer
                FROM [BizTalkMsgBoxDb].[dbo].[InstancesSuspended]
                WHERE DtCreated between DATEADD(s,-30,GETUTCDATE()) and GETUTCDATE()
                and nErrorCategory=0
                Declare @body1 varchar(8000)
                SELECT @body1 = ISNULL(@body1+'Adapter: '+nvcAdapter+' at '+nvcURI+'<br />Description: '+nvcErrorDescription+'<br /><br />','')
                 FROM [BizTalkMsgBoxDb].[dbo].[InstancesSuspended]
                WHERE DtCreated between DATEADD(s,-30,GETUTCDATE()) and GETUTCDATE()
                and nErrorCategory=0
                ORDER BY nvcErrorDescription
                EXEC msdb.dbo.sp_send_dbmail @recipients='[email protected]',
                @copy_recipients ='[email protected];[email protected]',
                @subject = @thisSubject,
                @body = @body1,
                @body_format = 'HTML' ;
        END
    END
END

MockingBird@SBUG

MockingBird@SBUG

The UK SOA BPM User Group (SBUG)is holding a series of mini-meetings over the next few months. These are short live meetings / webcasts. I’m delighted to be presenting my web-service mocking tool , MockingBird at the next mini-meeting to be held on the 29th July.
I will be discussing how MockingBird assists and simplifies integration […]