Microsoft Integration and Azure Stencils Pack for Visio: New version available (v6.3.0)

Microsoft Integration and Azure Stencils Pack for Visio: New version available (v6.3.0)

I am always paying attention to requests from members of the community, and whenever I can, I update this stencil pack with requested shapes or functionalities. And this is one of these cases. One of the most common complaints about this stencil pack was/is text annotations. When you try to add a legend on the stencil, the text is in the middle of the icon, instead of underneath. And sometimes the text is white, which doesn’t help also.

Microsoft Integration and Azure Stencils Pack for Visio: text annotation issue

Another recent aspect that came to my attention was the fact that was missing proper connector points, which make it hard to properly connect shapes in a diagram.

Microsoft Integration and Azure Stencils Pack for Visio: connector points issue

Of course, all of these you can manually fix by move the text to the bottom of each shape, change the color of the text and add connector points. But some of these tasks required a more deep knowledge of working with Visio and they are time-consuming. Luckily this work is being made, it may take a while since this package has more than 2000 shapes!

What’s new in this version?

Today I can announce that the first phase is done and the first file, and probably the most important, of this package is fixed:

  • Microsoft Azure (MIS Azure Stencils.vssx): This package contains stencils of Azure Services (original icons) that are available thru the Azure Portal.

The main goal of this release was to solve or improve the user experience regarding text annotations and connector points. In this version, the changes and additions are:

  • Text annotations issue solved: This issue was solved on the stencils present on the Microsoft Azure (MIS Azure Stencils.vssx) file;
  • Proper connector points added: This improved feature was added on stencils present on the Microsoft Azure (MIS Azure Stencils.vssx) file;
Microsoft Integration and Azure Stencils Pack for Visio
  • Fixed some minor stencils layouts;
  • New shapes: New shapes added on Microsoft Azure (MIS Azure Stencils.vssx) and Microsoft Azure: Others (MIS Azure Others Stencils.vssx);

Microsoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack

Microsoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack it’s a Visio package that contains fully resizable Visio shapes (symbols/icons) that will help you to visually represent On-premise, Cloud or Hybrid Integration and Enterprise architectures scenarios (BizTalk Server, API Management, Logic Apps, Service Bus, Event Hub…), solutions diagrams and features or systems that use Microsoft Azure and related cloud and on-premises technologies in Visio 2016/2013:

  • BizTalk Server
  • Microsoft Azure
    • Integration
      • Integration Service Environments (ISE)
      • Logic Apps and Azure App Service in general (API Apps, Web Apps, and Mobile Apps)
      • Azure API Management
      • Messaging: Event Hubs, Event Grid, Service Bus, …
    • Azure IoT and Docker
    • AI, Machine Learning, Stream Analytics, Data Factory, Data Pipelines
    • SQL Server, DocumentDB, CosmosDB, MySQL, …
    • and so on
  • Microsoft Power Platform
    • Microsoft Flow
    • PowerApps
    • Power BI
  • Office365, SharePoint,…
  • DevOps and PowerShell
  • Security and Governance
  • And much more…
  • … and now non-related Microsoft technologies like:
    • SAP Stencils
Microsoft Integration (Azure and much more) Stencils Pack

The Microsoft Integration Stencils Pack is composed of 27 files:

  • Microsoft Integration Stencils
  • MIS Additional or Support Stencils
  • MIS AI and Machine Learning Stencils
  • MIS Apps and Systems Logo Stencils  
  • MIS Azure Additional or Support Stencils
  • MIS Azure Mono Color
  • MIS Azure Old Versions
  • MIS Azure Others Stencils
  • MIS Azure Stencils
  • MIS Buildings Stencils
  • MIS Databases and Analytics Stencils
  • MIS Deprecated Stencils
  • MIS Developer Stencils
  • MIS Devices Stencils
  • MIS Files Stencils
  • MIS Generic Stencils
  • MIS Infrastructure Stencils
  • MIS Integration Fun
  • MIS Integration Patterns Stencils
  • MIS IoT Devices Stencils
  • MIS Office365
  • MIS Power BI Stencils
  • MIS PowerApps and Flows Stencils
  • MIS SAP Stencils
  • MIS Security and Governance
  • MIS Servers (HEX) Stencils
  • MIS Users and Roles Stencils

