BizTalk 2013 R2 known bugs, issues & quirks

Below a list of know bugs, issues, & other quirks* of BizTalk 2013 R2 (mainly CU3) and Visual Studio 2013 (update 4) , but I will update with fixes as the CUs come out or when I know about a new issue, so if you have another one I will add it (and link to it if you have a blog about it) if you let me know.  This in addition to the ones listed by Microsoft on Known Issues in Installation, Configuration, and Deployment

I’ve now posted the below article on a TechNet wiki

* My definitions for classifying these are
Bug: Causes negative impact and no known work around or requires a lot of effort to work around.
Issue: Causes negative impact but has an easy or quick work around.
Missing: A feature that BizTalk doesn’t have that would make our life easier.
Quirk:  Something strange or unusual but does not cause a negative impact so far as known.

Moving MFA account with #EXT# to new phone

Something non BizTalk for once.

I needed to move my MFA in Microsoft Authenticator to a new phone and I went from a Android to an iPhone, for which the restore from backup won’t work. For most of my accounts it was relatively straight forward, I would launch a private window and go to http://aka.ms/mfasetup, log in with the credentials, authenticate on the old phone, and then just add the authentication on the new phone via Add Method.

However there were some accounts in the form of MYNAME_COMPANYDOMAIN#EXT#clienttenancy.onmicrosoft.com which were more of a problem. It took a while to find an post on the internet with a solution, but it was a post in this thread that solved it for me.

What you have to do is go to myapps.microsoft.com/resourcetenant.onmicrosoft.com, replacing resourcetenant with your clients Azure/DevOps tenancy, and log in with your company credentials.

Then go to your profile, Security Information, Add new method, and enrol your new phone. After testing it you can delete your old phone there and delete it out of your the Microsoft Authenticator App on your old phone

BizTalk 2016 – CU9

Microsoft have released CU9 for BizTalk 2016 in August, KB5005479

Three fixes for Adapters

• 1 for WCF send ports, FIX: WCF send ports using HTTP or HTTPS transports ignore proxy settings at runtime
• 2 for MQSeries
  • FIX: MQSeries send ports fail with MQ reason code 2082 when sending to alias queue
  • FIX: MQSeries regression with non-transactional UTF-8 receive locations

One fix for Admin tools

• FIX: Error in X12 Agreement if no value set for optional GS1 field in Transaction Set Settings > Envelopes

And an Updated external dependencies, WinSCP to 5.19.2, so if you use SFTP make sure you install that.

BizTalk Server 2016 Feature Update 3 with CU9 is still being worked on

There has been some packaging, signing and test issues so it takes a bit more time, but it is being worked on. It may take a few weeks more, but hopefully earlier. 

NiklasE Microsoft‎Sep 16 2021 05:39 AM

IMPORTANT: You should not install a CU, if you have a feature pack installed, see BizTalk 2016 Feature Pack vs BizTalk 2016 CUs

.Net 4.5 and 4.6, 4.6.1 end of life

Microsoft have announced that .Net 4.5, 4.6 and 4.6.1 are going to be end of life by April 26, 2022.

So as per my blog BizTalk supported Microsoft .Net Frameworks that is going to mean that BizTalk 2013 which can only run on .Net 4.5 that will no longer be getting patches. So if you haven’t been thinking about upgrading BizTalk, now is probably time to start thinking about that.

BizTalk 2013 R2 can run on .Net is 4.6, so make sure you have installed .Net 4.6.2

If you are running BizTalk 2016 with .Net 4.6 you will want to make sure you are at 4.6.2 or either go to .Net 4.7.2 (with at least CU2), or .Net 4.8 (with CU7 and above).

BizTalk 2020 will be running on 4.7.2, but I’m sure Microsoft will support .Net 4.8 for that soon as well.

As a side note, Microsoft is also retiring any contents signed with SHA-1 as per .NET Framework retiring SHA-1 content and UPDATE: SHA-1 signed content to be retired

The Messaging Engine failed to retrieve the configuration from the database. Details:”80131014″.

After changing a SAS key on the Azure Service Bus and updating the SAS credentials in the web.config for all the receive locations, I encountered some errors to do with one of the RelayEndpoint receive locations.

The Messaging Engine failed to retrieve the configuration from the database. Details:”80131014″.

And

