New features of Visual Studio 2019 – Code Clean up, Faster Debugging, Refactoring, Live Share
Oct15

New features of Visual Studio 2019 – Code Clean up, Faster Debugging, Refactoring, Live Share

Earlier we covered below features Intellicode Search Experience Export / Import Configuration Settings Let us have a look at the other new features, that are now part of Visual Studio 2019 (couple of features were available with VS 2017 as marketplace extension earlier) Health Indicators à With Health Indicators, which can be found at the … Continue reading “New features of Visual Studio 2019… Continue Reading...

Read More
Business Unit Hierarchy – My First XrmToolBox Plugin
Oct04

Business Unit Hierarchy – My First XrmToolBox Plugin

Originally posted on Phani Rajasekhar: I am very happy to announce that my first plugin “Business Unit Hierarchy” is listed in XrmToolBox now. Thanks to Nishant Rana for giving me an idea to develop this. This plugin is simple but very useful. Most of the times we navigate to so many windows to understand the… Continue Reading Nishant Rana’s Article on their blog Business Unit Hierarchy – My First...

Read More
New features of Visual Studio 2019 – IntelliCode
Oct03

New features of Visual Studio 2019 – IntelliCode

IntelliCode to be very precise provides Artificial Intelligence to the code. Basically, it will provide suggestions (AI) by displaying at the top the frequently used properties, functions, etc. as shown below. For DateTime, IntelliCode is suggesting Now, UtcNow, MinValue and Today, as these are the ones that are used frequently. Similar for our IOrganizationService class … Continue reading… Continue Reading Nishant...

Read More
Generate Dynamics 365 CE (CRM) Business Unit Org Chart through SmartDraw
Oct02

Generate Dynamics 365 CE (CRM) Business Unit Org Chart through SmartDraw

Recently we were looking at the options of generating a Business Unit Org Chart for quick review. Using SmartDraw we were able to do achieve it very quickly. Steps Export the Business Unit records to excel. Keep only the Name and Parent Business column and delete all the other columns including the hidden ones. Excel … Continue reading “Generate Dynamics 365 CE (CRM) Business Unit Org Chart… Continue Reading Nishant...

Read More
New features of Visual Studio 2019 – New Search Experience and UI changes
Oct01

New features of Visual Studio 2019 – New Search Experience and UI changes

Visual Studio 2019 comes with a completely revamped, context-sensitive Search experience. To change the Theme, search for keyword “Theme” and select the appropriate result. It would open the respective screen, which allows us to quickly make the changes. Similarly, to change the Font. Also, observe the option to “Search online for ‘Font’”, which opens the … Continue reading “New features...

Read More
New features of Visual Studio 2019 – Export / Import Visual Studio Configuration Settings
Sep30

New features of Visual Studio 2019 – Export / Import Visual Studio Configuration Settings

Within Visual Studio Installer, we now have the option to export and import the configuration settings. These configuration settings can then be shared with the team to import, which makes sure that all of them have the same set of workloads installed in their Visual Studio environment. Select the version of Visual Studio and click … Continue reading “New features of Visual Studio 2019 –… Continue Reading...

Read More
Live Chat using ProProfs Chat in Dynamics 365 CE (CRM)
Sep12

Live Chat using ProProfs Chat in Dynamics 365 CE (CRM)

ProProfs chat is another live chat solution that integrates with both Dynamis 365 CE as well as CRM On Premise. Recently I wrote about PowerChat which is another live chat solution that works on both online and on premise version of Dynamics CRM. In this post we’d see how quickly we can setup the integration … Continue reading “Live Chat using ProProfs Chat in Dynamics 365… Continue Reading Nishant Rana’s...

Read More
Enable Live Chat in Microsoft Dynamics 365 CE (CRM) using PowerChat
Sep11

Enable Live Chat in Microsoft Dynamics 365 CE (CRM) using PowerChat

PowerChat is the live chat solution / addon developed by PowerObjects that supports both Dynamics CRM On-Premise and Online. Below we will look at how to set it up and what are the features it provides. To get started Download the appropriate solution https://www.powerobjects.com/powerpacks/powerchat/ After successful import of the solution, next step is to register … Continue reading “Enable… Continue Reading...

Read More
Out of preview – New Model-Driven form designer (WYSIWYG) in PowerApps
Sep06

Out of preview – New Model-Driven form designer (WYSIWYG) in PowerApps

Finally the new model-driven designer is out of preview and available for general use https://powerapps.microsoft.com/en-us/blog/announcing-the-general-availability-of-the-new-model-driven-form-designer/ Since I wrote about it last the few changes that we can see are  New Field button that allows adding Lookup Fields. However I still don’t see the option of Option Set fields there. Grouping… Continue Reading Nishant...

Read More
Performance testing Dynamics 365 CE using StresStimulus
Sep05

Performance testing Dynamics 365 CE using StresStimulus

Recently we were evaluating StresStimulus, the load testing tool, for our performance testing requirements. The tool is quite user friendly and intuitive and in a matter of few minutes (and few clicks), we were up and running. Get the tool (trial) here https://www.stresstimulus.com/download Install it with the Fiddler Add-On (recommended) option checked. It also has … Continue reading… Continue Reading Nishant Rana’s...

Read More
OAuth 2.0 with Dynamics 365 CE Web API
Aug30

OAuth 2.0 with Dynamics 365 CE Web API

OAuth can be defined as delegation or authorization protocol. The resource owner who owns the resource is allowing an application to access that resource on their behalf without impersonating the resource owner. The application first requests for the authorization from the resource owner and receives the token using which it can access the resource. Here … Continue reading “OAuth 2.0 with… Continue Reading Nishant...

Read More
Connect to Dynamics 365 Web API using OAuth 2.0 – Implicit Grant Type (through Single Page Apps)
Aug28

Connect to Dynamics 365 Web API using OAuth 2.0 – Implicit Grant Type (through Single Page Apps)

In previous post we saw how to connect to Dynamics 365 Web API using Postman and Implicit Grant type, in this post we will be creating a single page html application and will use ADAL library in our JavaScript to call Web API using Implicit Grant Type. While writing the single page application, we need … Continue reading “Connect to Dynamics 365 Web API using OAuth 2.0 – Implicit Grant Type… Continue Reading Nishant...

Read More
Connect to Dynamics 365 Web API using OAuth 2.0 – Implicit Grant Type (through Postman)
Aug27

Connect to Dynamics 365 Web API using OAuth 2.0 – Implicit Grant Type (through Postman)

In the previous post we covered below grant type Password  Client Credentials Authorization Code here we’d be looking at the Implicit Grant Type. Implicit Grant Type is for the “Public Clients”, client application that cannot keep the Client Secret, HTML or Angular app that communicates from the browser (through JavaScript) and have no server involved, … Continue reading “Connect to Dynamics…...

Read More
Fix – AADSTS700054: response_type ‘id_token’ is not enabled for the application -Dynamics 365 CE (Implicit Grant)
Aug27

Fix – AADSTS700054: response_type ‘id_token’ is not enabled for the application -Dynamics 365 CE (Implicit Grant)

If we have not enabled the application to request an id_token directly from the Authorization Endpoint (while writing Single Page Application that uses Implicit Flow Grant), we would get the below error à To fix it, go to Manifest of the application registered and set oauth2AllowIdTokenImplicitFlow to true. Another option of setting this property is … Continue reading “Fix – AADSTS700054:… Continue Reading...

Read More
Connect to Dynamics 365 Web API using OAuth 2.0 – Authorization Code Grant Type
Aug25

Connect to Dynamics 365 Web API using OAuth 2.0 – Authorization Code Grant Type

In the previous post we covered Password and Client Credentials grant type, here we’d be looking at the Authorization Code Grant Type. The Authorization Code Grant Type is for the Confidential Clients i.e. basically for the server side web applications that are written in server side language and source code is not available to the … Continue reading “Connect to Dynamics 365 Web API using… Continue Reading...

