“The application requires one of the following versions of the .NET Framework” or “.NET Framework 4.7.1 or later is already installed this computer” error while running application
Sep18

“The application requires one of the following versions of the .NET Framework” or “.NET Framework 4.7.1 or later is already installed this computer” error while running application

While trying to run an application we were getting the below message It was taking us to Microsoft Download site for downloading the framework. We downloaded the 4.7.1 Framework but while trying to install it we got the below message that said the framework or a later update is already installed on this computer. Tried uninstalling all the .NET Framework version installed including 4.7. That also didn’t work. Few of the forums talk...

Read More
Using Diff Detector component for working with incremental data in SSIS (Dynamics 365 CE) – Nishant Rana’s Weblog
Sep18

Using Diff Detector component for working with incremental data in SSIS (Dynamics 365 CE) – Nishant Rana’s Weblog

Diff Detector component of KingswaySoft’s SSIS Productivity Pack makes it extremely easy efficient to work with incremental data. Let us take a simple example to understand its usage Suppose, we have the following data in our SQL Table (source) that we have already moved to our Dynamics 365 Instance. Inside CRM à Now let us delete few records say for e.g. 5 from CRM and now we want only those 5 deleted records to be considered for...

Read More
The top attribute can’t be specified with paging attribute page in SSIS Package – Nishant Rana’s Weblog
Sep18

The top attribute can’t be specified with paging attribute page in SSIS Package – Nishant Rana’s Weblog

