Author: Admin

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

Suppose you have a large code base, and you just want to search for a program name, without downloading the codebase to your local disk.  If the naming conventions are hierarchical, you can usually use the “repo-browser”, for example that comes with Tortoise-SVN.  But if a program is named differently from the hierarchical directory structure, […]

The newer versions of RabbitMQ from https://www.nuget.org/packages/RabbitMQ.Client have issues with older version of DotNet and Visual Studio 2013. I picked the highest release before 4.0 and at least the NuGet package installed. Install-Package RabbitMQ.Client -Version 3.6.9 Trying to install anything after 4.0 will give the following errors: PM> Install-Package RabbitMQ.Client -Version 5.0.1 Installing ‘RabbitMQ.Client 5.0.1’. Successfully […]

When using SOAPUI to call a BizTalk published ochestration or schema, you might get this error response/XML from SOAP-UI: Error Main error text is: The message could not be processed. This is most likely because the action ‘http://Neal.Temp.WCFTargetNamespace/Outbound214Service/Send214Request’ is incorrect or because the message contains an invalid or expired security context token or because there […]

Here is some more forensic/investigative code. Suppose you need to make sure a value gets in a certain column, but you don’t know the system at all. Maybe there is a trigger or stored proc that sets the column based on some other table/column. This code gives you a list of all the stored procedures, […]

When you come to a new client, and have try to fix bugs or figure out how the system works, it helps to have some “forensice” SQL tools. Suppose you want to find all columns in a database, regardless of which table they are (and of course, show the table name in the query results). […]

Suppose you want to know what BizTalk Orchestrations are bound to a send port. Perhaps you ran my query to list send ports related to a receive port. NOTE: Still experimental code; haven’t verified much. select rp.nvcName as 'ReceivePort', op.nvcName as 'OrchPort', op.nBindingOption, o.nvcName as 'Orchestration' –pto.nvcName as 'PortTypeOperation', from bts_receiveport rp inner join bts_orchestration_port_binding […]

How do you find the hidden map name in the BiztalkMgmtDB (BizTalk Database)? If you look at the table names, you will obviously find bt_MapSpec, but it doesn’t contain the map name. The map itself is hidden in the bts_Item table, which you have to join to. I found this on Jeroen Maes Integration Blog. […]

You can turn on message tracking in BizTalk at the Receive Port and Send Port level (as well as various levels in the orchestration). Here are the views provided by the BizTalk install. use biztalkDtaDb –select * from TrackingData –select 'btsv_Tracking_Fragments', * from btsv_Tracking_Fragments select 'btsv_Tracking_Parts', * from btsv_Tracking_Parts select 'btsv_Tracking_Spool', * from btsv_Tracking_Spool To […]