That you can use and resize without losing quality, in particular, the new shapes.

Download

You can download Microsoft Integration, Azure, BAPI, Office 365 and much more Stencils Pack for Visio from:
Microsoft Integration Azure Stencils Pack VisioMicrosoft Integration, Azure, Power Platform, Office 365 and much more Stencils Pack for Visio
GitHub

The post Microsoft Integration and Azure Stencils Pack for Visio: New version available (v6.3.0) appeared first on SANDRO PEREIRA BIZTALK BLOG.

July 06, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

July 06, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

Do you feel difficult to keep up to date on all the frequent updates and announcements in the Microsoft Integration platform and Azure iPaaS?

Integration weekly update can be your solution. It’s a weekly update on the topics related to Integration – enterprise integration, robust & scalable messaging capabilities and Citizen Integration capabilities empowered by Microsoft platform to deliver value to the business.

 

Microsoft Announcements and Updates

 

Community Blog Posts

 

Video

 

Podcasts

 

How to get started with iPaaS design & development in Azure?

Feedback

Hope this would be helpful. Please feel free to reach out to me with your feedback and questions.

BizTalk360 Database – An In-Depth Insight

BizTalk360 Database – An In-Depth Insight

BizTalk360 is the one-stop monitoring product for your BizTalk environment. Installing and upgrading BizTalk360 is a seamless process when all the permissions and configurations are in place. Each software product has a frontend and a backend. Most often people focus on the frontend more to give a rich user experience. On the other hand, the backend would be considered only when it comes to the performance of the product. Of course, it is the DBAs responsibility to check the health of the database.

BizTalk360 being an on-premise product, it has its own database which becomes created while installing the product. It is always a good practice to take care of the database and the data, to avoid the performance problems as per the saying,

“Data is a precious thing and will last longer than the systems themselves”

In this blog, I will give in-depth insight into the BizTalk360 database and some useful tips to take care of the database and the data to make the DBA’s work a little easier.

The BizTalk360 Database

The BizTalk360 application comes with the BizTalk360 database which contains about 116 tables, and a few stored procedures and views in it. Let us dig in and see what the important tables in the database are. One main point to be noted is that no changes should be done at the database level manually unless and until it is important and required.

The below table gives a clear picture of the important database tables related to the BizTalk360 modules.

Modules

Table Names

Installation

b360_admin_BizTalkEnvironment

b360_admin_GlobalProperties

Database information

b360_admin_DBMigration_Status

b360_admin_DBVersion

b360_admin_DBVersion_History

License information

b360_admin_LicenseActivation

Monitoring

b360_alert_Monitor

b360_alert_MonitorExecution

b360_ev_MonitoredServers

b360_mon_Service

Data Monitoring

b360_st_DataMonitorTasks

b360_st_DataMonitorResults

b360_st_DataMonitorTaskActionResults

b360_st_ProcessMonitorResults

b360_st_Schedules

Analytics – Performance

b360_perf_PerfCounter

b360_perf_PerfCounter_Data

b360_perf_PerfCounter_Expanded

Analytics – Messaging Patterns

b360_analytics_flows

b360_analytics_artifact_versions

Analytics – Reports

b360_report_Schedules

b360_report_Dashboards

 

Let us look at a few scenarios where updating of the tables would be required.

Connecting the BizTalkMgmtDb Database on a New Installation

It is often suggested as a best practice to install BizTalk360 in a separate standalone server over a BizTalk server, for better performance. In this case, to monitor the BizTalk server, the BizTalkMgmtDb details must be updated in the b360_admin_BizTalkEnvironment table in the BizTalk360 database or through the UI, else the following error message would appear in BizTalk360.

Connecting BizTalkMgmtDb database

BizTalk360 database

Migrating the BizTalk Server