Read More
Connect to Dynamics 365 Web API using OAuth 2.0 – Client Credentials
Aug24

Connect to Dynamics 365 Web API using OAuth 2.0 – Client Credentials

In the last post we learned about connecting to Dynamics 365 Web API using Resource Owner Password Credential (ROPC), here we’d be covering the Client Credentials grant. Client Credentials grant is designed for the client applications who are the resource owner and when basically there are no users involved, a batch (cron) job or a … Continue reading “Connect to Dynamics 365 Web API using… Continue Reading...

Read More
Upload multiple attachments in CRM Notes/ annotations with metadata for each attachment- Introducing Notes Manager from XrmForYou.com
Aug23

Upload multiple attachments in CRM Notes/ annotations with metadata for each attachment- Introducing Notes Manager from XrmForYou.com

Originally posted on Debajit's Dynamic CRM Blog: It gives me great pleasure to announce the new CRM add-on from XrmForYou stable – Notes Metadata Manager utility from XrmForYou stable. Well Notes (Annotations) have existed in CRM since pre-historic times. And perhaps one of the most widely used feature in Dynamics till date since its… Continue Reading Nishant Rana’s Article on their blog Upload multiple attachments in...

Read More
Connect to Dynamics 365 Web API using OAuth 2.0 – Resource Owner Password Credential (ROPC)
Aug23

Connect to Dynamics 365 Web API using OAuth 2.0 – Resource Owner Password Credential (ROPC)

The ROPC grant type should only be used in scenario when the Client application is absolutely trusted with user credentials and when redirect based flow are not possible. It was introduced for the Legacy Application for quick migration and is now more or less considered obsolete by OAuth Working group, and ideally should not be … Continue reading “Connect to Dynamics 365 Web API using OAuth… Continue Reading Nishant...

Read More
Subgrid, QuickView, Linear Gauge, Arc Knob, Linear Slider controls added in new model-driven form designer (WYSIWYG) in PowerApps
Aug19

Subgrid, QuickView, Linear Gauge, Arc Knob, Linear Slider controls added in new model-driven form designer (WYSIWYG) in PowerApps

Recently we were trying out the model-driven form designer and noticed the option of adding new input control to the form in it. Few days back only I wrote about the addition of Subgrid control, however the limitation was that we couldn’t add new subgrid control. But with the new updates, we can now add … Continue reading “Subgrid, QuickView, Linear Gauge, Arc Knob, Linear Slider controls… Continue Reading...

Read More
PCF Control – Address Finder for New Zealand region
Aug08

PCF Control – Address Finder for New Zealand region

Originally posted on Sankalp's Dynamics Logs: Recently Microsoft released preview version of PowerApp Component Framework which enable developers working on Dynamics 365 to create cool custom controls and enhancing the capability. I have Utilized it to create Address Finder control which should work for New Zealand region. For this i have have used AddressFinder… Continue Reading Nishant Rana’s Article on their blog...

Read More
Sub-Grid added to the new model-driven form designer (WYSISYG) in PowerApps
Aug05

Sub-Grid added to the new model-driven form designer (WYSISYG) in PowerApps