WebHost failed to process a request.
Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/52231697
Exception: System.ServiceModel.ServiceActivationException: The service ‘/Company.BT.DocMan.SharePoint/sync/Document/v1/Document.svc’ cannot be activated due to an exception during compilation. The exception message is: Receive location for address “/Company.BT.DocMan.SharePoint/sync/Document/v1/Document.svc” not found. (The BizTalk receive location may be disabled.). —> Microsoft.BizTalk.Adapter.Wcf.AdapterException: Receive location for address “/Company.BT.DocMan.SharePoint/sync/Document/v1/Document.svc” not found. (The BizTalk receive location may be disabled.)
at Microsoft.BizTalk.Adapter.Wcf.Runtime.ReceiveLocationManager2.GetEndpointContext(Uri uri) at Microsoft.BizTalk.Adapter.Wcf.Runtime.WebServiceHostFactory3.CreateServiceHost(String constructorString, Uri[] baseAddresses)
at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CreateService(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)
at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(ServiceActivationInfo serviceActivationInfo, EventTraceActivity eventTraceActivity)
at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)
— End of inner exception stack trace —
at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)
at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath, EventTraceActivity eventTraceActivity)
Process Name: w3wp
Process ID: 2496

Browsing to the receive location URL also resulted in the error that the receive location may be disabled.

The solution, recycle the App Pool that the web service was under in IIS.

BizTalk Server 2020 CU2 is available

As per the announcement by Microsoft BizTalk Server 2020 CU2 is available for download.

For the adapters, SFTP gets 4 fixes, the SB-Messaging adapters 3 fixes, the SAP adapter two fixes and one fix each for the WCF-SQL, Logic App adapters.

Also included is a fix to address configuring log shipping, and also a fix that prevented host instances and admin console not starting if the default web proxy is disabled, a fix for a receive location polling outside the service window and an Arithmetic overflow with convoy messages. Import/export of send handler will now include the configured send handler. And a fix for a null reference error when searching in Archived DTA DB.

Also three fixes for development either not surfacing errors or becoming non-responsive. As per the announcement you need to update your extension if you haven’t already done so.

As a quick reminder, for BizTalk Developer Tools please also update/install version 3.13.2.0 of the BizTalk Server Visual Studio extension in addition to installing the CU package. The extension can be installed from https://marketplace.visualstudio.com/items?itemName=ms-biztalk.BizTalk or from within Visual Studio – Manage Extensions. Please note that we have not updated the extension since CU1 so you can skip this step if you have already installed it previously.”

Microsoft BizTalk Server 2016 Feature Update 3 with CU8

Despite earlier indicating that they weren’t going to release updated Feature Updates with new CUs, Microsoft have actually released Microsoft BizTalk Server 2016 Feature Update 3 with CU8. So you can still get all those CU8 fixes if you have feature packs installed, as you should not install a CU only, if you have a feature pack installed, see BizTalk 2016 Feature Pack vs BizTalk 2016 CUs

Cumulative Update 8 for Microsoft BizTalk Server 2016

Note: Microsoft have release CU 8 for BizTalk 2016 Feature Pack CU 8 can be found here, you should not install a CU only, if you have a feature pack installed, see BizTalk 2016 Feature Pack vs BizTalk 2016 CUs

This CU contains fixes for following fixes for Adapters

• WCF-SQL, 2 fixes
  • The element orders in schemas generated and used in runtime by WCF-SQL adapter are random when large data exists in database
  • WCF-SQL adapter fails reading encrypted varchar(max) column from SQL
• SFTP, 3 fixes & 1 improvement
  • Using macro “%datetime.tz%” within TargetFileName in SFTP send port raises “NotSupportedException” error
  • SFTP receive location stops receiving files silently after running into file permission issues
  • SFTP receive location intermittently stops polling intermittently
  • Improvement: SFTP adapter improvements
    • WinSCP is upgraded to 5.17.8 or later versions.
    • The new “Error Threshold” property disables the receive location on error. The receive location is disabled when the error threshold is exceeded. If the error threshold is set to 0, then the receive location is not disabled.
    • The exceptions that occur in the SFTP receive location is written to the event log. This helps you troubleshoot any issues that affect the receive location.
• Dynamic port
  • Import/export send handler binding information for dynamic send ports
• SB-Messaging
  • When sending message to SB-Messaging send port, the binding property “DefaultScheduledEnqueueTimeUtc” causes an error
• Proxy settings, 2 fixes
  • Predefined WCF Bindings not taking in account a default Web proxy configuration in BizTalk Server
  • BizTalk Server runtime doesn’t use the authentication credentials configured in system web proxy settings

There the two remaining fixes are for BizTalk Server Setup and Configuration “Cannot insert duplicate key row in object ‘dbo.bts_LogShippingHistory’ with unique index” error while configuring log shipping destination

And BizTalk Server Accelerators Digest is not injected in the ACK in FileAct SnF PUSH mode when signature and non-repudiation are requested

MessageBox_DeadProcesses_Cleanup_BizTalkMsgBoxDb failing