Consider a scenario where your BizTalk environment is migrated to a higher version. When the BizTalk server is upgraded, the BizTalk360 server also needs to be upgraded with the same version of the admin components. If not, the following error will be seen in the BizTalk360 UI.

Migrating the BizTalk Server

The below tables need to have the BizTalk version changed appropriately and the MS_BizTalk_install_location can be updated.

  • b360_admin_BizTalkEnvironment -> BizTalk Version
  • b360_admin_GlobalProperties -> MS_BIZTALK_VERSION & MS_BIZTALK_INSTALL_LOCATION

Monitoring Scenarios

Monitoring is considered a core functionality of BizTalk360. There may be some cases where the alerts may not be triggered. When checked in the logs, there might be timeout exceptions.

Monitoring Scenarios

When there are a large number of data monitoring alarms and if much of their historical data is present in the database, it may result in timeouts and the exception can be seen in the Data monitoring alarm grid, for example when trying to delete an alarm. Maintaining the historical data for a long time may result in large database growth. This can be reduced by minimizing the purge duration.

The artifacts information which is mapped for monitoring can be found in the b360_alert_monitor table.

Data Purging

BizTalk360 has its own purging procedure to take care of purging data in the BizTalk360 database. In the Settings side, you can configure after how much time you want specific data to be purged. If you feel, the database grows with huge volumes of data, you can decide to change the purge policies.

purge policies

Data Purging

The Event Log Data Collection

BizTalk360 can collect event log information from the BizTalk and SQL servers which are connected to the BizTalk environment. The event log data can be viewed in BizTalk360 by configuring and using the Advanced Event Viewer. The data is collected from the servers and stored in the b360_ev_EventLogData table. By default, there are many sources configured in BizTalk360.

The Event Log data collection

This will collect the data for all the event levels and sources and store it in the table. However, this may also result in huge database growth thereby affecting the performance of the product.

To resolve this problem, the Event Log levels and sources, for which the data needs to be viewed, can be configured in BizTalk360 and the remaining sources can be removed from the configuration.

This will reduce the amount of data being polled for and stored in the database. Also, the purge duration can be reduced to remove the historical data.

Analytics Performance Data Collection

The Analytics module in BizTalk360 mainly deals with the performance-related information of the BizTalk and SQL servers. The performance data gets collected through the perfmon counters and stored in the performance-related tables mentioned above. The BizTalk360 Analytics service collects the data by contacting the servers through PerfMon and store it in the BizTalk360 database. By default, all the available metrics would be collected. This may also result in huge volumes of data which in turn might affect the performance.

To enhance the performance and to reduce the database growth, there has been added an option in BizTalk360 to choose the metrics for which the data needs to be collected and used in BizTalk360.

Analytics performance data collection

Data purging is also available for performance-related information. The purge duration can be minimized to reduce the database growth.

There are different stored procedures available in the database to take care of the purging action. The purging subservice, running under the BizTalk360 monitoring service, is responsible for executing the purge stored procedures.

In SQL Server Management Studio, there is the Disk usage by the top tables database report. This report helps to find out the tables which are containing high volumes of data.

BizTalk360 database

Database Permissions for the Service Account

As a prerequisite to installing BizTalk360, it is recommended to provide sysadmin permission for the BizTalk360 service account for smooth installation. Since there would be inserts, updates, creates, and alters, sysadmin permission is recommended.

Small Talk on the BizTalk Databases

Having said about the BizTalk360 database, let us now talk shortly about the BizTalk databases.  BizTalk360 communicates with the BizTalkMgmtDb database to fetch the data of the application and its artifacts for monitoring. The service instances information would be obtained from the BizTalkMsgBox database. Hence, it is necessary to keep an eye on the growth of the BizTalk databases as well in the dba perspective.

There might be a case where the Process monitoring results in the actual count -1. The reason might also be a timeout exception. This will happen when the BizTalkDTADb database is huge in size. This can be found out by checking the database reports to find out the disk usage of the top tables. We can check for the purging of the tracking database. The recommendations to control the size of the databases can be found here.

Conclusion