Hi, Microsoft is steadily adding all the essential features to the new model-driven form designer (preview) making it more and more usable and intuitive. Latest addition is the support for sub-grid as shown below The properties window for the sub-grid ` We can select the view from either the related entities or view from any … Continue reading “Sub-Grid added to the new model-driven form… Continue Reading Nishant...

Read More
MVP’s around the World (2019)
Jul26

MVP’s around the World (2019)

Originally posted on EighTwOne (821): Update: Updated statistics based on award categories (not people) due to the number of multi-category awardees. In previous years, I performed some comparisons on the MVP population after every award cycle. So, time to get some fresh statistics after July 2019 award cycle. For comparison, I had a look at the… Continue Reading Nishant Rana’s Article on their blog MVP’s around the...

Read More
Class of 2019: 25 Microsoft MVPs you should be following
Jul26

Class of 2019: 25 Microsoft MVPs you should be following

After being named a Microsoft MVP once again earlier this month, I’m proud to say that I’ve been named in Nigel Frank’s list of top MVPs to follow. I’m honoured to appear as part of the Microsoft MVP Class of 2019 roundup, and to be included among a host of other wonderful MVPs from across … Continue reading “Class of 2019: 25 Microsoft MVPs you should be following” Continue Reading Nishant Rana’s Article...

Read More
XrmToolBox – Using User Profile Migration tool for quickly updating User’s security roles on changing the Business Unit
Jul25

XrmToolBox – Using User Profile Migration tool for quickly updating User’s security roles on changing the Business Unit

Few weeks back, we Rahul Tiwary and Prashant Maurya developed a tool named User Profile Migration for moving Users along with their respective BU’s, Security Roles and Teams that they are part of from one instance to another. Our earlier tool User Security Manager provided feature to update the BU, Security Roles, Team, Field Security Profile … Continue reading “XrmToolBox – Using User… Continue Reading Nishant...

Read More
Apply SLA choosing the SLA in the SLA lookup field for the SLA Enabled Entities in Dynamics 365 CE
Jul24

Apply SLA choosing the SLA in the SLA lookup field for the SLA Enabled Entities in Dynamics 365 CE

One of the enhancements that came in SLA (CRM 2016 Update 1), which I feel has got unnoticed by few, is choosing the SLA manually using the SLA lookup field. As we all know SLA comes already enabled for Case Entity and can be enabled for the below entities Account, Contact, Order, Invoice, Quote, Opportunity, … Continue reading “Apply SLA choosing the SLA in the SLA lookup field for the SLA… Continue Reading Nishant...

Read More
ClickDimensions Features (Pros and Cons) and QuickStart guide
Jul24

ClickDimensions Features (Pros and Cons) and QuickStart guide

Word Version : https://1drv.ms/w/s!As1evjwQ4RIjjZRve-ZmrICdtmZoaA?e=KVDUDB Pros of using ClickDimensions with Microsoft Dynamics CRM 365 Easy to set up and configure. ClickDimensions will provide a solution file which needs to be imported to the Dynamics CRM Web Application. It doesn’t require any setup files or any other infrastructure to be configured as it will be using … Continue reading… Continue Reading Nishant...

Read More
Single Organization vs Multiple Organization (Single Instance vs Multiple Instance) key points to consider in Dynamics 365 CE (On-Premise)
Jul23

Single Organization vs Multiple Organization (Single Instance vs Multiple Instance) key points to consider in Dynamics 365 CE (On-Premise)

The decision for going with single or multiple organisation should be made as early as possible because if the implementation grows, it will increase the complexity. For e.g., if we have Marketing already implemented for the marketing lob and now, we are planning to add Sales and Service, which would be difficult as it could … Continue reading “Single Organization vs Multiple Organization… Continue Reading Nishant...

Read More
Getting entity record counts
Jul22

Getting entity record counts

Originally posted on Dreaming in CRM: There are couple of ways to gets entity record counts: you could use XrmToolBox’s Record Counter Tool, or write the FetchXml to count the records as you navigate from one page to the next. But, if you just want to use the SDK here is a simple method: a… Continue Reading Nishant Rana’s Article on their blog Getting entity record counts RetrieveTotalRecordCountRequest to get the...

Read More
SSRS and Power BI comparison for Dynamics 365 CE Reporting
Jul18

SSRS and Power BI comparison for Dynamics 365 CE Reporting

Hi, Was recently working on a comparison between using SSRS and/or Power BI for reporting for Microsoft Dynamics CRM, below are some of the points we came up SSRS has always been Reporting Tool of choice for Microsoft Dynamics CRM and has been natively integrated with the application. Microsoft Dynamics CRM offers Report Parameters for … Continue reading “SSRS and Power BI comparison for… Continue Reading Nishant...

Read More
What is the maximum file size limit for Attachments in Dynamics 365  On Premise V9?
Jul17

What is the maximum file size limit for Attachments in Dynamics 365 On Premise V9?

Recently was trying to figure out the maximum file size limit for the attachments. It is 131072 (in kilobytes) Can be defined at Settings – Administration – Email Tab. Scroll down to Set file size limit for attachments section Hope it helps.. Continue Reading Nishant Rana’s Article on their blog What is the maximum file size limit for Attachments in Dynamics 365 On Premise V9? Recently was trying to figure out the...

Read More
Using SARIF Viewer to read the static analysis results generated by Microsoft.PowerApps.Checker.PowerShell module
Jul13

Using SARIF Viewer to read the static analysis results generated by Microsoft.PowerApps.Checker.PowerShell module

In the last post, we saw how we can use the Microsoft.PowerApps.Checker.PowerShell module to analyze the Solution (Unmanaged and Managed – Online or On-Premise) outside the PowerApps Maker Portal. https://nishantrana.me/2019/07/12/using-the-powerapps-checker-powershell-module-to-validate-the-solution/ The reports generated by the tool are in SARIF format i.e. Static Analysis Results… Continue Reading Nishant Rana’s Article...

Read More
Using the PowerApps checker PowerShell Module to validate the solution
Jul12

Using the PowerApps checker PowerShell Module to validate the solution

Using PowerApps Checker PowerShell Module we can perform the solution check functionality from outside the PowerApps Maker Portal. This can be useful for automated build and release pipelines. Apart from that some of the notable capabilities of the module include Support for both managed and unmanaged solution. Support for On-Premise. Support for more than one solution … Continue reading… Continue Reading Nishant...

Read More
Using PowerApps Solution Checker from the PowerApps maker portal
Jul12

Using PowerApps Solution Checker from the PowerApps maker portal

The PowerApps Solution Checker feature released for general availability on May 2019, can be used to perform static analysis of the Unmanaged solution for components like plugin, web resources, custom workflow activities and provide guidelines and recommendations around the issues found. To get started à Sign in to PowerApps maker portal https://make.powerapps.com/home Select the Solutions …

Read More
Fixed – Package Deployer (USD) not connecting to CRM Organization
Jul11

Fixed – Package Deployer (USD) not connecting to CRM Organization

Hi, while trying to set up USD in the Dynamics 365 Online environment We were facing the issue with the USD’s Package Deployer, after login, it was showing the Organizations but on trying to connect to them, it was again taking back to the login screen. This was because we were using below old version … Continue reading “Fixed – Package Deployer (USD) not connecting to… Continue Reading Nishant...

Read More
Thanks Microsoft for the MVP (Business Applications) award once again!
Jul02

Thanks Microsoft for the MVP (Business Applications) award once again!

Thanks Microsoft for this recognition and thanks to all the wonderful and passionate Dynamics 365 (CRM) professionals who have inspired and motivated me and others for several years, to keep learning and contributing in the community and to grow in the process! Continue Reading Nishant Rana’s Article on their blog Thanks Microsoft for the MVP (Business Applications) award once again! Thanks Microsoft for this recognition and...

Read More
Dynamic CRM – User Profile Migration
Jun27

Dynamic CRM – User Profile Migration

Originally posted on Rahul Tiwary CRM Blogs: Recently, I have been working on a project which has lot of users belongs to different BU’s having different roles and they are part of multiple Teams. Now, once we are done with UAT it was time to go and configure PROD. The timeline to go live was… Continue Reading Nishant Rana’s Article on their blog Dynamic CRM – User Profile Migration Rahul Tiwary CRM Blogs...

Read More
Getting FormContext in Power Apps Custom Component framework–Gotchas! – Nishant Rana’s Weblog
Jun07

Getting FormContext in Power Apps Custom Component framework–Gotchas! – Nishant Rana’s Weblog

Before I proceed further some disclaimers here. If you are thinking from the title that I have been able to resolve the problem completely, unfortunately it’s not. My approach works for certain scenarios and not for all scenarios and I will explain where it works and where it doesn’t. And this is of the time I am writing this blog. Very soon Microsoft may release something much simpler. Ever since I wrote the article on in-depth...

Read More
How to – Add Style to Custom Component in PowerApps Component Framework – Nishant Rana’s Weblog
Jun06

How to – Add Style to Custom Component in PowerApps Component Framework – Nishant Rana’s Weblog

Kindly refer the previous post, here we will be adding style to the component created in the post. Step by Step – Create a very simple PowerApps Custom Component to show the GUID of the record Go through below articles to get a better understanding https://debajmecrm.com/2019/04/26/in-depth-end-end-walkthrough-develop-your-custom-controls-using-power-apps-component-framework-and-use-it-on-your-crm-interface/...

Read More
Step by Step – Create a very simple PowerApps Custom Component to show the GUID of the record – Nishant Rana’s Weblog
Jun06

Step by Step – Create a very simple PowerApps Custom Component to show the GUID of the record – Nishant Rana’s Weblog

Go through below articles to get a better understanding Below is the quick step by step guide to get started (sort of Hello World example)  Install NPM (that comes with Node.js) Node.js Node.js® is a JavaScript runtime built on Chrome’s V8 JavaScript engine. No Title No Description Install Visual Studio 2017 or later or Download .NET Core 2.2 along with Visual Studio Code. Create the new folder for the project, and in Developer...

Read More
TypeScript Language Quick Reference – Nishant Rana’s Weblog
Jun02

TypeScript Language Quick Reference – Nishant Rana’s Weblog

Data Types in TypeScript Access Modifier Any keyword is similar to Var keyword in JavaScript Properties Arrow Function TypeScript contains type information for standard JavaScript objects, and using Type Definitions we can refer or get the type information for the external libraries. DefinitelyTyped/DefinitelyTyped The repository for high quality TypeScript type definitions. – DefinitelyTyped/DefinitelyTyped let has block scope...

Read More
Getting started with TypeScript – Nishant Rana’s Weblog
Jun01

Getting started with TypeScript – Nishant Rana’s Weblog

TypeScript is an open-source programming language developed and maintained by Microsoft. TypeScript adds Type support to JavaScript, which makes sure type checking is done resulting in fewer bugs, adds autocomplete supports in the TypeScript editor, supports Object Orientation and structuring and packing of the code, etc. The code written in TypeScript transpiles to JavaScript by TSC i.e. TypeScript Compiler. The easiest way to...

Read More
{In-depth end-end walkthrough} Develop your custom controls using Power Apps Component framework and use it on your CRM interface.
May27

{In-depth end-end walkthrough} Develop your custom controls using Power Apps Component framework and use it on your CRM interface.

Before I stepped in the wonderful world of Dynamics, I used to develop custom controls in ASP.NET. Couple of days back when Microsoft announced the release of Power Apps component framework using which you can develop custom controls and use it on Dynamics forms, I was overwhelmed. It was kind of nostalgia for me. Going back to the old glory days of custom control development. And here I was reading the pre-release documentation from...

Read More
Few improvements in new model-driven form designer WYSISYG Preview in PowerApps – Nishant Rana’s Weblog
May27

Few improvements in new model-driven form designer WYSISYG Preview in PowerApps – Nishant Rana’s Weblog

Few months back I wrote about the features of the new model drive form designer in PowerApps. The new model-driven form designer (WYSISYG) in PowerApps for Model-driven apps (Dynamics 365 CE) Preview The new model-driven form designer (Preview) has some nice features added to it like Searching for fields in the form Tree View showing visual hierarchy of the controls for quick view and navigation inside the form. The icon also makes it...

Read More
{Dynamics 365 for Sales AI} How are relationship analytics calculated? Let Microsoft Docs tell you – Nishant Rana’s Weblog
May09

{Dynamics 365 for Sales AI} How are relationship analytics calculated? Let Microsoft Docs tell you – Nishant Rana’s Weblog

Recently I have been working on setting up various features of Sales AI for a customer and I have to tell you that there is so much to it than meets the eye. And one of them is the Relationship Analytics. If you go to Account/ Contact/ Lead/ Opportunity form then you would see some Relationship Analytics showing up. Below is the screenshot for an opportunity. But the question is – “How is Microsoft showing up all these values? After...

Read More
The “Derived Column” failed because truncation occurred, and the truncation row disposition on “Derived Column.Outputs[Derived Column Output].Columns[FilePath]” specifies failure on truncation. A truncation error occurred on the specified object of the specified component. – Nishant Rana’s Weblog
May08

The “Derived Column” failed because truncation occurred, and the truncation row disposition on “Derived Column.Outputs[Derived Column Output].Columns[FilePath]” specifies failure on truncation. A truncation error occurred on the specified object of the specified component. – Nishant Rana’s Weblog

We might get the error while using Derived Column in our SSIS Package To fix it right click the Derived Column component and select Show Advanced Editor .. Go to Input and Output Properties tab, expand Derived Column Output and select the field and update the length in the properties window. Hope this helps.. Like this:Like Loading… Related Continue Reading Nishant Rana’s Article on their...

Read More
Fixed – Workflows not firing “Waiting For Resources” in Dynamics 365 On-Premise – Nishant Rana’s Weblog
May02

Fixed – Workflows not firing “Waiting For Resources” in Dynamics 365 On-Premise – Nishant Rana’s Weblog

Recently in one of our environments, we started getting the issue that all our workflows were getting stuck at “Waiting for resources”. As usual first step was to check if Microsoft Dynamics 365 Asynchronous Processing Service is running it or not. The service was disabled, so we enabled it. But still, it didn’t fix the issue. Next thing we tried was as suggested in the below article How to Fix a CRM Workflow Stuck in “In...

Read More
Fixed – DTS_E_PROCESSINPUTFAILED. The Process input method on component “Script Component” failed with error code 0x80131501 in SSIS
Apr25

Fixed – DTS_E_PROCESSINPUTFAILED. The Process input method on component “Script Component” failed with error code 0x80131501 in SSIS

Recently I had written an article for Nigel Frank that list down step by step process of using XML Source Component of KingswaySoft for integration with Dynamics 365 CE Ask the expert: How to integrate Dynamics 365 for Customer Engagement with XML It’s hard to imagine a Dynamics 365 for Customer Engagement implementation that doesn’t involve integration with other systems. This integration can either be in real-time, which...

Read More
Fixed – The Script Task uses version 15.0 script that is not supported in this release of Integration Services – Nishant Rana’s Weblog
Apr24

Fixed – The Script Task uses version 15.0 script that is not supported in this release of Integration Services – Nishant Rana’s Weblog

Recently after deploying the SSIS packages, on one of the packages that uses Script Component, we started getting below error message This happened because SSIS packages had target version SQL 2017 and the SQL Server version was 2016 (select @@VERSION) The fix is to update the target version that matches the SQL Server Version. Right click and go to project properties and update the Target Version to match and redeploy the project....

Read More
keyword in SSIS – Nishant Rana’s Weblog
Apr24

keyword in SSIS – Nishant Rana’s Weblog

Recently while trying to use KingswaySoft’ s CRM Connection Manager in the Script Component we got the below error Turned out the issue was because of the wrong version of KingswaySoft.IntegrationToolkit.DynamicsCrm assembly being referred. C:WindowsMicrosoft.NETassemblyGAC_MSILKingswaySoft.IntegrationToolkit.DynamicsCrm Referencing the correct one fixed it. Hope it helps.. Like this:Like Loading… Related Continue Reading...

Read More
An internal error occurred on the report server while trying to import organization in Dynamics 365 On-Premise – Nishant Rana’s Weblog
Apr19

An internal error occurred on the report server while trying to import organization in Dynamics 365 On-Premise – Nishant Rana’s Weblog

Recently while after restoring the database while trying to import the organization we got the below error Checking the Report Server log, we found the below detail Throwing Microsoft.ReportingServices.Library.InvalidReportServerDatabaseException: , Microsoft.ReportingServices.Library.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found...

Read More