I had a test environment where the SQL Agent job MessageBox_DeadProcesses_Cleanup_BizTalkMsgBoxDb had been failing for a while. This job runs exec bts_CleanupDeadProcesses in the message box DB. It was failing with the error

Executed as user: Domain\Account. Could not find stored procedure ‘dbo.int_ProcessCleanup_OLDHOSTNAME’. [SQLSTATE 42000] (Error 2812). The step failed.

Now the clue in this was that the stored procedure was trying to execute another stored procedure with a name of an a host that had been decommissioned, along with several others, after there had been some issues with them and replacement host and host instances had been created.

In that stored procedure it had this

DECLARE btsProcessCurse CURSOR FAST_FORWARD FOR
SELECT s.uidProcessID, s.nvcApplicationName FROM dbo.ProcessHeartbeats AS s WITH (ROWLOCK READPAST)
WHERE (s.dtNextHeartbeatTime < @dtCurrentTime) OPTION(KEEPFIXED PLAN)

So to see what that was getting I ran the below

declare @dtCurrentTime datetime

set @dtCurrentTime = GetUTCDate()

select *
FROM dbo.ProcessHeartbeats WITH (ROWLOCK READPAST)
WHERE (dtNextHeartbeatTime < @dtCurrentTime) OPTION(KEEPFIXED PLAN)

This gave a list of very old heartbeats for all the old host names. To resolve the issue I changed the select * into a delete, and ran that, and the SQL Agent Job is now running correctly.

BizTalk Server 2016 CU8 & future of Feature Packs

There is an an post asking for Feedback on the new Microsoft forums techcommunity that is talking about a CU8 for BizTalk 2016. However it indicates that they are considering releasing only for the base RTM and not for those with Feature Packs, and those that have feature packs are expected to upgrade to BizTalk 2020

Feature Updates to BizTalk Server 2016 provided early production ready access to BizTalk Server 2020 features. All those features are rolled up and now available with BizTalk Server 2020 release. We believe that Feature Updates to 2016 have served its purpose by providing early access to capabilities under work for 2020. 2020 release has further enhanced those features due to the freedom to make larger code changes in new release. BizTalk Server 2020 release has been available since the beginning of year and we released CU1 recently.

Feature Updates were available for select BizTalk Server customers strictly on an opt-in basis with an understanding that these customers will move to 2020 release soon after its availability. BizTalk Server Enterprise customers with Enterprise Agreement are eligible for free upgrade to BizTalk Server 2020. BizTalk Server 2020 supports in-place and seamless upgrade from BizTalk Server 2016.

We are in the planning process for CU8 release of BizTalk Server 2016 and were hoping, keeping above in mind, to continue releasing the CUs for the base 2016 (aka RTM) versions that caters to all SKUs and customers uniformly. Those who were on accelerated cadence by opting into Feature Packs, will move to BizTalk Server 2020 for their support requirements

We want to gather community response before finalizing our decision. Let us please use the discussion space under this post with constructive comments to help us arrive at a decision that helps us optimize engineering resources without compromising the customer needs.

https://techcommunity.microsoft.com/t5/biztalk-server/hotfixes-and-cus-for-biztalk-server-2016-feature-update/m-p/1569583/highlight/false#M54

Do you have an opinion about this? If so, now is your chance to provide feedback.

BizTalk 2020 CU1 released

BizTalk 2020 CU1 was released on July 28th 2020 as announced here

As per previous version of BizTalk it has a number of SAP/IDOC fixes.

Fixes

• 4 SAP/IDOX
• 2 fixes related to the WCF-SQL adapter (order of elements and FILESTREAM operations)
• 1 for the Oracle DB adapter to handle Database artifacts with nested types in Oracle 18c and later versions
• Fix for predefined WCF Bindings not taking in account a default Web proxy configuration
• 2 JSON Encoder fixes (1 one which was fixed for BizTalk 2016 in CU7)
• Fix for XLTS errors not being reported in XSLT stylesheet
• Fix for EDI receive location with named SQL instance
• Fix for ESB Toolkit to use gMSA.
• Fix to remove dependency on VS 2019 version 16.3.9
• FIX: Mapper toolbox not working for WCF Workflow Service Application after upgrade to BizTalk 2020

Improvements

• FTP improvement (macros for Before Put and After Put)
• Dynamic send ports able to use Officer 365 Outlook adapter types.

Visual Studio Extension

In addition to installing CU package, also update/install new version of BizTalk Server Visual Studio extension (3.13.2.0). The extension can be installed from https://marketplace.visualstudio.com/items?itemName=ms-biztalk.BizTalk or within Visual Studio – Manage Extensions.

As per other CUs, you can find them on the page Service Pack and cumulative update list for BizTalk Server