BizTalk Server Error – There Was a Failure Executing the Send Pipeline

Problem
There was a failure executing the send pipeline: "Microsoft.Practices.ESB.ExceptionHandling.Pipelines.ESBFaultProcessor, Microsoft.Practices.ESB.ExceptionHandling.Pipelines, Version=2.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Source: "ESB Transform" Send Port: "ALL.Exceptions" URI: "SQL://MYSQLSERVER/EsbExceptionDb/" Reason: Error 175002: An unexpected error occurred while trying to execute the map, 'Microsoft.Practices.ESB.ExceptionHandling.Maps.FaultMessage_to_ExceptionSql, Microsoft.Practices.ESB.ExceptionHandling.Maps, Version=2.1.0.0, Culture=neutral, PublicKeyToken=38642839467826'.


Cause

I believe this has to do with there not being a resumable at the time the exception was triggered. Not positive if this is the case however.

Solution

Terminate the resumable items.

BizTalk360 Analytics Report CPU Graphs Issue

Problem:

I am using BizTalk360 version 8.9.5112.2201 in a BizTalk2016 environment. In setting up reports, I came across an interesting issue.  If you have looked at the CPU usage reports, you may have noticed that the graphs do not match actual performance.

Consider the following SQL Servers Performance graph.

SQL Servers Performance
SQL Servers Performance

You will notice that the left-side legend is displaying 0-100%. I make the assumption that this is Total CPU and the right-side legend is memory usage.

Continue reading BizTalk360 Analytics Report CPU Graphs Issue

SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application’

Error:

SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application'

Continue reading SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application’