Recent Posts


Using KingswaySoft Azure Blob Storage component with Dynamics 365

KingswaySoft provides 3 components specific to Azure Blog Storage Azure Blob Connection Manager Azure Blob Storage Source Azure Blob Storage Destination Check other blog posts on SSIS https://nishantrana.me/2020/10/16/ssis-kingswaysoft-and-dynamics-365/ Let us take a simple example where we are extracting \ reading contact data from Dynamics 365 \ CDS and saving it as a text file in … Continue reading “Using KingswaySoft Azure Blob Storage component with Dynamics 365”

Connect to Dynamics 365 through Script Component – SSIS

For complex data migration requirements, usually we’d be using 3rd party tools like KingswaySoft or Scribe, or Informatica as they already have components (connection, transformation, source, destination etc.) built for Dynamics 365 instead of building our own. Check other posts on data migration https://nishantrana.me/2020/10/16/ssis-kingswaysoft-and-dynamics-365/ https://nishantrana.me/2020/05/19/data-migration-in-dynamics-365-key-considerations/ For some simple / basic requirements instead of using 3rd … Continue reading “Connect to Dynamics 365 through Script Component – SSIS”

Fixed – Unable to Login to Dynamics CRM or An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail

We might get below error while trying to consume Organization Service through the client application Unable to Login to Dynamics CRM An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail. Chances are the Security Defaults are enabled on the account you are … Continue reading “Fixed – Unable to Login to Dynamics CRM or An unsecured or incorrectly secured fault was received from the other party. See the inner FaultException for the fault code and detail”

Fixed – There was an error calculating dependency for this component. Missing component id error while trying to import a solution in Dynamics 365

We got the below error while trying to import the solution. The error indicates that either the component with the specified GUID in the error message is either missing in the solution or is missing in the target environment. Search for the GUID either in the customization.xml or solutions.xml to find the component. Add the … Continue reading “Fixed – There was an error calculating dependency for this component. Missing component id error while trying to import a solution in Dynamics 365”

Object reference not set to an instance of an object error while calling an Action in Dynamics 365

Recently in one of our JavaScripts which was calling an action (with a plugin registered to it) was giving us the below error. We had a plugin registered on the call of that action, which in turn was calling an external service. We figured out the probable cause of this error (related to certificates) and … Continue reading “Object reference not set to an instance of an object error while calling an Action in Dynamics 365”

Fixed – Column names in each table must be unique. Column name ‘x’ in table ‘y’ is specified more than once while importing solution in Dynamics 365

Recently while trying to import the solution we got the below error. Below was the outcome of our analysis The column or the field referred to in the error message was not available in the CRM application i.e. customizations – default solution was not having this attribute. The column was only available in the base … Continue reading “Fixed – Column names in each table must be unique. Column name ‘x’ in table ‘y’ is specified more than once while importing solution in Dynamics 365”

Pause and resume enhancements in SLA in Dynamics 365 – 2020 Release Wave 2

The way we currently configure Pause and Resume for an SLA is by setting the Allow Pause and Resume field to Allow. And within the Service Tab of System Settings, we can define the status values on which the SLA calculation should get paused at the entity level. So basically, the SLA will be paused … Continue reading “Pause and resume enhancements in SLA in Dynamics 365 – 2020 Release Wave 2”

PowerAutomate: Perform “Group By” operation on Data

Originally posted on Ajit Patra:
In this post, we’ll see how we can perform aggregate function on data such as Sum or Count using PowerAutomate. Unlike LINQ in C# or SQL, it’s not very straight forward to do using PowerAutomate for which I thought of sharing the approach we had taken. Recently, we got a…

Error – Please unblock each locked file or unlock XrmToolBox.zip before extracting its content

We were getting the below error while trying to run the XrmToolBox. “One reason can be that at least one file is locked by Windows. Please unblock each locked files or unlock XrmToolBox.zip before extracting its content” The resolution in our case was to reset the XrmToolBox installation i.e. deleting the content of C:\users\appData\[loginname]\roaming\MsCrmTools\XrmToolBox Get … Continue reading “Error – Please unblock each locked file or unlock XrmToolBox.zip before extracting its content”

Azure Architecture and Management – Introduction

Below are few key points on Azure architecture and management Check availability of Azure products region-wise https://azure.microsoft.com/en-us/global-infrastructure/services/ Below we have filtered it to see products available in UAE We can also filter it further if we are looking for a specific product or service. We can refer to the Data residency document to see where … Continue reading “Azure Architecture and Management – Introduction”

Displaying SharePoint RichText field as HTML interpreted in SSRS

