List of Macros in BizTalk

Following are list of macros for send used in BizTalk: Macro name Substitute value %datetime% Coordinated Universal Time (UTC) date time in the format YYYY-MM-DDThhmmss (for example, 1997-07-12T103508). %datetime_bts2000% UTC date-time in the format YYYYMMDDhhmmsss, where sss means seconds and milliseconds (for example, 199707121035234 means 1997/07/12, 10:35:23 and 400 milliseconds). %datetime.tz% Local date time plus… Continue reading List of Macros in BizTalk

A .NET Framework error occurred during execution of user-defined routine or aggregate ‘deploy_project_internal’

I where trying to Configure EDI/AS2 using BizTalk 2020 Configure wizard, I faced below error while configuring so: TITLE: Microsoft BizTalk Server Configuration Wizard Failed to deploy BAM activity definitions. Please make sure that all BAM related Data Transformation Services (DTS) packages are removed along with the BAM databases. (Microsoft.BizTalk.Configuration.EDIAS2.Utility) For help, click: http://go.microsoft.com/fwlink/events.asp?ProdName=Microsoft+BizTalk+Server&ProdVer=3.13.717.0&EvtSrc=Microsoft.BizTalk.Configuration.EDIAS2.Utility&EvtID=StrFailedToDeployBAMActivity ADDITIONAL… Continue reading A .NET Framework error occurred during execution of user-defined routine or aggregate ‘deploy_project_internal’

DATABASE ‘BAMANALYSIS’ HAS COMPATIBILITY LEVEL LARGER THAN 1103 WITH STORAGEENGINEUSED SET TO INMEMORY.BIZTALK 2016 SQL 2016 /BIZTALK 2020 SQL 2019

Once I where trying to install BAM Portal and it lead some error while configuring using BizTalk Config Wizard !!! But after spending N hours I understood the root cause This the error we see in the BizTalk Config log TITLE: Microsoft BizTalk Server Configuration Wizard Error configuring BAM Tools (BAMTools) For help, click: http://go.microsoft.com/fwlink/events.asp?ProdName=Microsoft+BizTalk+Server&ProdVer=3.13.717.0&EvtSrc=BAMTools&EvtID=idsErrorConfiguringTools… Continue reading DATABASE ‘BAMANALYSIS’ HAS COMPATIBILITY LEVEL LARGER THAN 1103 WITH STORAGEENGINEUSED SET TO INMEMORY.BIZTALK 2016 SQL 2016 /BIZTALK 2020 SQL 2019

How can we enable BAM Add-In for Excel?

Add-ins provide optional commands and features for Microsoft Excel. In this case, the BAM Add-In for Excel provides the tools that you need to create a BAM observation model. In other words, it will allow you to define what data to collect from business processes and to define the way in which business users will… Continue reading How can we enable BAM Add-In for Excel?

Biztalk 2020 Installation

Preliminary need before install: Microsoft OLE DB Driver for SQL Server. Visual C++ 2015-2019 redistributable package – x86 and Visual C++ 2015-2019 redistributable package – x64 (https://support.microsoft.com/en-us/topic/the-latest-supported-visual-c-downloads-2647da03-1eea-4433-9aff-95f26a218cc0) SQL Server 2017/2019 (https://my.visualstudio.com/Downloads?q=SQL%20Server%202017%20Developer&pgroup=) Visual Studio 2019(optional) for development (https://my.visualstudio.com/Downloads?q=BizTalk Server 2020 Developer Edition&pgroup=)

What are distinguished fields and how to create a distinguished field?

Distinguished fields are message elements that are written into the message context. The main source of confusion between distinguished fields and promoted properties is that they are both created in Visual Studio’s Schema Editor through the “Promote -> Show Promotions” contextual menu option of a message schema’s element. Once the dialog box is open, make… Continue reading What are distinguished fields and how to create a distinguished field?

Published
Categorized as BizTalk, Q&A

What are Promoted Properties and How to promote properties?

Promoted Properties are Message Context Properties that are flagged as promoted. Being promoted it allows the Message Engine to route messages based on their value, and being in the message context allows doing so without having to look at the message payload (which would be an expensive operation). They are the most common way to… Continue reading What are Promoted Properties and How to promote properties?

Published
Categorized as BizTalk, Q&A

Distinguished Fields vs. Promoted Properties in BizTalk

BizTalk provides two types of property promotions: Distinguished Fields and Property Fields. In a simple words, distinguished fields can only be used within orchestration whereas promoted property fields can be accessed through all phases of the BizTalk message processing – orchetration or from custom code,, pipelines, port filter (routing).. Distinguished Fields Promoted Properties(Property Fields) Are… Continue reading Distinguished Fields vs. Promoted Properties in BizTalk