D365: Enable Rule for button with asynchronous API request using promise

Many times, we get requirement to show/hide a button based on certain condition for which we define Enable Rule in Ribbon Workbench. If we need javaScript code for evaluation then we use Custom Enable Rule mentioning library, method to execute, passing PrimaryControl CRM parameter and additional parameters if necessary. Sometimes, the evaluation is done real … Continue reading D365: Enable Rule for button with asynchronous API request using promise

D365: "The user is not a member of the organization" error while connecting to CE

Recently, we were working on connecting to CE to do some CRUD operation using Azure function. We were using Client ID(Application ID) and Client Secret of the app registered on Azure Active Directory. We had provided the necessary API(Dynamics CRM) Permission (delegated "user_impersonation") to the app. While running the Azure function, we were getting the … Continue reading D365: "The user is not a member of the organization" error while connecting to CE

Power Automate: The template validation failed: ‘The repetition action(s) referenced by ‘inputs’ in action are not defined in the template.’

Recently, while working on Power Automate(formerly known as Flow), we got an issue saying "The template validation failed: 'The repetition action(s) referenced by 'inputs' in action are not defined in the template." We were trying to use Set Variable action at 2 places inside a loop based on certain condition as shown below: To save … Continue reading Power Automate: The template validation failed: ‘The repetition action(s) referenced by ‘inputs’ in action are not defined in the template.’

D365: The webhook call failed because the http request received non-success httpStatus code

Recently, while trying to invoke webhook using custom global action we got an error saying "The webhook call failed because the http request received non-success httpStatus code. Please check your webhook request handler." We were using JS to call a custom global action which was used to invoke webhook which in turn was used to … Continue reading D365: The webhook call failed because the http request received non-success httpStatus code

D365: Azure Durable Function with D365 CE – Part 3

In the previous post, we saw how we can implement durable function for CRUD operation in D365 and test it using Postman. In this post we'll see how we can parameterize durable function so that we can pass parameters from external system to durable function and process it further. Let's take a simple example as … Continue reading D365: Azure Durable Function with D365 CE – Part 3

D365: Azure Durable Function with D365 CE – Part 2

