CheckPrivilege failed while importing solution in Dynamics 365 CE – Nishant Rana’s Weblog
Dec12

CheckPrivilege failed while importing solution in Dynamics 365 CE – Nishant Rana’s Weblog

Recently after upgrade of our Dynamics 365 CE from 8.2 to 9.1, when the System Administrator tried importing the solution (managed), he got the below error You do not have the necessary privileges to import security roles. : Microsoft.Crm.CrmSecurityException: SecLib::CheckPrivilege failed. User: e7282250-7d82-e711-80df-1458d0431690, PrivilegeName: prvWriteRole, PrivilegeId: bd123e14-17ba-40f6-8d8b-18f4bffa7e50, Required The error...

Read More
The workflow cannot be published or unpublished by someone who is not its owner error while importing solution in Dynamics 365 CE
Dec11

The workflow cannot be published or unpublished by someone who is not its owner error while importing solution in Dynamics 365 CE

Recently after upgrade of our Dynamics 365 CE from 8.2 to 9.1, when the System Administrator tried importing the solution (managed), he got the below error The workflow cannot be published or unpublished by someone who is not its owner. Error while importing workflow {ec05f40d-fd14-46ab-96b3-be1f5b108ef3} type Workflow name Marketing List – Update CT Relationship: The workflow cannot be published or unpublished by someone who is not...

Read More
You don’t have permission to access any of the organizations in the Microsoft Dynamics CRM Online region that you specified error in USD Client Application
Dec10

You don’t have permission to access any of the organizations in the Microsoft Dynamics CRM Online region that you specified error in USD Client Application

Recently after upgrade to version 9.1 and USD 4.0, some of the users started getting the below error while trying to login into the USD Client Application. You don’t have permission to access any of the organizations in the Microsoft Dynamics CRM Online region that you specified. If you’re not sure which region your organization resides in, choose “Don’t know” for the CRM region and try again. Otherwise check with your CRM...

Read More
Merged vs. Child Cases – Nishant Rana’s Weblog
Dec03

Merged vs. Child Cases – Nishant Rana’s Weblog

We will go back to the basics and see one of the basic features of case entity which is confusing at times to the beginners, Merged Case vs. Child Case. What are they? Why and when to use them? Merge Case: What is Merged Case? When a case is merged, the state of the case is changed to cancelled, and the status is changed to merged. All of the open case activities, emails, and attachments that a case has are now associated with the...

Read More
CrmRecordId and IsNew Output in CRM/CDS Destination Component – Nishant Rana’s Weblog
Dec02

CrmRecordId and IsNew Output in CRM/CDS Destination Component – Nishant Rana’s Weblog

In CRM/CDS Destination Component of SSIS Integration toolkit we can found 2 output column as part of error handling In case of Create CrmRecordId will have the GUID of the newly created record, which could be used for any further processing IsNew will list whether this is a new record or not. Our package: – Suppose we have the following record in our source (here ID is the alternate key column used for Upsert) If all the records are...

Read More
[D365 CE Online] Debug Async Plug-in using “Persist to Entity” profiler option – Nishant Rana’s Weblog
Dec01

[D365 CE Online] Debug Async Plug-in using “Persist to Entity” profiler option – Nishant Rana’s Weblog

As you are aware, using Plug-in Profiler option we can debug D365 online plug-ins by throwing exception and capturing the Serilaized profile. Refer my previous article With the ‘Exception’ profiling option, you first need to trigger the event and capture the exception log. For example, if you need to debug “Post Account Create” plug-in, you first need to trigger the event (i.e., Create Account from D365 application) and capture the...

Read More
Unexpected error (SQL Timeout error) while trying to delete Audit Log – Nishant Rana’s Weblog
Nov30

Unexpected error (SQL Timeout error) while trying to delete Audit Log – Nishant Rana’s Weblog

Unexpected error (SQL Timeout error) while trying to delete Audit Log We had around 200 GB of Audit Log data in our Production Environment, but while trying to delete it through Audit Log Management resulted into unexpected error. The only option is to raise the support ticket with Microsoft. We also raised the same but it unfortunately resulted in our Production Server being down for brief period of time because of time out issue...

Read More
How To Access Master & Duplicate Record In Merge Operation Plugin – Nishant Rana’s Weblog
Nov29

