EDI. promoted properties (such as ISA06) not appearing in Orchestration Expression dropdown

I had an orchestration from a BizTalk 2010 that had the following code: vISA06 = msg_EDI_997(EDI.ISA06); vISA08 = msg_EDI_997(EDI.ISA08); We were updating and refactoring to 2016. When I put that code in my 2016 orchestration, it got an error. I checked, and the EDI. fields were not showing up in the Intellinsense “drop down”. The […]

BizTalk The database associated with the deployment driver does not match database of the during product configuration.

Error When trying to deploy a Business Rule Engine Policy in BizTalk Server 2013, I was getting the error: The database “Server:Instance” associated with the deployment driver does not match database “Server2:Instance2” of the during product configuration. Solution You can run a SQL script like the following (on my machine, there was only one row […]

BizTalk and “Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.”

Error Microsoft.ServiceModel.Channels.Common.ConnectionException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. —> System.Data.SqlClient.SqlException: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. The user was correct, and that was driving me crazy. I had just built the database from a script, […]

SQL to XREF all BizTalk Maps on all Send and Receive Ports

Suppose you want to find if a map is used on some ReceivePort. In BizTalk, one Receive Port can contain multiple maps. The one that is executed is based on the matching target namespace and root element. <pre> select app.nvcName as ApplicationName,        rp.nvcName as ReceivePortName,        it.Name as MapName,        it.FullName,   — you might […]

XREF a BizTalk BTS.Operation back to the Orchestration Operation Name

Today, I saw a send port that had a filter such as BTS.Operation == Send204External. I looked at the orchestrations that I thought were involved in this application/project, but couldn’t find that operation name in any of the orchestration send ports. There are two approaches to doing the xref: 1) Scanning all the code. I […]

SQL Command to List BizTalk Receive/Port Locations (and Addresses) by Application

The query below shows how to join the BizTalk Receive Port and Receive Location, along with the Application Name. <pre> select app.nvcName,        rp.nvcName as ReceivePort,        bTwoWay,        rl.Name as ReceiveLocation,        InboundTransportURL,        ReceivePipelineData   from bts_receiveport rp inner join adm_ReceiveLocation rl on rl.ReceivePortId = rp.nID inner join bts_application app on rp.nApplicationID = app.nID […]

SQL command to list BizTalk send ports by application

I’ve been doing a lot of reverse engineering and studying of old systems as we migrate them to new releases of BizTalk. I find myself constantly using SQL command to narrow down the ports I’m interested in… By joining to the bts_sendport_transport table, we are able to show the address (for example, disk/file directory name, […]

Matching RabbitMQ RoutingKey from BizTalk Send/Receive Ports

We have our own RabbitMQ adapter. The addresses look like the following. Send Port rabbit@dev.myRabbitMQ.com/Exchange=MyRabbitMQTopic&RoutingKey=MyRoutingKey Receive Location rabbit@dev.myRabbitMQ.com/Queue=MyQueueName&RoutingKey=MyRoutingKey What I wanted to do is match which Receive Ports subscribe to RabbitMQ RoutingKeys from other Send Ports. In other words, when I send out a message from one orchestration (send port), which orchestration (or Receive Port) […]

How to get properly formatted fully qualified assembly name

Sometimes you need the full assembly name, properly formatted to use for various reasons (such as a WCF Custom Behavior file that is imported into BizTalk adapter). Here are a couple of ways to get it: DOS Comamnd Window (GacUtil /L) C:\Windows\system32>gacutil /l | find "bLogical"   bLogical.BizTalk.RESTBehavior, Version=1.0.0.0, Culture=neutral, PublicKeyToke n=8b7f8ad23140b57b, processorArchitecture=MSIL   bLogical.RESTSchemas, Version=1.0.0.0, Culture=neutral, […]