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 […]
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 […]
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 […]
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, […]
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) […]
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, […]
#Biztalk Kill Process associated with BizTalk Host Instance $processID = Get-WmiObject Win32_Service -Filter "Name='BTSSvc`$BizTalkServerApplication'" | Select-Object -Expand ProcessID Write-Host "processID=$processID" stop-process -id $processID -Force Write-Host "Completed" This can be used to kill a BizTalk Host Instance that is in the stop-pending state. Other commands you can run to see how the Get-WmiObject Win32_Service works: #get-wmiobject […]
The following two queries return all send and receive ports/locations that use a given pipeline component. You can filter on the friendly name or the fully qualified name. This query can be very useful when you need to change a pipeline component, and you need to “roll off” the applications that use it, make the […]
Error: The Messaging Engine failed to add a receive location “rlAtlasMyExchangeName-RabbitMQ” with URL “rabbit@VM3-NWalters.hg.mysite.net/Queue=D.Data.MySite.MyExchangeName&RoutingKey=D.Data.MySite.MyExchangeName” to the adapter “RabbitMQ”. Reason: “None of the specified endpoints were reachable”. Solution: This means that either you cannot connect to the server (or maybe the user doesn’t have access). In my case, it was a stupid typo, I had hg […]
Today, I was trying to find if a JSON pipeline we had was being used on a given BizTalk system. I found the SQL command from here: https://gallery.technet.microsoft.com/Show-BizTalk-Applications-8f73d753 and just modified it to add an additional condition to the where clause and rppl.Name like ‘%json%’ Here is the full command: SELECT app.nvcName AS [Application], ass.nvcName […]