We hope this article gives you some more information about the BizTalk360 database. When the purging is in place, the database growth can be controlled, and it will be healthy. Happy monitoring with BizTalk360!

The post BizTalk360 Database – An In-Depth Insight appeared first on BizTalk360.

Thanks! Awarded as Microsoft Azure MVP 2020-2021

Thanks! Awarded as Microsoft Azure MVP 2020-2021

And the most expected email arrived once again on 1st July, thank you Microsoft for this amazing award. Once again, I’m delighted to share that I was renewed as a Microsoft Azure MVP (Microsoft Most Valuable Professional). This is my 10th straight year on the MVP Program, an amazing journey, and experience that started in 2011 as BizTalk MVP, which gave me the opportunity, and still does, to travel the world for speaking engagement, share the knowledge, and to meet the most amazing and skilled people in our industry.

I would like to thank the MVP Team, my MVP Lead Cristina Herrero, all my fellow MVPs, my beautiful family, my coworkers at DevScope, and in special all my blog readers, friends, members of Microsoft Enterprise Integration Community for their support during these years.

It’s a big honor to be in the program and be one of this amazing worldwide group of technicians and community leaders who actively share their high quality and real-world expertise with other users and Microsoft. I’m looking forward to another great year!

The post Thanks! Awarded as Microsoft Azure MVP 2020-2021 appeared first on SANDRO PEREIRA BIZTALK BLOG.

BizTalk Server 2020: PowerShell to Configure Host, Host Instances and Adapter handlers according to some of the Best Practices

BizTalk Server 2020: PowerShell to Configure Host, Host Instances and Adapter handlers according to some of the Best Practices

In the past, I wrote several blog post about Configuring BizTalk Server Host and Host Instances according to some of the Best Practices

The reason I end up creating a new version for BizTalk Server 2016 was that previous scripts only did 90% of the work, and they were intended to be used on “day zero” of your environment, i.e., after you finish installing your environment.

So, I update my previous script to add more functionalities, mainly:

  • Configure the Default Send Handler as the Send Handler for each existing static and Dynamic Send Ports
  • Configure Receive Handlers from all the existing Receive locations

With these missing functionalities added to the script, it will configure or reconfigure 100% of your environment. You can use it on “day zero” or in an already up and running environment. Of course, this was optimized to BizTalk Server 2016 (but it can be executed in all precious BizTalk Server previous versions).

Why a new version dedicated to BizTalk Server 2020?

There are two reasons why I decide to create this new script, specific only to BizTalk Server 2020:

  • The previous scripts don’t run properly in BizTalk Server 2020;
  • And BizTalk Server 2020 now has support to Group Managed Service Accounts;

The first reason is very simple. The previous scripts will not work giving you an invalid credential error even though you are putting the correct credentials has Gaurav Sood kindly reported to me.

The reason why this error is happening was because one undocumented change that product group made on the MSBTS_HostInstance WMI Class and now the method Install has a new mandatory parameter:

  • IsGmsaAccount: a boolean that will define whether or not we will use Group Managed Service Accounts

Now the method parameters will be:

  • System.Management.ManagementBaseObject Install(System.String Logon, System.String Password, System.Boolean GrantLogOnAsService, System.Boolean IsGmsaAccount)
    • Logon: String containing the logon information used by the host instance;
    • Password: String containing the password for the host.
    • GrantLogOnAsService: Boolean determining whether the ‘Log On As Service’ privilege should be automatically granted to the specified logon user or not. This flag only has effect when the HostType property is set to In-process.
    • IsGmsaAccount: a boolean that will define whether or not we will use Group Managed Service Accounts
      • If true, the password can be empty;

The second reason is related to the first one. Now BizTalk Server 2020 has support Group Managed Service Accounts (gMSA) and since I’m changing this script I also want to add support to this feature.

What is Host and a Host Instances?

The BizTalk Host is a logical process and security boundary within BizTalk Server that represents a logical set of zero or more run-time processes in which you can deploy BizTalk Server services and artifacts (such as adapter handlers, receive locations, and orchestrations). Each host has a security group assigned to it and may contain multiple host instances, each on an individual machine, that perform the work of the host.

