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 […]
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, […]
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 […]