Error Code: 0xC0002A1F, Cannot perform encryption or decryption because the secret is not available from the master secret server. See the event log for related errors.

Problem

I was attempting to add the WCF-SQL port to support an application and when applying settings and I got an error about no endpoints available.

Cause

Unknown. The environment was setup quite a while back and was never used. I suspect the lack of usage caused the issue.

Solution

Reboot the BizTalk server and the SQL server containing the SSO db.

BizTalk Server Error – There Was a Failure Executing the Send Pipeline

Problem
There was a failure executing the send pipeline: "Microsoft.Practices.ESB.ExceptionHandling.Pipelines.ESBFaultProcessor, Microsoft.Practices.ESB.ExceptionHandling.Pipelines, Version=2.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Source: "ESB Transform" Send Port: "ALL.Exceptions" URI: "SQL://MYSQLSERVER/EsbExceptionDb/" Reason: Error 175002: An unexpected error occurred while trying to execute the map, 'Microsoft.Practices.ESB.ExceptionHandling.Maps.FaultMessage_to_ExceptionSql, Microsoft.Practices.ESB.ExceptionHandling.Maps, Version=2.1.0.0, Culture=neutral, PublicKeyToken=38642839467826'.


Cause

I believe this has to do with there not being a resumable at the time the exception was triggered. Not positive if this is the case however.

Solution

Terminate the resumable items.

BizTalk360 Analytics Report CPU Graphs Issue

Problem:

I am using BizTalk360 version 8.9.5112.2201 in a BizTalk2016 environment. In setting up reports, I came across an interesting issue.  If you have looked at the CPU usage reports, you may have noticed that the graphs do not match actual performance.

Consider the following SQL Servers Performance graph.

SQL Servers Performance
SQL Servers Performance

You will notice that the left-side legend is displaying 0-100%. I make the assumption that this is Total CPU and the right-side legend is memory usage.

Continue reading BizTalk360 Analytics Report CPU Graphs Issue