In another hand, a host instance is the physical instance of a host on a computer running BizTalk Server. Each host instance belongs to exactly one host, and the service account of the host instance belongs to the security group of the host. The security group may be used to grant permissions to physical resources such as databases for use by any host instances in the host.

What is an Adapter Handler?

An adapter handler is an instance of a BizTalk host in which the adapter code runs. When you specify a send or receive handler for an adapter you are specifying which host instance the adapter code will run in the context of. An adapter handler is responsible for executing the adapter and contains properties for a specific instance of an adapter.

The default BizTalk Server configuration will only create one in-process host, “BizTalkServerApplication”, that will be associated as a receive and send adapter handler for all of the installed adapters, with the exception of HTTP, SOAP, WCF-BasicHttp, WCF-WSHttp, and WCF-CustomIsolated adapter receive handlers that can only be running in an isolated host.

How can I automate this task?

Windows PowerShell is a Windows command-line shell designed especially for system administrators and can be used by BizTalk administrators to help them in automating tasks.

This is a simple script that will configure the following components in your environment:

  • Create Host and Host Instance according to some of the best practices: two Receive host and host instances (one 32-bits and one 64-bits); two Send host and host instances (one 32-bits and one 64-bits); One Host and Host Instance to process Orchestrations and one Host and Host Instance for tracking;
  • Create Receive and Send Handlers for each adapter;
  • And finally, associate the correct Receive and Send Handlers to each existing receive and send ports present in your environment

Download

THIS POWERSHELL IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND.

The script can be found and download on GitHub:

PowerShell to Configure BizTalk Server 2020 Host, Host Instances and HandlersPowerShell to Configure BizTalk Server 2020 Host, Host Instances and Handlers
GitHub

The post BizTalk Server 2020: PowerShell to Configure Host, Host Instances and Adapter handlers according to some of the Best Practices appeared first on SANDRO PEREIRA BIZTALK BLOG.

June 29, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

June 29, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

Do you feel difficult to keep up to date on all the frequent updates and announcements in the Microsoft Integration platform and Azure iPaaS?

Integration weekly update can be your solution. It’s a weekly update on the topics related to Integration – enterprise integration, robust & scalable messaging capabilities and Citizen Integration capabilities empowered by Microsoft platform to deliver value to the business.

 

Microsoft Announcements and Updates

 

Community Blog Posts

 

Video

 

Podcasts

 

How to get started with iPaaS design & development in Azure?

Feedback

Hope this would be helpful. Please feel free to reach out to me with your feedback and questions.

BizTalk Server 2020 – Send Tracking Data to Azure

BizTalk Server 2020 – Send Tracking Data to Azure

Microsoft has released BizTalk Server 2020 with a bunch of exciting new features.

To know more about the stirring features, look at our series of blogs

In this blog article, I will be covering an exciting new feature on how to send the BizTalk tracking data to Azure Event Hub and Application Insight.

You have configured various tracking options for orchestrations, send ports, receive ports, and pipelines using the BizTalk Server Administration console.

Follow the below Steps to Send the Tracking Data to Azure

As we know, if we enabled the tracking on the artifacts carefully, it gives us very helpful information to diagnose the issues without affecting performance. The same applies to enable analytics. It is very important that you plan as per your information needs but also for your performance needs.

Enable Analytics at the Environment Level

Enable group-level analytics by selecting BizTalk group settings. Select “Enable group-level analytics” and choose the target where you wish to push the data, either Application Insights or Event Hub, as you can see below.

Enable Analytics at environment level

Enable Analytics at Artifact Level

  • Right-click on the artifacts (Sendport, Receive Location, Orchestrations) and enable tracking
  • To start transmitting the tracking data to Azure, enable Analytics as below
  • Enable Analytics at artifact level

Sending Your Tracking Data to Application Insights

