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 […]
Suppose you are at a new clients, and you want to see quickly all the orchestrations are bound to send and receive ports. Here’s some code to help you get started with that. <pre> select op.nvcName as 'OrchInternalPortName', o.nvcName as 'OrchName', 'SendPort' as 'SendOrReceive', sp.nvcName as 'PortName' from bts_orchestration_port op inner join […]
When running NUGET “install-package NEST” (or possibly any other that uses newtonsoft-json), get error: “‘Newtonsoft.Json’ already has a dependency defined for ‘Microsoft.CSharp’” In my case, I was at a client running Visual Studio 2013 and needed to upgrade the version of Nuget. Reference: https://stackoverflow.com/questions/42045536/how-to-upgrade-nuget-in-visual-studio-2013 In Visual Studio: Tools -> Extensions and Updates -> Updates tab -> Visual Studio […]