We might face this issue while using Dynamics CRM Source Component of SSIS Integration Toolkit [Dynamics CRM Source] Warning: An exception has occurred while processing the service request, the same request will be attempted again immediately. KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmServiceException: CRM service call returned an error: The top attribute can’t be specified with paging attribute page (Error Code: -2147220989,...

Read More
00 in SSIS (Dynamics 365) – Nishant Rana’s Weblog
Sep12

00 in SSIS (Dynamics 365) – Nishant Rana’s Weblog

We got the below while trying to UPSERT contact records from a SQL table to Dynamics 365 CE using Kingswaysoft Dynamics 365 Adapter. The source table had the Date of birth (DOB) as nvarchar type (string) and one of the rows had the following value stored for DOB à ‘0201-01-09 00:00:00’ Which was resulting into exception while creating record inside Dynamics 365 CE with the above date. The way we fixed it was to make use of Derived...

Read More
Cannot convert between unicode and non-unicode string data types error in SSIS – Nishant Rana’s Weblog
Sep10

Cannot convert between unicode and non-unicode string data types error in SSIS – Nishant Rana’s Weblog

While using the OLE DB Source component in SSIS, on updating its SQL Command we started getting the below error for “Phone” column in our Table. The fix is to open the Advanced Editor for the OLE DB Source component Change the Data Type (non-unicode string) for the Phone column inside Output Columns in Input and Output Properties Tab. Changing the Data Type from Unicode string [DT_WSTR] to string [DT_STR] fixed the issue. Hope it...

Read More
Publish as Azure Web Job Option missing in Visual Studio 2017 – Nishant Rana’s Weblog
Sep06

Publish as Azure Web Job Option missing in Visual Studio 2017 – Nishant Rana’s Weblog

While trying to publish one of our console application to Azure as Web Job we couldn’t find the “Publish as Azure WebJob..” option It was because Azure development tools were recently uninstalled from the system. To install it, go to Windows à Program and Features à Select Visual Studio 2017 and click on Modify. And select Azure Development for installation Select Azure Cloud Services tool. After installation it will ask for restart....

Read More
How to – convert a blank string to Null for DateTime field – SSIS – Nishant Rana’s Weblog
Sep02

How to – convert a blank string to Null for DateTime field – SSIS – Nishant Rana’s Weblog

Recently while writing an SSIS package, we were getting the below exception. System.Exception: Error: Failed to set field ‘birthdate’ value to ” for entity ‘contact’ (field type: DateTime, value type: String). System.FormatException: String was not recognized as a valid DateTime. (SSIS Integration Toolkit for Microsoft Dynamics 365, v10.2.0.6972 – DtsDebugHost, v14.0.3025.39) We were getting the exception because the source table was...

Read More
No Action header was found with namespace ‘http://www.w3.org/2005/08/addressing’ for the given message – error while calling a WCF Service through C/AL (Client/server Application Language)
Aug30

No Action header was found with namespace ‘http://www.w3.org/2005/08/addressing’ for the given message – error while calling a WCF Service through C/AL (Client/server Application Language)

While trying to call a WCF service from within the C/Al in Microsoft Dynamics NAV, we were getting the below error “No Action header was found with namespace ‘http://www.w3.org/2005/08/addressing‘ for the given message.” Strangely enough that request was working properly from within the SOAP UI. Eventually the following thread came to the rescue...

Read More
You are not authorized or do not have any subscriptions associated error while trying to access Kudo Sites in Azure – Nishant Rana’s Weblog
Aug29

You are not authorized or do not have any subscriptions associated error while trying to access Kudo Sites in Azure – Nishant Rana’s Weblog

Today for one of our Azure WebJobs when we tried checking its log, we got the below error à Seemed strange as being the Contributer of that Resource Group, I had access to all other functionality within that resource group. After much struggle, in one of threads there was a suggestion to try in a different browser or in private browsing mode. And luckily that worked. Out of all responses, this one makes the most sense for this...

Read More
The process cannot access the file .ispac because it is being used by another process error in Visual Studio (SSIS). – Nishant Rana’s Weblog
Aug28

The process cannot access the file .ispac because it is being used by another process error in Visual Studio (SSIS). – Nishant Rana’s Weblog

Recently while developing SSIS packages, the Visual Studio (SSDT) got crashed. After restarting the Visual Studio and trying to execute the package we got the below error. System.IO.IOException: The process cannot access the file ‘c:folderssisproject.ispac’ because it is being used by another process. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.Delete(String path) at… Continue Reading...

Read More
PowerApps – Secure your Azure Function and Custom Connector with Azure AD – Nishant Rana’s Weblog
Aug27

PowerApps – Secure your Azure Function and Custom Connector with Azure AD – Nishant Rana’s Weblog

In my previous blog, I explained how to create an Azure Function and consume it in PowerApps using custom connector but it was not secured (anonymous) and anyone can access this API using function URL. In this blog we will see how to secure Azure Function API and register PowerApps custom connector in Azure Active Directory. Below steps will be covered as part of this blog: Secure Azure Function with Azure AD App Registration for...

Read More
Power BI with Dynamics 365 CE – Dynamics 365 Content Pack – Nishant Rana’s Weblog
Aug24

Power BI with Dynamics 365 CE – Dynamics 365 Content Pack – Nishant Rana’s Weblog

In previous posts we covered Creating a Power BI Report using Dynamics 365 Online Service. Publishing it and Showing it inside Dynamics 365 and scheduling its Refresh. Apart from creating our own Power BI Report another way of quickly be up and running is to use the Content Packs provided by Third Party Service, for e.g. here we will be using Sales Analytics for Dynamics 365 content pack provided by Microsoft. Login to the Power BI...

Read More
Power BI with Dynamics 365 CE – Refreshing the Dataset – Nishant Rana’s Weblog
Aug21

Power BI with Dynamics 365 CE – Refreshing the Dataset – Nishant Rana’s Weblog

In the previous post, we used Dynamics 365 Dashboard and Power BI Tile to show Power BI Dashboard and report inside Dynamics 365. https://nishantrana.me/2018/08/20/power-bi-with-dynamics-365-ce-showing-power-bi-dashboard-tile-inside-dynamics-365-ce/ Now as a next step, we want to make sure that the users are looking at the latest data possible inside the DashboardReports. In case of Online Services like Dynamics 365 (Online), we have...

Read More
Power BI with Dynamics 365 CE – Showing Power BI Dashboard / Tile inside Dynamics 365 CE – Nishant Rana’s Weblog
Aug20

Power BI with Dynamics 365 CE – Showing Power BI Dashboard / Tile inside Dynamics 365 CE – Nishant Rana’s Weblog

In the previous post, we created a simple report and published it to the web and used IFrame to display them in Dynamics 365 CE. https://nishantrana.me/2018/08/20/power-bi-with-dynamics-365-ce-publishing-power-bi-report-to-the-web/ Now let us create a Power BIDashboard using that report, which we will then display inside Dynamics 365 CE as a proper native Dynamics 365 CE’s Power BI Dashboard. Let us take the fastest route to create...

Read More
Power BI with Dynamics 365 CE – Publishing Power BI Report to the web – Nishant Rana’s Weblog
Aug20

Power BI with Dynamics 365 CE – Publishing Power BI Report to the web – Nishant Rana’s Weblog

In the previous post, we learned how to create a simple Power BI Report using Power BI Desktop https://nishantrana.me/2018/08/20/power-bi-with-dynamics-365-ce-creating-report/ Now let us publish the report to Power BI Service from within the Power BI Desktop. To do so, select the Publish button Publish window will ask us to save the report file (if not saved) before we could publish it. Here we are publishing it to the default “My...

Read More
Power BI with Dynamics 365 CE – Creating Report – Nishant Rana’s Weblog
Aug20

Power BI with Dynamics 365 CE – Creating Report – Nishant Rana’s Weblog

To begin with, let us first create a Dynamics 365 Trial. https://trials.dynamics.com/ After our CRM trial is setup up successfully, we will install the OOB Sample Data which we would be using for creating the Power BI report. Next, we need to create a free trial for the above user to use Power BI Service. Go to Power BI site, and click on Start Free to get started. Use the same user account (trial) that was used to set up the Dynamics...

Read More
Maximum File Size Exceeded while using Export to Excel in Dynamics 365 CE – Nishant Rana’s Weblog
Aug15

Maximum File Size Exceeded while using Export to Excel in Dynamics 365 CE – Nishant Rana’s Weblog

We got this error while trying to export around 70K data through export to excel in Dynamics 365 CE. Log file gave us detail of the error i.e. Excel file exceeded size lime of 4 MB. One workaround is to export small set of data (page wise) by applying some order criteria (either in the Grid or through Advanced Find) Or better use the wonderful Export to Excel tool in XrmToolBox...

Read More
Update/Upsert operation is not supported in non-transaction mode error in Dynamics 365 for Sales Connector of Informatica Cloud
Aug15

Update/Upsert operation is not supported in non-transaction mode error in Dynamics 365 for Sales Connector of Informatica Cloud

Few weeks back while working on a migration project in which we were using Informatica Cloud’s Dynamics 365 for Sales connector, we used to get the below error while trying to perform the Upsert operation in Batch. “In CRM WRITER_1_*_1> CCI_WRITER_1000 [ERROR] Update/Upsert operation is not supported in non-transaction mode. “ For this we had raised a support ticket with Informatica. The response we got was that this feature will be...

Read More
“Cannot update a published workflow definition” exception in Dynamics 365 – Nishant Rana’s Weblog
Aug06

“Cannot update a published workflow definition” exception in Dynamics 365 – Nishant Rana’s Weblog

We would get this exception if we try updating an Activated Workflow using Update Request. So basically, if we need to update the activatedpublished workflow i.e. Activate or Deactivate it or change the Owner of the workflow, we would need to use the SetState and Assign Request. If we try doing it using the UpdateRequest we will the above error message. Perform specialized operations using Update Also, we noticed that if we try...

Read More
Thirty two “Microsoft’s Very Passionate” professionals thanked with giant “WALL-OF-LOVE” at Microsoft Summit!! – Nishant Rana’s Weblog
Jul30

Thirty two “Microsoft’s Very Passionate” professionals thanked with giant “WALL-OF-LOVE” at Microsoft Summit!! – Nishant Rana’s Weblog

Happy to see my pic there. Thanks to Peter Laker and Microsoft’s Face API . https://www.linkedin.com/pulse/thirty-two-microsofts-very-passionate-professionals-thanked-laker/ (one more reason to smile often 🙂 )   Like this: Like Loading… Related Continue Reading Nishant Rana’s Article on their...

Read More
Sharepoint Metadata Manager and Attachment Extractor–New version released! – Nishant Rana’s Weblog
Jul28

Sharepoint Metadata Manager and Attachment Extractor–New version released! – Nishant Rana’s Weblog

We are delighted to announce the release of the next version of our tool – Sharepoint Attachment Extractor and Metadata Manager. For readers who are new to this tool, this tool enables you to upload documents to Sharepoint with multiple metadata as well as host of other features like Allows you to create and edit Metadata related to files from CRM. This version allows up to five metadata fields per entity and also provides the option...

Read More
Managing User’s Field level security profiles and Exporting the user’s Security report to CSV – New features added in User Security Manager – XrmToolBox Plugin
Jul24

Managing User’s Field level security profiles and Exporting the user’s Security report to CSV – New features added in User Security Manager – XrmToolBox Plugin

Last week we released the first version of the User Security Manager, you can read about its features here. https://nishantrana.me/2018/07/16/user-security-manager-my-first-xrmtoolbox-plugin/ With the newer version, we have added the following features to it Managing User’s Field Level Security Apart from managing the Teams and the Security Roles for the user, now the tool allows us to manage the field level security profile of the...

Read More
My first XrmToolBox plugin for managing user’s security – User Security Manager – Nishant Rana’s Weblog
Jul17

My first XrmToolBox plugin for managing user’s security – User Security Manager – Nishant Rana’s Weblog

For past few weeks I have been thinking to add my bit to XrmToolBox, the most loved tool by me and the entire Dynamics 365 Community. Here is my first plugin “User Security Manager”. Which I developed along with Nishant Rana. This tool will help in efficiently managing User’s security in Microsoft Dynamics 365 Customer Engagement. Below is the list of features it has View all the security roles that assigned to the user either...

Read More
User Security Manager – My first XrmToolBox Plugin – Nishant Rana’s Weblog
Jul16

User Security Manager – My first XrmToolBox Plugin – Nishant Rana’s Weblog

Being one of the biggest fan and the most frequent daily user of XrmToolBox, always had this wish to write a plugin for it. Thanks to Prashant Maurya  (a dear friend and ex-Microsoft Employee) for making this wish come true. (Who played the major role in developing it). The tool is called – User Security Manager. The Plugin make it easy for the administrators to manage all the security related aspects of the system users. The tool...

Read More
When does the Plugin registered on SetState message fires in Dynamics 365? – Nishant Rana’s Weblog
Jul11

When does the Plugin registered on SetState message fires in Dynamics 365? – Nishant Rana’s Weblog

Hi, Recently we were writing a plugin that should fire when a record is activated. In this kind of scenario, it is suggestedrecommended to register plugin in both SetState and SetStateDynamicEntity message. https://community.dynamics.com/crm/f/117/t/184070 https://blogs.msdn.microsoft.com/crm/2008/03/07/developing-plug-ins-for-crm-4-0/ Interestingly we had the following observations The Plugin fires only for SetStateDynamicEntity...

Read More
Sample Plugin code to run on Reactivate Case (Incident) in Dynamics 365 – Nishant Rana’s Weblog
Jul10

Sample Plugin code to run on Reactivate Case (Incident) in Dynamics 365 – Nishant Rana’s Weblog

Just sharing a sample code that runs on the Activation of case (incident) record and updates one field in it. We need to register the plugin in both SetState and SetStateDynamicEntity message. Interestingly what we found was the plugin runs perfectly even if it is registered only for SetStateDynamicEntity. It triggers properly either we update it from CRM UI or through the CRM SDK for SetStateDynamicEntity message. protected override...

Read More
MVP’s around the World – Nishant Rana’s Weblog
Jul04

MVP’s around the World – Nishant Rana’s Weblog

Updated July 3rd:  Includes newly registered awardees and awardees who changed category. Added overview of Office Servers and Services numbers over last couple of years. With the latest annual award cycle, one might be curious which impact it had on the MVP population. I performed a similar exercise last year to compare the impact of the start of the new award cycle. This year, all the MVP’s previously on the January and October...

Read More
{Quick Tip} Manage your Entity Forms when your CRM is exposed to Web and Mobile App – Nishant Rana’s Weblog
Jun18
Read More
My Interview at MSDynamicsWorld.com
Jun16

My Interview at MSDynamicsWorld.com

My Interview at MSDynamicsWorld.com Blog Syndicated with Nishant Rana’s Permission //cdn.embedly.com/widgets/platform.js

Read More
Fixed – Invalid Export Business Process Not Activated error while exporting solution in Dynamics 365 – Nishant Rana’s Weblog
Jun13
Read More
3 Million Views. Thank you! – Nishant Rana’s Weblog
Jun11
Read More
PLAN PROPERLY before using Back and restore and Copy instances in Dynamics 365 – Nishant Rana’s Weblog
Jun07
Read More
SetTextIframe is not defined in Email Sends Form in Click Dimensions – Nishant Rana’s Weblog
Jun06
Read More
JavaScript error in customized Email Sends form in ClickDimensions after Upgrade – Nishant Rana’s Weblog
Jun05
Read More
Open Lookup Dialog Programmatically using Xrm.Utility–Dynamics V9.0 – Nishant Rana’s Weblog
Jun04
Read More
Using Conditional Split Transformation in SSIS – Nishant Rana’s Weblog
Jun04
Read More
Optimum Batch Size while using SSIS Integration toolkit for Microsoft Dynamics 365 – Nishant Rana’s Weblog
Jun04
Read More
The server is busy and the request was not completed. Try again later while inserting records using CRM Destination Component of KingswaySoft’s SSIS Integration Toolkit for Dynamics 365 – Nishant Rana’s Weblog
Jun03
Read More
Lookup not getting set while using CRM Destination Component of KingswaySoft’s SSIS Integration Toolkit for Dynamics 365 – Nishant Rana’s Weblog
Jun03
Read More
Anonymize sandbox data (copied from production) to meet data security standards like GDPR – Nishant Rana’s Weblog
May30
Read More
View Designer not showing SSIS Package in Design mode in Visual Studio – Nishant Rana’s Weblog
May30
Read More
Security Nuances with Manager Based Hierarchy in Dynamics 365 – Nishant Rana’s Weblog
May26

Security Nuances with Manager Based Hierarchy in Dynamics 365 – Nishant Rana’s Weblog

Security Nuances with Manager Based Hierarchy in Dynamics 365 – Nishant Rana’s Weblog Blog Syndicated with Nishant Rana’s Permission //cdn.embedly.com/widgets/platform.js

Read More
Using Lookup Transformation and Cache Transformation in SSIS for Dynamics 365 (using Kingswaysoft) – Nishant Rana’s Weblog
May22

Using Lookup Transformation and Cache Transformation in SSIS for Dynamics 365 (using Kingswaysoft) – Nishant Rana’s Weblog

Using Lookup Transformation and Cache Transformation in SSIS for Dynamics 365 (using Kingswaysoft) – Nishant Rana’s Weblog Blog Syndicated with Nishant Rana’s Permission //cdn.embedly.com/widgets/platform.js

Read More
Operation on clone solution failed error during solution import in Dynamics 365 – Nishant Rana’s Weblog
May21

Operation on clone solution failed error during solution import in Dynamics 365 – Nishant Rana’s Weblog

Operation on clone solution failed error during solution import in Dynamics 365 – Nishant Rana’s Weblog Blog Syndicated with Nishant Rana’s Permission //cdn.embedly.com/widgets/platform.js

Read More
The Common Data Service(CDS) and Prospect to Cash integration between Dynamics 365 For Sales and Dynamics 365 For Finance & Operations
May20

The Common Data Service(CDS) and Prospect to Cash integration between Dynamics 365 For Sales and Dynamics 365 For Finance & Operations

The Common Data Service(CDS) and Prospect to Cash integration between Dynamics 365 For Sales and Dynamics 365 For Finance & Operations Blog Syndicated with Nishant Rana’s Permission //cdn.embedly.com/widgets/platform.js

Read More
The import of the solution failed – The specified role cannot be updated error in Dynamics 365 – Nishant Rana’s Weblog
May20

The import of the solution failed – The specified role cannot be updated error in Dynamics 365 – Nishant Rana’s Weblog

The import of the solution failed – The specified role cannot be updated error in Dynamics 365 – Nishant Rana’s Weblog Blog Syndicated with Nishant Rana’s Permission //cdn.embedly.com/widgets/platform.js

Read More
Virtual Entities for tracking recently used items – Nishant Rana’s Weblog
May18

Virtual Entities for tracking recently used items – Nishant Rana’s Weblog

Virtual Entities for tracking recently used items – Nishant Rana’s Weblog Blog Syndicated with Nishant Rana’s Permission //cdn.embedly.com/widgets/platform.js

Read More
The solution installation or removal failed due to the installation or removal of another solution at the same time error in Dynamics 365
May18
Read More
Using Alternate Key to UpsertUpdate using Dynamics 365 for Sales Connector of Infomatica Cloud – Nishant Rana’s Weblog
May18
Read More
Delete solution components from Managed Solution without “Clone Solution” in Dynamics 365 – Nishant Rana’s Weblog
May16
Read More
WP Twitter Auto Publish Powered By : XYZScripts.com