Azure Applications Insights is a very popular Application Performance Management service, especially for web developers. It helps the developers to find performance issues with their applications and diagnose them. 

  • Sign in to the Azure portal, and create an Application Insights resource
  • Send BizTalk tracking data to Application Insights

  • In the BizTalk group settings, select the target type as “Application Insights”
  • Sign in to Azure portal and select the subscription to update Analytics -Application Insights details as shown below
  • Analytics-Application Insights

Sending your tracking data to Event Hubs

  • Sign in to the Azure portal, and create an event hub namespace
  • In BizTalk group settings, select the target type as “Event Hub ”
  • Sign in to Azure portal and select the subscription to update Analytics -Event Hub connection details as below
  • Send BizTalk tracking data to Event hubs

Once it’s done, you can view the data in the event log capture or you can configure the receive location with the Event Hub adapter and route it to the desired location. Since Event Hub capture is the easiest way to load/process streaming data into Azure, you can send/receive large volumes of messages between BizTalk Server and Azure Event Hubs using the Event Hub Adapter.

For instance, you can save and process all your tracking data in an Event Hub using the EventHub Adapter.

  • You can configure the EventHub Adapter in a Receive Location to receive a message from Event Hubs. Configure the namespace and EventHub details as shown below. The publisher/subscriber can connect to the Event Hub by using a shared access signature token.
  • Event Hub Transport properties

  • Create a Send Port which listens to this Receive Location. The tracking data received from Eventhub will be similar to what is shown below.
  • code

Azure has solid data visualization offerings such as Power BI and the OMS portal. You can publish tracking data to Power BI and start visualizing data https://docs.microsoft.com/en-us/biztalk/core/configure-the-operational-data-feed-for-power-bi-with-biztalk-server.

Conclusion

BizTalk360 is now compatible with BizTalk Server 2020. Why not give BizTalk360 a try! It takes about 10 minutes to install on your BizTalk environments and you can witness and check the security and productivity of your own BizTalk Environments.

The post BizTalk Server 2020 – Send Tracking Data to Azure appeared first on BizTalk360.

Another certificate exists with same thumbprint {0} at location {1} in the Resource Group {2}

Another certificate exists with same thumbprint {0} at location {1} in the Resource Group {2}

I was working on one of the API which needed using certificate (SSL) connectivity to the external API exposed by third-party. We stored this certificate in Key Vault and reference it to azure app services (Web API). I used arm template to add Certificate (.pfx) from Azure KeyVault in the TLS/SSL settings of Web APP Service.

Below is the Arm Template to get the Certificate from Key Vault and deploy the Web APP in the Application Services Environment (ASE).