Originally posted on HowCanIHelpYou?:
SSRS Reports have a placeholder property HTML – Interpret HTML tags as styles. That property allows you to use HTML tags while displaying report. We have to face the problem when we want to display SharePoint`s RichText field content is SSRS Report. RichText field may contain some characters that are stored different in SharePoint…

Microsoft Azure / Cloud Computing – Introduction

Cloud Computing enables companies to consume a complete resource – such as virtual machine, storage, or an application as a utility – just like electricity – rather than having to build and maintain computing infrastructure in-house. Cloud provider provides the cloud infrastructure which is shared across multiple clients. Clients can select which service to use … Continue reading “Microsoft Azure / Cloud Computing – Introduction”

Use custom browser protocol to launch desktop applications from Dynamics 365

Recently we had a requirement to launch a .NET desktop application installed in the user’s machine from within Dynamics 365 and also pass parameters to it. One of the ways of implementing is by using the Custom URL Protocol. Modern browsers and operating systems allow us to implement a custom URL protocol and register an … Continue reading “Use custom browser protocol to launch desktop applications from Dynamics 365”

App Switcher, Back option and other changes in Dynamics 365 – 2020 Release Wave 2

Below are some of the updates in the product as part of 2020 Release Wave 2. To switch between the Dynamics 365 Apps, we need to click on down arrow icon next to Dynamics 365. With 2020 Release Wave 2, we can click on the app name i.e. which opens up the pop-up windows listing … Continue reading “App Switcher, Back option and other changes in Dynamics 365 – 2020 Release Wave 2”

Queue Item details change in Dynamics 365 – 2020 Release Wave 2

Queue Item details for a Queue Item earlier used to open in a new window. Thus losing the context 2020 Release Wave 2 provides an immersive experience for the agents, as the queue item details open in the context of the parent window. Small but nice update for the agents. Check other blog posts on Release … Continue reading “Queue Item details change in Dynamics 365 – 2020 Release Wave 2”

Using SQL Server Management Studio to deploy and run SSIS package in Azure Data Factory

In our previous post, we created the SSIS Catalog (SSISDB) in Azure and deployed the SSIS package using SSDT. Supported version for SSDT – SQL Server Data Tools to deploy SSIS package to Azure. For Visual Studio 2017, version 15.3 or later. For Visual Studio 2015, version 17.2 or later. In this post, we’d use … Continue reading “Using SQL Server Management Studio to deploy and run SSIS package in Azure Data Factory”

Deploy and run SSIS Integration Toolkit for Dynamics 365 on Azure Data Lake (KingswaySoft)

In the previous post, we saw how to deploy and run SSIS packages on the cloud. Here we take it one step further and will deploy and run the SSIS packages that use KingswaySoft’ s SSIS Integration Toolkit components. Here we will need an Azure Subscription, where we will host the SSISDB, followed by provisioning … Continue reading “Deploy and run SSIS Integration Toolkit for Dynamics 365 on Azure Data Lake (KingswaySoft)”

D365 CE: Get Logged in User’s Security Roles using JavaScript

Originally posted on Ajit Patra:
Many times we come across requirements such as show/hide ribbon buttons based on logged in user’s security role. Earlier, we used to get security roles of logged in user at client side using Xrm.Utility.getGlobalContext().userSettings.securityRoles which used to return array of GUID value of each security role. Now that it’s deprecated,…

Use Azure Data Factory V2 to load data into Dynamics 365

Let us take a simple example where we will set up an Azure Data Factory instance and use Copy data activity to move data from the Azure SQL database to Dynamics 365. Login to Azure Portal. https://portal.azure.com Search for Data factories Create a new data factory instance Once the deployment is successful, click on Go … Continue reading “Use Azure Data Factory V2 to load data into Dynamics 365”

Failed to get response from server error while trying to connect to Dynamics 365 using linked services – Azure Data Factory

Recently, while trying to connect to Dynamics 365 data set through Linked Service we got the below error Seems like a product issue, so the workaround is Opening Azure Data Factory in a new incognito or in-private mode. Or Cancel and do not select the certificate, while testing the connection. Ignoring the certificate fixed the … Continue reading “Failed to get response from server error while trying to connect to Dynamics 365 using linked services – Azure Data Factory”

Error – We don’t support the option ‘HierarchicalNavigation’. Parameter name: HierarchicalNavigation when trying to load table in Power BI Desktop using Azure Data Lake Storage Gen 2 CDM Folder view (beta)

While trying to connect to a table within Azure Data Lake Storage Gen2 through CDS Folder View we got the below error Users have reported this issue with the August 2020 Update of Power BI Desktop. As suggested in the forums, downgrading to June 2020 Update fixed the issue for us. Check out Export CDS data … Continue reading “Error – We don’t support the option ‘HierarchicalNavigation’. Parameter name: HierarchicalNavigation when trying to load table in Power BI Desktop using Azure Data Lake Storage Gen 2 CDM Folder view (beta)”

Loading…

Something went wrong. Please refresh the page and/or try again.

Advertisements

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

One thought on “Recent Posts”

Please share your thoughts

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.