In the previous post, we saw how we created the default template of durable function. In this post, we'll modify that to do some CRUD operation in D365 CE. For demo purpose, let's pick a simple scenario i.e. Retrieve related records(accommodation payments) of a particular Contact record and update their field(Expected Refund Due Date a … Continue reading D365: Azure Durable Function with D365 CE – Part 2

D365: Azure Durable Function with D365 CE – Part 1

In this series of post, we'll see how we can use Azure Durable function(an extension of Azure Function which works on durable task framework) with D365 CE. We can find more details about Durable functions, it's application patterns, pricing and the way it works here: https://docs.microsoft.com/en-us/azure/azure-functions/durable/durable-functions-overview. This series of post is divided into 6 parts:Part … Continue reading D365: Azure Durable Function with D365 CE – Part 1

USD 4.1: Implementing Click to call functionality for making outgoing calls

In this post, we'll see how we can implement click to call functionality i.e. clicking on a phone number field on the form to make outgoing call inside USD. NOTE: In our scenario, we have implemented custom CTI adapter to use web services of telephony provider to make the outgoing calls. Below are the steps … Continue reading USD 4.1: Implementing Click to call functionality for making outgoing calls

USD 4.1: Using CTI Simulator and Generic Listener

In this post, we'll see how we can use CTI simulator along with Generic Listener provided by Microsoft. To start, download the CTI simulator from the following location: https://onedrive.live.com/?authkey=%21AIN2jgKztrYGpok&cid=5A34CCE9728C8F4F&id=5A34CCE9728C8F4F%21274&parId=5A34CCE9728C8F4F%21169&action=locate. Unzip it. Open the solution file in Visual Studio and compile it. Open the Project folder. Navigate to bin--> Debug folder and locate the USDCTICallTester.exe as … Continue reading USD 4.1: Using CTI Simulator and Generic Listener

D365: ExecuteMultiple error EntityState must be set to null, Created (for Create message) or Changed (for Update message)

While working on bulk update recently, we got an error saying "EntityState must be set to null, Created (for Create message) or Changed (for Update message)" in the ExecuteMultipleResponse object. We were trying to update one attribute of a set of records and below is the piece code we were using to do bulk update: … Continue reading D365: ExecuteMultiple error EntityState must be set to null, Created (for Create message) or Changed (for Update message)

D365: Unable to delete entity having hidden dependency(with Canvas App)

Recently, we were trying to delete one entity(not that heavily customized) as we wanted to use a different attirbute as Primary field from what being currently used, in our DEV instance.We removed all possible dependency for deleting the entity by clicking on Entity -> Show Dependencies in the solution. After removing all the dependencies, when … Continue reading D365: Unable to delete entity having hidden dependency(with Canvas App)

D365: 0x80040203 Invalid Argument error below lookup field

Recently, we were working on applying lookup filtering using JS on a custom entity form. While testing it, we got an error on each key press on the lookup field "0x80040203 Invalid Argument". We were constructing the record filter criteria based on certain condition. While debugging the code, we found that the filter criteria(FetchXML filter … Continue reading D365: 0x80040203 Invalid Argument error below lookup field

Microsoft Flow: Using data returned from N:N relationship for further action

In the previous blog, we saw how to retrieve N:N records i.e. we retrieved the related "Rate" records of a particular "Revenue Schedule Line". In this blog, we'll see how to process the data returned for further action. From our previous example, we wanted to loop through each related "Rate" record of "Revenue Schedule Line" … Continue reading Microsoft Flow: Using data returned from N:N relationship for further action

Microsoft Flow: Retrieve N:N records in D365

In this blog, we'll see how we can retrieve N:N records using Microsoft Flow. Below are the steps: Go to https://flow.microsoft.com and login. After successful login select CDS connector. For demo purpose, let's select "When record is updated" as the trigger point. Select Organisation, Entity Name and Scope as shown and click New Step. Search … Continue reading Microsoft Flow: Retrieve N:N records in D365

D365: Value cannot be null. Parameter name: attributeName

Recently, while trying to retrieve records in D365 CE using LINQ, we got the following error message "Value cannot be null. Parameter name: attributeName". There was not much information in the stack trace as well. We were using below code to get records based on certain condition from 2 entities putting join as shown below: … Continue reading D365: Value cannot be null. Parameter name: attributeName

D365: Add business day(s) to specific date considering weekends and public holidays

Recently, we got a requirement to add business days/working days to specific date considering weekends and public holidays defined in CRM system and get the next working day. Below is the workdays and working hours defined in the CRM system: Fridays and Saturdays are considered as week off. Below are the list of holidays defined … Continue reading D365: Add business day(s) to specific date considering weekends and public holidays

Add specific tag to the XML file only if it doesn’t exist using XSLT

Recently, while working on XML source component of SSIS Kingswaysoft, we got a requirement that there could be a scenario in which a specific tag would be missing in the XML source which is mandatory. We were supposed to add the tag if it's missing in the input XML. There could me many other ways … Continue reading Add specific tag to the XML file only if it doesn’t exist using XSLT

D365: “Setup cannot continue because there is a pending restart required. Restart the computer and then try running Setup again” Error while installing Report Authoring Extension

While installing D365 Report Authoring Extension, we faced a weird error message and setup was not complete: "Setup cannot continue because there is a pending restart required. Restart the computer and then try running Setup again". Restarting the machine several times didn't fix this issue. Browsing the log file in the path mentioned in error … Continue reading D365: “Setup cannot continue because there is a pending restart required. Restart the computer and then try running Setup again” Error while installing Report Authoring Extension

VS 2015: The “Team Foundation Server Provider Package” package did not load correctly

After installing VS 2015 on my machine, when i was trying to connect to TFS from Team Explorer, i was getting the below error message: The "Team Foundation Server Provider Package" package did not load correctly. As mentioned in the error pop up, i had a look at the ActivityLog.xml file in the path mentioned … Continue reading VS 2015: The “Team Foundation Server Provider Package” package did not load correctly

“The application has failed to start because its side-by-side configuration is incorrect” error while running console app(.exe)

While running a console app(.exe) by double clicking on it, we faced a weird issue and the exe was not getting executed. We were getting below error message in a pop up window: "The application has failed to start because its side-by-side configuration is incorrect". While checking the event log, we found that there was … Continue reading “The application has failed to start because its side-by-side configuration is incorrect” error while running console app(.exe)

SSRS: The report parameter ‘p1’ has a DefaultValue or a ValidValue that depends on the report parameter “p2”. Forward dependencies are not valid

While working on SSRS report recently, we were using 2 parameters. One parameter was depending on the value of the other parameter. While uploading the report to D365 environment, we got below error message and report was not uploaded: "The report parameter 'p1' has a DefaultValue or a ValidValue that depends on the report parameter … Continue reading SSRS: The report parameter ‘p1’ has a DefaultValue or a ValidValue that depends on the report parameter “p2”. Forward dependencies are not valid

D365[OnPrem]: System.Net.WebPermission, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed

Recently, we were using Custom workflow activity in which we were calling report server(using IP address) web service for generating SSRS report. We were using this custom WF activity in one workflow as a step which was getting triggered on create of a record. While testing this functionality, we got the below error message and … Continue reading D365[OnPrem]: System.Net.WebPermission, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed

D365: Set ConnectionId threw an exception

Recently, we got a weird error message "Set ConnectionId threw an exception" while trying to connect to D365 server from Visual Studio using Developer Toolkit. We were using VS 2015 and D365 Developer Toolkit. It was working fine and we were able to deploy plugins/custom workflows to D365 instance successfully. However, to work on reports, … Continue reading D365: Set ConnectionId threw an exception

D365: Custom Workflow Activity Input Parameter Type doesn’t Change

Recently, we were working on a custom workflow activity which takes Whole Number as input, process it and returns a String as Output. After developing it we tested it and it was working fine. Later, we wanted to change the data type of input parameter to Decimal so that we can take care of fraction … Continue reading D365: Custom Workflow Activity Input Parameter Type doesn’t Change

D365: User with ID “GUID” does not have Write privilege for the new_bpf_ “GUID” entity

Recently, while working on qualifying Lead to Opportunity we faced a permission issue. On Downloading Log file, we found the error message "User with ID 813f0246-55a4-e811-8478-5065f38bf441 does not have Write privilege for the new_bpf_02efda044479424aa7b3c7d8ab4a0a95 entity."  To fix this issue, we gave Write Permission to the BPF with GUID 02efda044479424aa7b3c7d8ab4a0a95 in a security role under Business Process Flows … Continue reading D365: User with ID “GUID” does not have Write privilege for the new_bpf_ “GUID” entity

D365: Multiple Currency Issue in Opportunity Line Grid(Inline Edit View) on Opportunity Form

Recently, while working on qualifying lead to opportunity we faced a weird issue. We were using multiple currencies in our D365 instance AED(Base currency in our case) and Egyptian Pound. We used Egyptian Pound currency on Lead while creating. On qualifying Lead to Opportunity, we were mapping the currency of Lead to Opportunity. So, eventually, currency selected … Continue reading D365: Multiple Currency Issue in Opportunity Line Grid(Inline Edit View) on Opportunity Form

Visual Studio 2017: Package Manager Console gives error “The type initializer for ‘System.Management.Automation.Runspaces.InitialSessionState’ threw an exception”

Recently, while working on Visual Studio 2017, when we wanted to launch Package Manager Console from Quick Launch Window, we got the below error message "The type initializer for 'System.Management.Automation.Runspaces.InitialSessionState' threw an exception". To fix this issue, we installed PowerShell Tools for Visual Studio 2017 from here and restarted Visual Studio. After doing this, we were able … Continue reading Visual Studio 2017: Package Manager Console gives error “The type initializer for ‘System.Management.Automation.Runspaces.InitialSessionState’ threw an exception”

Azure: Copy Data from D365 CE to Azure SQL Database using Azure Data Factory

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 … Continue reading Azure: Copy Data from D365 CE to Azure SQL Database using Azure Data Factory

Azure: Execute SSIS Package using Azure Data Factory – Part 2

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 … Continue reading Azure: Execute SSIS Package using Azure Data Factory – Part 2

Azure: Execute SSIS Package using Azure Data Factory – Part 1

In this blog post series, we'll learn how to execute SSIS package using Azure Data Factory. This topic is divided into 2 parts: In the first part we'll create the required Azure resources and in the second part we'll see how to deploy and execute the package. To begin we need following Azure resources: Azure … Continue reading Azure: Execute SSIS Package using Azure Data Factory – Part 1

SSMS: Integration Services Catalog node not visible

Recently, while working on Azure SQL Server to execute SSIS package, we found a strange issue. We created the Azure SQL Server from Azure Portal. We designed the SSIS package using SSDT. To deploy package to Azure SQL Server and execute there we need Azure-SSIS Integration Runtime(Azure-SSIS IR) to be setup. We created Azure Data … Continue reading SSMS: Integration Services Catalog node not visible

Plugin on Pre-Validation Stage in Dynamics 365 CE

Plug-in on pre-validation

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 null.

In case of pre-operation the child records were not available.

 

Another practical scenario

https://www.inogic.com/blog/2017/03/plugin-pre-validation-operation-to-show-an-error-message-as-well-as-log-the-error/

Hope it helps..

View original post