{
  "$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "appServiceName": {
      "type": "string"
    },
    "storageAccountName": {
      "type": "string",
      "metadata": {
        "description": "Storage Account name"
      }
    },
    "appServicePlanResourceGroup": {
      "type": "string",
      "metadata": {
        "description": "Azure service plan resource group"
      }
    },
    "appServicePlanName": {
      "type": "string",
      "metadata": {
        "description": "Azure Service Plan name"
      }
    },
    "applicationInsightsName": {
      "type": "string",
      "metadata": {
        "description": "The name of the app insights instance for the workload"
      }
    },
    "keyVaultName": {
      "type": "string"
    },
    "keyVaultResourceGroup": {
      "type": "string"
    },
    "BaseUrl": {
      "type": "string"
    },
    "CertkeyVaultSecretName": {
      "type": "string"
    }
  },
  "variables": {
    "applicationInsights": {
      "apiVersion": "2015-05-01",
      "name": "[parameters('applicationInsightsName')]"
    },
    "keyVault": {
      "apiVersion": "2015-06-01",
      "name": "[parameters('keyVaultName')]",
      "resourceId": "[resourceId(parameters('keyVaultResourceGroup'), 'Microsoft.KeyVault/vaults', parameters('keyVaultName'))]"
    }
  },
  "resources": [
    {
      "apiVersion": "2015-08-01",
      "name": "[parameters('appServiceName')]",
      "type": "Microsoft.Web/sites",
      "location": "[resourceGroup().location]",
      "tags": {
        "displayName": "Website"
      },
      "identity": {
        "type": "SystemAssigned"
      },
      "dependsOn": [
        "Microsoft.Web/certificates/CertificateName"
      ],
      "properties": {
        "name": "[parameters('appServiceName')]",
        "serverFarmId": "[resourceId(parameters('appServicePlanResourceGroup'), 'Microsoft.Web/serverfarms', parameters('appServicePlanName'))]",
        "siteConfig": {
          "use32BitWorkerProcess": false,
          "alwaysOn": true,
          "ftpsState": "FtpsOnly"
        },
        "httpsOnly": true
      },
      "resources": [
        {
          "name": "appsettings",
          "type": "config",
          "apiVersion": "2015-08-01",
          "dependsOn": [
            "[resourceId('Microsoft.Web/sites', parameters('appServiceName'))]"
          ],
          "properties": {
            "ApplicationInsights:InstrumentationKey": "[reference(resourceId(resourceGroup().Name, 'Microsoft.Insights/components', variables('applicationInsights').name), variables('applicationInsights').apiVersion).InstrumentationKey]",
            "Web:BaseAddress": "[parameters('BaseUrl')]",
            "Web:ClientCertificateThumbprint": "[reference(resourceId(resourceGroup().Name, 'Microsoft.Web/certificates','CertificateName'), '2016-03-01').thumbprint]",
            "WEBSITE_LOAD_CERTIFICATES": "*"
           
          }
        }
      ]
    },
    {
      "type": "Microsoft.Web/certificates",
      "name": "CertificateName",
      "apiVersion": "2016-03-01",
      "location": "[resourceGroup().location]",
      "properties": {
        "keyVaultId": "[variables('keyVault').resourceId]",
        "keyVaultSecretName": "[parameters('CertkeyVaultSecretName')]",
        "serverFarmId": "[resourceId(parameters('appServicePlanResourceGroup'), 'Microsoft.Web/serverfarms', parameters('appServicePlanName'))]"
      }
    },
    {
      "apiVersion": "2014-04-01",
      "name": "[parameters('applicationInsightsName')]",
      "type": "Microsoft.Insights/components",
      "location": "[resourceGroup().location]",
      "dependsOn": [
        "[resourceId('Microsoft.Web/sites/', parameters('appServiceName'))]"
      ],
      "tags": {
        "[concat('hidden-link:', resourceGroup().id, '/providers/Microsoft.Web/sites/', parameters('appServiceName'))]": "Resource",
        "displayName": "AppInsightsComponent"
      },
      "properties": {
        "applicationId": "[parameters('appServiceName')]"
      }
    }
  ]
}

When this deployment run on Azure Portal, it error out with the following error message.

Status Message: {“Code”:”Conflict”,”Message”:”Another certificate exists with same thumbprint xxxxxxxxxxxxxxxxxxxxxxxxxxxx at location Australia East in the Resource Group RG-AE-Dev.”,”Target”:null,”Details”:[{“Message”:”Another certificate exists with same thumbprint xxxxxxxxxxxxxxxxxxxxxxxxxxxx at location Australia East in the Resource Group RG-AE-Dev.”},{“Code”:”Conflict”},{“ErrorEntity”:{“ExtendedCode”:”53008″,”MessageTemplate”:”Another certificate exists with same thumbprint {0} at location {1} in the Resource Group {2}.”,”Parameters”:[“xxxxxxxxxxxxxxxxxxxxxxxxxxxx”,”Australia East”,”RG-AE-Dev”],”Code”:”Conflict”,”Message”:”Another certificate exists with same thumbprint xxxxxxxxxxxxxxxxxxxxxxxxxxxx at location Australia East in the Resource Group RG-AE-Dev.”}}],”Innererror”:null}

I couldn’t find any other certificate in the key vault with the same thumb print, Then I ran the below Powershell command to find all the certificate included in the Resource Group.

# Change these to your appropriave values
$SubscriptionId = "xxxxxxxxxxxxxxxxxxxxxxxxxxxx"
$ResourceLocation = "Australia East"
$ResourceGroupName = "RG-AE-Dev"
$ResourceName = "CertificateName"
$KeyVaultName = "AZ-KeyVault"
$KeyVaultId = "/subscriptions/xxxxxxxxxxxxxxxxxxxxxxxxxxxx/resourceGroups/RG-AE-ICC-Dev/providers/Microsoft.KeyVault/vaults/AZ-KeyVault"
$KeyVaultSecretName = "certificatesecret"
$ServerFarmId = "/subscriptions/xxxxxxxxxxxxxxxxxxxxxxxxxxxx/resourceGroups/RG-AE-Dev/providers/Microsoft.Web/serverfarms/AustraliaEastPlan"
# Log in and select the correct subscription
Login-AzureRmAccount 
Set-AzureRmContext -SubscriptionId $SubscriptionId 
$ResourceLocation -PropertyObject $PropertiesObject -ResourceGroupName $ResourceGroupName -ResourceType Microsoft.Web/certificates -ApiVersion 2018-02-01 -Force
# List certificates
 Get-AzureRmResource -ResourceGroupName $ResourceGroupName -ResourceType Microsoft.Web/certificates -IsCollection -ApiVersion 2018-02-01

This Powershell command list down all the certificates, and I found that the same certificate is installed with the different name, thus the same Thumb Print.

Then I navigated to the Resources.Azure.com -> Subscriptions -> resourceGroups->providers->Microsoft.Web->certificates

I found this certificate with the different name, I needed to remove it using actions (DELETE) . Re-run the deployment and yes all success now.

Thanks

June 22, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

June 22, 2020 Weekly Update on Microsoft Integration Platform & Azure iPaaS

Do you feel difficult to keep up to date on all the frequent updates and announcements in the Microsoft Integration platform and Azure iPaaS?

Integration weekly update can be your solution. It’s a weekly update on the topics related to Integration – enterprise integration, robust & scalable messaging capabilities and Citizen Integration capabilities empowered by Microsoft platform to deliver value to the business.

 

Microsoft Announcements and Updates

 

Community Blog Posts

 

Video

 

Podcasts

 

How to get started with iPaaS design & development in Azure?

Feedback

Hope this would be helpful. Please feel free to reach out to me with your feedback and questions.

Webinar Spoiler: Discover How to Track Your Hybrid Business Transactions in a Smarter Way

Webinar Spoiler: Discover How to Track Your Hybrid Business Transactions in a Smarter Way

In Atomic Scope, the Tracking screen is where you get an overview of your business transactions involving Microsoft BizTalk Server and Azure resources that are tracked by the product. Here, you can learn whether all your on-premise and/or hybrid transactions are being processed successfully and view these transactions in every detail.

In our next Atomic Scope webinar, we will be doing a deep dive into the capabilities of the Tracking screen of the product. Among other things, we will show

  • How to search for specific transactions
  • View all the details of executed transactions
  • How Atomic Scope supports batched messages
  • What can be done in case something went wrong?

Also, the webinar attendees will get a special sneak-peek on the new features from Atomic Scope v7, which will just have been released at the time of the webinar. These features include

  • Graphical Business Process Designer – A new and more powerful way to define the workflows of your respective business process transactions
  • Dynamic Email Template Engine – Create flexible and rich email templates to send informative email alerts

If you want to want to have complete insight into your business processes in one portal, then this webinar is for you. We look forward to meeting you during the webinar!

The webinar will take place at:

Date: Thursday, June 25th

Time: 10 AM BST

Save your Spot!

So, if you want to want to have complete insight into your business processes in one portal, then this webinar is for you. The registration process is very simple. Just click here to register and leave your details. Shortly we will send you the confirmation mail. We look forward to meeting you during the webinar!

Also, if you think you cannot attend the webinar at the specified time, no worries! Go ahead and register, our team will make sure to send you the webinar recording.

Also, if you wish to know more about the webinar, feel free to check out the web site!

The post Webinar Spoiler: Discover How to Track Your Hybrid Business Transactions in a Smarter Way appeared first on BizTalk360.