How To Access Master & Duplicate Record In Merge Operation Plugin – Nishant Rana’s Weblog

Here is a quick blog on how to access master & child records during a Merge operation in a plugin. I recently had to develop a plugin where in I needed to do some manipulation with the records being merged. You can access three entities in your plugin when a record is merged from Context.InputParameter :         1. SubordinateId – the duplicate record       2. Target – the master record       3. UpdateContent   – a temp entity...

Read More
Requesting the backup of Microsoft Dynamics 365 Online Database – Nishant Rana’s Weblog
Nov28

Requesting the backup of Microsoft Dynamics 365 Online Database – Nishant Rana’s Weblog

In theory, requesting the backup of the online database seems very easy and straightforward. We basically need to raise a support ticket with Microsoft and provide the following details. SQL Version – Standard or Enterprise SQL Year of the version. In our case it was (Microsoft SQL Server 2016 (SP1) (KB3182545) – 13.0.4001.0 (X64) Oct 28 2016 18:17:30 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016...

Read More
Execute Stored Procedure using Azure Data Factory – Nishant Rana’s Weblog
Nov27

Execute Stored Procedure using Azure Data Factory – Nishant Rana’s Weblog

In this blog post, we’ll see how to execute Stored Procedure in Azure SQL Database inside Azure SQL Server. Let’s go through the steps to see it in action. Login to Azure Portal. Click Create a resource –> Databases –> SQL Database. Give a unique name to the Azure SQL Database. Click on Server field to create Azure SQL Server on the fly.  Give a unique name to the Azure SQL Server, provide credential for login and click Select....

Read More
SSIS and Microsoft Dynamics 365
Nov26

SSIS and Microsoft Dynamics 365

Listing down the posts on SSIS and Microsoft Dynamics 365 for quick reference Using Lookup Transformation and Cache Transformation in SSIS for Dynamics 365 (using Kingswaysoft) View Designer not showing SSIS Package in Design mode in Visual Studio Lookup not getting set while using CRM Destination Component of KingswaySoft’s SSIS Integration Toolkit for Dynamics 365 … Continue reading “SSIS and Microsoft...

Read More
Using Azure Bot Service to create Bot – Nishant Rana’s Weblog
Nov25

Using Azure Bot Service to create Bot – Nishant Rana’s Weblog

Using Microsoft Bot Framework Azure Bot Service is an integrated environment that allow us to easily register, build, deploy our bots. It provides the required components and hosting environment for creating bots through Bot Builder SDK using either C# or JavaScript and connector service to connect to various channels. Login to Azure Portal. Microsoft Azure No Description Search for Web App Bot We have selected Basic Bot template....

Read More
Power BI and Microsoft Dynamics 365
Nov24

Power BI and Microsoft Dynamics 365

Listing down the posts on Power BI and Microsoft Dynamics 365 for quick reference Power BI with Dynamics 365 CE – Creating Power BI Report Power BI with Dynamics 365 CE – Publishing Power BI Report to the web Power BI with Dynamics 365 CE – Refreshing the Dataset Power BI with Dynamics 365 CE – Dynamics 365 … Continue reading “Power BI and Microsoft Dynamics 365” Continue Reading Nishant Rana’s Article on...

Read More
Copy Data from D365 CE to Azure SQL Database using Azure Data Factory – Nishant Rana’s Weblog
Nov23

Copy Data from D365 CE to Azure SQL Database using Azure Data Factory – Nishant Rana’s Weblog

In this blog post, we’ll see how to copy data of an entity “Contact” in D365 CE to Azure SQL Database. Let’s follow the below steps to see it in action. Login to Azure portal. Create Azure SQL Database where we need to copy the data. Click Create a resource –> Databases –>  SQL Database Give a unique name to the database. Click on server field to create a Azure SQL Server. Give a unique name to the Azure SQL server, username and...

Read More
Above and Under operator to query hierarchical data in Dynamics 365 – Nishant Rana’s Weblog
Nov22

Above and Under operator to query hierarchical data in Dynamics 365 – Nishant Rana’s Weblog

above and under were the 2 new operators introduced with Dynamic CRM 2015. Let us see some of the examples. Suppose I have the following hierarchy defined, wherein User 2 is manager of user Nishant Rana who in turn is manager of User 1. And following are the contacts record owned by them. In context of user Nishant Rana, if I apply Under operator, we’d get the following result Only the records owned by child And for Not Under All the...

Read More
A quick find filter cannot have any child filters exception in Dynamics 365 CE – Nishant Rana’s Weblog
Nov21

A quick find filter cannot have any child filters exception in Dynamics 365 CE – Nishant Rana’s Weblog

Today afternoon we started getting the below error in the lookup dialog box for customer and contact. Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: A quick find filter cannot have any child filtersDetail: <OrganizationServiceFault...

Read More
Getting logged in user roles in client side in Dynamics V9.0 – Nishant Rana’s Weblog
Nov20

Getting logged in user roles in client side in Dynamics V9.0 – Nishant Rana’s Weblog

You may be asking? Why this mundane post? After all we have been here close to 8 years since 2011 released and we have millions of time retrieved it using So what’s the fuss in it? So if you are working on CRM version below 9.0, then it’s no fuss. But if you are working on V9.0 and above, may be this is an interesting read for you. Xrm.Page is deprecated. So what’s the other way. Well you need to do it the V9.0 way. Below is the code...

Read More
Sample code to delete instance using Online Management API in Dynamics 365 Customer Engagement – Nishant Rana’s Weblog
Nov19

Sample code to delete instance using Online Management API in Dynamics 365 Customer Engagement – Nishant Rana’s Weblog

Sharing a sample code that can be used to delete the instance in Dynamics 365 CE using Online Admin API. Read the previous post for more details We basically need to get the instace id and use the HTTP Delete to achieve this Instances – Delete Instance (Dynamics 365 Online Management API Reference) Deletes a Customer Engagement instance in your Office 365 tenant. For a list of region-specific service URLs, see Service URL...

Read More
Sample Code to retrieve instances using Online Management API in Dynamics 365 Customer Engagement – Nishant Rana’s Weblog
Nov18

Sample Code to retrieve instances using Online Management API in Dynamics 365 Customer Engagement – Nishant Rana’s Weblog

With version 9.0 of Dynamics 365 CE we now have Online Admin API that supports the following operations like Create, Retrieve, Delete, Backup and Restore instances. The user needs to have the Global Administrator or Service Administrator role in the Office 365 tenant to perform these operations. As a first step we need to register the application with Azure Active Directory. Register a Dynamics 365 app with Azure Active Directory Sign...

Read More
The user or administrator has not consented to use the application error in Dynamics 365 CE – Nishant Rana’s Weblog
Nov17

The user or administrator has not consented to use the application error in Dynamics 365 CE – Nishant Rana’s Weblog

Suppose, we have just registered an application in Azure Active Directory and trying to acquire the token and get the below error Microsoft.IdentityModel.Clients.ActiveDirectory.AdalServiceException: ‘AADSTS65001: The user or administrator has not consented to use the application with ID ‘b2c5028d-57e6-4df7-9940-828e6914948b’ named ‘MyApp’. Send an interactive authorization request for this user and resource. This is because admin...

Read More
Execute SSIS Package using Azure Data Factory – Part 2 – Nishant Rana’s Weblog
Nov16

Execute SSIS Package using Azure Data Factory – Part 2 – Nishant Rana’s Weblog

In the previous post, we created the required Azure resources. In the last step of the previous post, we created Azure SSIS IR which is basically responsible for creating SSISDB in the Azure SQL Server where we’ll deploy the SSIS package. In this demo, we are going to execute a SSIS package which will load the data from source table ([SalesLT].[Customer]) to the destination table([dbo].[Customer]). So, let’s create the Customer table...

Read More
Sample code to use RetrievePrincipalAccess Function to get the access rights of the team or user in Dynamics 365 CE – Nishant Rana’s Weblog
Nov15

Sample code to use RetrievePrincipalAccess Function to get the access rights of the team or user in Dynamics 365 CE – Nishant Rana’s Weblog

We can use RetrievePrincipalAccess function in Web API to get the access rights of either a user or team on a specific record. The sample code: var req = new XMLHttpRequest(); req.open(“GET”, Xrm.Page.context.getClientUrl() + “/api/data/v9.1/systemusers(D38F5B76-C22E-4256-AF90-CFD14B6589BF)”+ “/Microsoft.Dynamics.CRM.RetrievePrincipalAccess(Target =@Target)?”+ “@Target={...

Read More
Limitations of Business Rule with Mobile App – Nishant Rana’s Weblog
Nov14

Limitations of Business Rule with Mobile App – Nishant Rana’s Weblog

One of our customer reported that couple of Business Rules are not working in Mobile app which are working perfectly in Web application. Spent so much time to understand the problem with Mobile app and finally figured out that one tab on the contact form is not loaded in mobile app because of maximum 5 tabs allowed limitations. Some fields that we are referring in the  business rules are part of this missing tab. So, business rule...

Read More
The following job steps cannot be reached with the current job step flow logic in SSIS – Nishant Rana’s Weblog
Nov12

The following job steps cannot be reached with the current job step flow logic in SSIS – Nishant Rana’s Weblog

Recently while scheduling our SSIS Packages in SQL Server Agent Jobs we got the below error WARNING: The following job steps cannot be reached with the current job step flow logic: [1] Fashion Spend package We just need to make sure that we have set correct package in the Start Step properties in Job Properties Dialog Box To: – Hope it helps.. Like this:Like Loading… Related Continue Reading Nishant Rana’s Article on their...

Read More
HideCustomAction and Display  Enable rule in Dynamics 365 – Nishant Rana’s Weblog
Nov12

HideCustomAction and Display Enable rule in Dynamics 365 – Nishant Rana’s Weblog

Imagine a scenario where we have both the disable rule and HideCustomAction implemented for a ribbon button. Let us see with an example what will happen in this scenario. First, let us implement the display rule to hide the Delete button from Contact form when it is in a disabled state. For active record à We can see the delete button in the command bar. For disabled record à The delete button is not visible. Now let us hide the...

Read More
Installation order for Solutions (Patches) in Dynamics 365 Customer Engagement – Nishant Rana’s Weblog
Nov11

Installation order for Solutions (Patches) in Dynamics 365 Customer Engagement – Nishant Rana’s Weblog

Let us take see a simple example of how the installation order of solution and patch works in case of Dynamics 365 CE. Suppose we have a Solution A with only Account Number field with display name renamed to Account Number from Solution A. Now this solution is exported as managed and imported into the target environment Now let us create a new solution which renames this field as “Account Number from Solution B” and then import this...

Read More
The following managed solution cannot be imported. The publisher name cannot be changed in Dynamics 365 CE – Nishant Rana’s Weblog
Nov09

The following managed solution cannot be imported. The publisher name cannot be changed in Dynamics 365 CE – Nishant Rana’s Weblog

We can change publisher of a solution using Publisher lookup field of the solution in the Information section. However, if the solution has already been imported in target environment, changing the publisher and trying to import the solution will result in the below error. Here we try renaming the publisher from “default..” to “sable37” No Title No Description One way of doing it is… Continue Reading Nishant Rana’s Article...

Read More
QuickFindQueryRecordLimit exceeded. Cannot perform this operation error in Dynamics 365 CE – Nishant Rana’s Weblog
Nov08

QuickFindQueryRecordLimit exceeded. Cannot perform this operation error in Dynamics 365 CE – Nishant Rana’s Weblog

We would get this below error if our search returns more than 10000 records for Quick Find Query. “There are more search results than can be displayed. Try adding more search terms (such as last name) to narrow your search results. If you contact support, please provide the technical details” We can fix it by setting Enable Quick Find record limits to No in System Settings à General tab. More details...

Read More
Access denied due to invalid subscription key error while using FaceServiceClient in Microsoft Cognitive Services – Nishant Rana’s Weblog
Nov07

Access denied due to invalid subscription key error while using FaceServiceClient in Microsoft Cognitive Services – Nishant Rana’s Weblog

Recently while working with Face API we were getting the below error To get it working we had to define apiRoot along with the subscriptionkey while initializing the FaceServiceClient object. Hope it helps.. Like this:Like Loading… Related Author Nishant RanaPosted on November 8, 2018November 6, 2018Categories AI, Machine LearningTags Artificial Intelligence, FaceAPI, Machine Learning, Microsoft Cognitive Service Continue...

Read More
SiteMapName in the AppModuleSiteMap is null or empty error while importing V9 Solution in Dynamics 365 Customer Engagement – Nishant Rana’s Weblog
Nov06

SiteMapName in the AppModuleSiteMap is null or empty error while importing V9 Solution in Dynamics 365 Customer Engagement – Nishant Rana’s Weblog

We recently upgraded our Dev and Test environment to V 9.0. Dev Test While importing a solution from Dev to Test which had SiteMap we got the below issue. “The SiteMapName in the AppModuleSiteMap is null or empty” It turns out that the following tags were required and were missing in the Customization.xml We added that tag and were able to import the solution successfully. Interestingly if we export the same solution from Test and...

Read More
Different Updating Instance status during Dynamics 365 Upgrade – Nishant Rana’s Weblog
Nov05

Different Updating Instance status during Dynamics 365 Upgrade – Nishant Rana’s Weblog

The day has come when we had scheduled the upgrade of our Dynamics 365 instance Test Instance(from 8.2 to 9.0). We can see the below message during the scheduled time à “The update will being within 24 hours. No rescheduling is available”. The following Reschedule Update option will go missing during the scheduled time. After waiting for few minutes, we see the Update Status as Queue (Not Started) Followed by the status as “Database...

Read More
Plugin on Pre-Validation Stage in Dynamics 365 CE – Nishant Rana’s Weblog
Nov05

Plugin on Pre-Validation Stage in Dynamics 365 CE – Nishant Rana’s Weblog

Recently we had a requirement to delete the Account record without deleting the associated Contact records. If we try deleting the account record we’d get the following message box The relationship definition can’t be updated as well to achieve this So, we wrote a plugin on the pre-validation stage of pre-delete event of Account, which will retrieve and loop through all the child contact records and set its parent customer field as...

Read More
Manage CDS Entity Data – Microsoft PowerApps Office Add-In – Nishant Rana’s Weblog
Nov04

Manage CDS Entity Data – Microsoft PowerApps Office Add-In – Nishant Rana’s Weblog

Microsoft PowerApps Office Add-In enables user to read, modify and insert data in CDS environment. Add-In is available for download here for free, or you will be prompted to install Add-In for first time when you open entity data in excel from PowerApps portal. Add-In establishes connection to PowerApps OData service. Note: Add-In is compatible with Office 2016 or later versions only. Using Microsoft PowerApps Office Add-In in excel...

Read More
Earned “Top 10 in October 2018 Blog Leaderboard” badge in Dynamics 365 Community – Nishant Rana’s Weblog
Nov03

Earned “Top 10 in October 2018 Blog Leaderboard” badge in Dynamics 365 Community – Nishant Rana’s Weblog

This month I was awarded the “Top 10 in October 2018 Blog Leaderboard” badge in Microsoft Dynamics Community. Nishant Rana’s Badges – Microsoft Dynamics Community No Description Thanks to all the readers and the subscribers of the blog. Check the below post as well. Earned “Top 10 in September 2018 Blog Leaderboard” badge in Dynamics 365 Community I have my blog syndicated to Dynamics 365 Community. We can...

Read More
Monitoring SSIS package Job Status – Nishant Rana’s Weblog
Nov02

Monitoring SSIS package Job Status – Nishant Rana’s Weblog

Suppose we have scheduled our packages through SQL Server Agent Job and we receive the notification that one of our packages has failed. To get its details, within SSISDB, we can check the Standard Reports like Integration Services Dashboard report, All Executions etc. to get the details. This will provide the information about the operation that have run or are currently executing. We can click on Failed record link to filter the...

Read More
PowerApps – New Functions Introduced – GUID, Concurrent & Notify – Nishant Rana’s Weblog
Nov01

PowerApps – New Functions Introduced – GUID, Concurrent & Notify – Nishant Rana’s Weblog

Microsoft has released many new features and enhancements for PowerApps since June 2018, part of this blog we will cover three new functions introduced which I believe would be mostly used. GUID Function: In my blog, I mentioned how to generate unique GUID using Azure function which requires us to create an azure function, a custom connector and connection between two. Microsoft has now introduced a new function GUID() which will...

Read More
Using RetrieveRecordChangeHistoryRequest to get Audit Detail in Dynamics 365 CE – Nishant Rana’s Weblog
Oct31

Using RetrieveRecordChangeHistoryRequest to get Audit Detail in Dynamics 365 CE – Nishant Rana’s Weblog

Just sharing a sample code to retrieve the Audit Detail using RetrieveRecordChangeHistoryRequest. RetrieveRecordChangeHistoryRequest changeRequest = new RetrieveRecordChangeHistoryRequest(); changeRequest.Target = new EntityReference(“entitySchemaName”, “entityId”)); RetrieveRecordChangeHistoryResponse changeResponse = (RetrieveRecordChangeHistoryResponse)_service.Execute(changeRequest); AuditDetailCollection...

Read More
Using the Content Access Level for KB Articles in Customer Self-Service Portal – Nishant Rana’s Weblog
Oct29

Using the Content Access Level for KB Articles in Customer Self-Service Portal – Nishant Rana’s Weblog

Suppose we have already configured Portal, created contacts and associated KB article to the Portal. Now the scenario we want to implement is we want a particular user to have access to all the KB article and another user to only specific KB Articles. For this, we will make use of Content Access Level concept of the portals. Content access level can be assigned to KB Article and can also be assigned to the Contact Users. There are 3...

Read More
The version of the Script Component is not compatible with this version of the DataFlow – Nishant Rana’s Weblog
Oct28

The version of the Script Component is not compatible with this version of the DataFlow – Nishant Rana’s Weblog

While trying to run one of our SSIS Packages from SQL Server Job, which had script component in it, we got the below error. It was running fine within the SSDT in our Dev Machine. In fact, the other packages deployed to SSISDB were also running fine, the ones which were not using the Script Component. To fix it, we updated the project version of SSDT to match the SQL Server where we were deploying the package inside Project...

Read More
Copy data from one database to another using Azure Data Factory – II – Nishant Rana’s Weblog
Oct28

Copy data from one database to another using Azure Data Factory – II – Nishant Rana’s Weblog

In the previous post, we discussed how to create Azure SQL Server and Azure SQL Database. Now that we are ready with source data/table and destination table, let’s create Azure Data Factory to copy the data. 3. Azure Data Factory: Click on Create a resource –> Analytics –> Data Factory Fill the mandatory fields and click Create After creating data factory, let’s browse it.Click on Author and Monitor. Click on Author icon on the...

Read More
Fixed – Windows 10 Remote Desktop (RDP) not saving credentials. – Nishant Rana’s Weblog
Oct27

Fixed – Windows 10 Remote Desktop (RDP) not saving credentials. – Nishant Rana’s Weblog

Recently even after saving the credentials in connection settings to an RDP file, every time we were opening it, it was asking us to enter the password. The below steps helped us to fix the issue. Open Windows Group Policy Editor (gpedit.msc) from the command prompt. Go to Local Computer Policy – Administrative Templates – System – Credentials Delegation. Click on Allow delegating fresh credentials, select the option Enabled. Click on...

Read More
Deploying Package to SQL Server Integration Services Catalog (SSISDB) from Visual Studio (SSDT) – Nishant Rana’s Weblog
Oct27

Deploying Package to SQL Server Integration Services Catalog (SSISDB) from Visual Studio (SSDT) – Nishant Rana’s Weblog

Deploying packages to SQL Server from SSDT is straightforward. We can either deploy the project or an individual SSIS Package i.e. Project Deployment or Package Deployment. (SQL Server 2016 Onwards). Here we will see the package deployment. Right-click the package that we would like to deploy and select Deploy Package. This opens the Integration Services Deployment Wizard Click on Next and Specify Server Name and the credentials to...

Read More
Audit Information not getting retrieved using SSIS/KingswaySoft Adapter – Nishant Rana’s Weblog
Oct26

Audit Information not getting retrieved using SSIS/KingswaySoft Adapter – Nishant Rana’s Weblog

A few days back I wrote about how we can use CDS/CRM Source component of KingswaysSoft Adapter to get the audit information. Using KingswaySoft’s CDS/CRM Source component to get Audit information in Dynamics 365 CE (SSIS) Kingsway’s CDS/CRM Source component and has Source Type property having an AuditLogs value that can be used to get the Audit details from Dynamics 365 CE. Below we have set the Source Type as AuditLogs in...

Read More
Icebreakers section on Contact Form – Nishant Rana’s Weblog
Oct25

Icebreakers section on Contact Form – Nishant Rana’s Weblog

Recently, after upgrading our D365 V8 instance to D365 V9, we found that on Contact Form there was some discrepancy in the position of the sections. After comparing the Form Editor in both the instances(V8 and V9) we found the below differences: D365 V8: CARD DETAILS section at top right cornerD365 V9: New Icebreakers section at top right corner instead of CARD DETAILS section And, we found in upgraded instance that the actual content...

Read More
Set Up Your Workstation to Create SQL Server Reporting Services Reports for Dynamics 365 Revisited – Nishant Rana’s Weblog
Oct24

Set Up Your Workstation to Create SQL Server Reporting Services Reports for Dynamics 365 Revisited – Nishant Rana’s Weblog

Summary The process to set up a workstation to create SQL Server Reporting Services (SSRS) reports for Dynamics 365 involves a lot of steps and causes some confusion. The report authoring tool is Visual Studio, but a full licensed version of Visual Studio is not required. The Dynamics 365 Report Authoring Extensions has been recently updated to address TLS 1.2 requirements of Dynamics 365 v9 Revisited A couple of years ago I wrote a...

Read More
Uninstalling or Deleting Dynamics 365 Portals Solution – Nishant Rana’s Weblog
Oct23

Uninstalling or Deleting Dynamics 365 Portals Solution – Nishant Rana’s Weblog

Recently we wanted to remove the Community Portal Solution from one of our Development instances. Here, the solutions admin page doesn’t give the option of deleting or removing it. To remove it, we need to uninstall all the solutions installed by the Dynamics 365 Portals – Community Portal. Back in Dynamics 365 we can see so many solutions installed as part of community portal. Here we need to remove the solutions in the reverse order...

Read More
Using Script Component to specify input value to OLE DB Source Component in SSIS – Nishant Rana’s Weblog
Oct22

Using Script Component to specify input value to OLE DB Source Component in SSIS – Nishant Rana’s Weblog

Recently we had a requirement to write an SSIS package that will fetch the data from SQL Server and will insert it (or create records) into Dynamics 365 CE. For connecting and fetching data from SQL Server, we were using OLE DB Source Component with data access mode as SQL Command which had one parameter, whose value we had to fetch from Dynamics 365 CE. For passing the value to this parameter we had defined a variable within our...

Read More
Ribbon Button Enable Rule Custom JS Code gives error “Cannot read property ‘getFormContext’ of undefined” – Nishant Rana’s Weblog
Oct22

Ribbon Button Enable Rule Custom JS Code gives error “Cannot read property ‘getFormContext’ of undefined” – Nishant Rana’s Weblog

While working on upgrade activities of D365 V9 from D365 V8, we faced one weird issue related to Enable Rule of  Ribbon button. We had one form where we were using Enable Rule for a button which was defined using custom JS code. As part of client side scripting changes related to D365 V9 upgrade, we passed Primary Control as first CRM parameter in Ribbon Workbench for that Enable Rule as explained here and in JS we passed...

Read More
Using Output Timezone property of CDS/CRM Source Component in SSIS – Nishant Rana’s Weblog
Oct21

Using Output Timezone property of CDS/CRM Source Component in SSIS – Nishant Rana’s Weblog

In Dynamics 365 CE, the data time field’s value will always be returned in UTC time when retrieved through the Organization Service. Just go through this insightful article to learn more about CRM Date Time. Truths about Dynamics CRM Date and Time Microsoft Dynamics CRM Date and Time can be very confusing and challenging to work with, especially in scheduling applications. We have solved several challenges with DateTimes and time...

Read More
Unable to Login to Dynamics CRMOrganization WebProxy
Oct20

Unable to Login to Dynamics CRMOrganization WebProxy

Recently for a console application we got the below error while using CrmServiceClient. The possible reason is we haven’t specified that security protocol TLS12 to be used in our console application and it is still targeting .NET Framework 4.5.2. Add the following line of code to get it working if that is the case. If we are using Visual Studio 2017, simply change the Target Version to .NET Framework 4.6 or higher. It internally...

Read More