The Messaging Engine failed to add a receive location “rlAtlasMyExchangeName-RabbitMQ” with URL
to the adapter “RabbitMQ”. Reason: “None of the specified endpoints were reachable”.
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 instead of hq in the Host Name.
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 AS [Assembly],
orc.nvcName AS [Orchestration],
orc.nOrchestrationStatus AS [Status],
orp.nvcName AS [Orchestration Port],
pt.nvcName AS [Port Type],
pto.nvcName AS [Port Type Operation],
rp.nvcName AS [Receive Port],
rl.Name AS [Receive Location],
rppl.Name AS [Receive Pipeline],
sp.nvcName AS [Send Port],
sppl.Name AS [Send Pipeline],
spg.nvcName AS [Send Port Group]
FROM bts_application app WITH(NOLOCK)
LEFT OUTER JOIN bts_assembly ass WITH(NOLOCK) ON app.nID = ass.nApplicationId
LEFT OUTER JOIN bts_orchestration orc WITH(NOLOCK) ON ass.nID = orc.nAssemblyId
LEFT OUTER JOIN bts_orchestration_port orp WITH(NOLOCK) ON orc.nID = orp.nOrchestrationId
LEFT OUTER JOIN bts_porttype pt WITH(NOLOCK) ON orp.nPortTypeID = pt.nID
LEFT OUTER JOIN bts_porttype_operation pto WITH(NOLOCK) ON pt.nID = pto.nPortTypeID
LEFT OUTER JOIN bts_orchestration_port_binding opp WITH(NOLOCK) ON orp.nID = opp.nOrcPortID
LEFT OUTER JOIN bts_receiveport rp WITH(NOLOCK) ON opp.nReceivePortID = rp.nID
LEFT OUTER JOIN adm_ReceiveLocation rl WITH(NOLOCK) ON rp.nID = rl.receiveportId
LEFT OUTER JOIN bts_pipeline rppl WITH(NOLOCK) ON rl.ReceivePipelineId = rppl.Id
LEFT OUTER JOIN bts_sendport sp WITH(NOLOCK) ON opp.nSendPortID = sp.nID
LEFT OUTER JOIN bts_pipeline sppl WITH(NOLOCK) ON sp.nSendPipelineID = sppl.Id
LEFT OUTER JOIN bts_sendportgroup spg WITH(NOLOCK) ON opp.nSpgID = spg.nID
WHERE orc.nvcName IS NOT NULL
and rppl.Name like '%json%'
ORDER BY 1,2,3
-- 1 = Unenlisted
-- 2 = Stopped
-- 3 = Started
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, finding a program can be quite a search.
At first, I though “svnlookup” was the answer, but that can only be run on the server. Specifying the server URL on this command
This seems to be what I was looking for:
For Windows without Grep command:
svn list -R https://subversion-repo/subfolder | findstr filename
or if you have a “grep” command:
svn list -R https://subversion-repo/subfolder | grep filename
To search just the “Trunk” if you have grep command:
svn list -R https://subversion-repo/subfolder | grep Trunk.*filename
It can take several minutes to run.
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 installed ‘RabbitMQ.Client 5.0.1’.
Adding ‘RabbitMQ.Client 5.0.1’ to RabbitMQConsoleTester.
Uninstalling ‘RabbitMQ.Client 5.0.1’.
Successfully uninstalled ‘RabbitMQ.Client 5.0.1’.
Install failed. Rolling back…
Install-Package : Could not install package ‘RabbitMQ.Client 5.0.1’. You are trying to install this package into a project that targets
‘.NETFramework,Version=v4.5’, but the package does not contain any assembly references or content files that are compatible with that framework. For more
information, contact the package author.
At line:1 char:1
+ Install-Package RabbitMQ.Client -Version 5.0.1
+ CategoryInfo : NotSpecified: (:) [Install-Package], InvalidOperationException
+ FullyQualifiedErrorId : NuGetCmdletUnhandledException,NuGet.PowerShell.Commands.InstallPackageCommand
When using SOAPUI to call a BizTalk published ochestration or schema, you might get this error response/XML from SOAP-UI:
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 is a mismatch between bindings. The security context token would be invalid if the service aborted
the channel due to inactivity. To prevent the service from aborting idle sessions prematurely increase
the Receive timeout on the service endpoint’s binding
Assuming no security is needed when first testing on your local machine. You can tighten up the security after you get the basic test working.
- Modify the web.config file of the published webservice and set the authentication mode to “None”.
- Modify the BizTalk Receive Location created by the WCF publish utility, on the Security tab, set the “Security mode” to none.
- In SOAP-UI, click on the WS-A words (tab) below your request xml message. Set the options as shown below: