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

D365: Error while importing unmanaged solution “Solution patch with version x.x.x.x already exists. Updating patch is not supported.”

Recently, we were working on D365 V9 upgrade from D365 V8. We had 2 DEV instances: DEV1 on D365 V8 as backup instance for making changes which need to be moved to PROD before upgrade DEV2 on D365 V9 for doing upgrade related activities/changes We had already created a patch for the solution in DEV1 … Continue reading D365: Error while importing unmanaged solution “Solution patch with version x.x.x.x already exists. Updating patch is not supported.”

USD 4: USD Client crashing with error “multiple_matching_tokens_detected”

Recently, while working on USD 4, we encountered one weird issue. After opening USD client, we selected O365 and provided credential to login. After selecting the instance to connect, USD client was crashing. Checking the log files, at the location "C:\Users\<UserName>\AppData\Roaming\Microsoft\Microsoft Dynamics® 365 Unified Service Desk\4.0.0.993",  we found the below exception "multiple_matching_tokens_detected: The cache contains … Continue reading USD 4: USD Client crashing with error “multiple_matching_tokens_detected”

Azure: Copy Data from CSV file to D365 instance using Azure Data Factory

In this post, we'll see how to upload data in CSV file to D365 instance using Azure Data Factory. We'll need following Azure resources for this demo: Azure Data Factory Blob Storage Let's go through the below steps to see it in action: Login to Azure Portal Click on Create a resource --> Select Storage … Continue reading Azure: Copy Data from CSV file to D365 instance using Azure Data Factory

D365 V9{Upgrade}: Sharing record using Web API and custom action

In D365 V8, GrantAccessRequest message was not available for which we were using SOAP request in JavaScript to share a record with a user. As part of upgrade activities, since SOAP requests are going to be deprecated, now we have replaced our SOAP request with Web API and calling custom action from Web API as we … Continue reading D365 V9{Upgrade}: Sharing record using Web API and custom action

D365: Enable Cross Origin Requests in Internet Explorer

Recently, we had a requirement to load data from external domain in a web resource on a Phone Call form. While testing the functionality in IE 11, it was not working. Debugging the code using Developer Tools, we got the below "Access is denied" error in Console window: To fix this issue, we changed the … Continue reading D365: Enable Cross Origin Requests in Internet Explorer

D365 V9{Upgrade}: Icebreakers section on Contact Form

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 corner D365 V9: New Icebreakers section at … Continue reading D365 V9{Upgrade}: Icebreakers section on Contact Form

Azure: Copy data from one database to another using Azure Data Factory – II

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 … Continue reading Azure: Copy data from one database to another using Azure Data Factory – II

Azure: Copy data from one database to another using Azure Data Factory – I

In this post, we will talk about how to copy data of a table from one database to another using Azure. Here we are using the following Azure resources: Azure SQL Server Azure SQL Database Azure Data Factory To begin, let's login to Azure portal. After successful login let's go through the below steps to see … Continue reading Azure: Copy data from one database to another using Azure Data Factory – I

D365 V9{Upgrade}: Ribbon Button Enable Rule Custom JS Code gives error “Cannot read property ‘getFormContext’ of undefined”

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, … Continue reading D365 V9{Upgrade}: Ribbon Button Enable Rule Custom JS Code gives error “Cannot read property ‘getFormContext’ of undefined”

Azure: Error while connecting to Azure SQL Server “Cannot open server ‘…’ requested by the login. Client with IP address ‘…’ is not allowed to access the server”

Recently, while accessing azure SQL server from SQL Server Management Studio, we got the below error:  "Cannot open server 'server_name' requested by the login. Client with IP address 'xxx.xxx.xxx.xxx' is not allowed to access the server". To fix this issue, in Azure portal, we added the IP address of machine from which we were trying … Continue reading Azure: Error while connecting to Azure SQL Server “Cannot open server ‘…’ requested by the login. Client with IP address ‘…’ is not allowed to access the server”

D365 V9{Upgrade}: Error while upgrading NuGet package Microsoft.CrmSdk.XrmTooling.CoreAssembly to v9.0.2.5

Recently, while upgrading our D365 instance from V8 to V9, we had some batch jobs for integration which were running on v9.0.2.4 of CRM related NuGet packages. As part of V9 upgrade we need to upgrade those NuGet packages to v9.0.2.5. While upgrading XrmTooling.CoreAssembly to v9.0.2.5, we were getting the below error: "Unable to resolve dependencies. … Continue reading D365 V9{Upgrade}: Error while upgrading NuGet package Microsoft.CrmSdk.XrmTooling.CoreAssembly to v9.0.2.5

Azure: Web Job Deployment Error “The local data store is currently in use by another operation”

Recently, we had written a batch job to connect to D365 and do some operation on a schedule. While deploying the batch job from Visual Studio as a web job we got the below error: "The local data store is currently in use by another operation. Please wait and then try your operation again. If … Continue reading Azure: Web Job Deployment Error “The local data store is currently in use by another operation”

D365: Retrieve, Associate, Disassociate N:N Related Records using C#

In this post, we'll talk about an example where we need to retrieve N:N related records and code snippet for the same. We are using ClickDimensions component in D365 for marketing purpose. We came across a requirement where we were supposed to disassociate the related records(Marketing Lists) from a record(Email Send a ClickDimensions entity) based … Continue reading D365: Retrieve, Associate, Disassociate N:N Related Records using C#

D365 V9{Upgrade}: Client API Change for openEntityForm

Prior to D365 V9, we were using Xrm.Utility.openEntityForm() to open an existing record or to open a create form of an entity providing some additional parameters. However, in D365 V9 as it has been deprecated, we need to use Xrm.Navigation.openForm() to perform the same operation. Here's an example of the change in API along with … Continue reading D365 V9{Upgrade}: Client API Change for openEntityForm

D365 V9{Upgrade}: Client API update for alert and confirm

In D365 V9, as per Microsoft documentation, Xrm.Utility.alertDialog() should be replaced by Xrm.Navigation.openAlertDialog() and Xrm.Utility.confirmDialog() should be replaced by Xrm.Navigation.openConfirmDialog(). Let's take an example of both alert and confirm dialog box and see what exact changes we need to do in JS code apart from the above library change. alert: D365 V8: D365 V9: confirm: D365 V8: D365 V9: … Continue reading D365 V9{Upgrade}: Client API update for alert and confirm

D365 V9{Upgrade}: “v_5 is not a function” error while adding custom filter to lookup

Recently, after upgrading our one of the D365 instance to V9, we came across an issue with custom filtering of lookup. We were using below piece of code snippet to add custom filter: and below is the definition of the addFilterOpp method: fetchQuery = "<filter type='and'>" + "<condition attribute='sab_brandid' operator='eq' value='" + brandId + "' … Continue reading D365 V9{Upgrade}: “v_5 is not a function” error while adding custom filter to lookup

Azure Service Bus Queue Integration with D365 – Part 1

In this series, we'll see how we can integrate Azure Service Bus Queue with D365. This series has been divided into 2 parts: Part 1: How we can create a service bus queue in Azure portal and registration of service endpoint using plugin registration tool Part 2: Do some operation in D365 and the message … Continue reading Azure Service Bus Queue Integration with D365 – Part 1

Power BI: Organisational Content Pack not visible to other users

Recently, we created a content pack in power BI with access to entire Organisation as shown below: After creating it, we used another user to search for this content pack in Power BI and see the result. However, we didn't find any content pack by clicking on Get Data --> My Organisation or Get Data … Continue reading Power BI: Organisational Content Pack not visible to other users

SSIS: The component returned a failure code when the pipeline engine called PrimeOutput()

Recently, while working on SSIS package, we encountered the error after few minutes of execution of package. To get rid of this issue, we implemented one workaround: Go to Data Flow --> Properties Decrease the default buffer size to 1MB i.e. 1048576 Bytes Decrease the default Max Buffer rows to 1000 as shown below: After … Continue reading SSIS: The component returned a failure code when the pipeline engine called PrimeOutput()

SSIS: The column with the sortkeyposition value of 1 is not valid. It should be 0

Recently, while working on one of the existing SSIS package, we found that there were number of sort blocks in SSIS where as it could have been sorted at the source itself and informing the SSIS package that the data is already sorted at the source and can be processed further. Another disadvantage of using … Continue reading SSIS: The column with the sortkeyposition value of 1 is not valid. It should be 0

SSIS: Excel Connection Manager Error “Class not registered”

Recently, we were working on SSIS to get data from AX to the staging tables. As part of the requirement, we were also using Excel Connection Manager to read the data from one of the excel file and load it to a table. After completing the development, we executed the package and it was successfully … Continue reading SSIS: Excel Connection Manager Error “Class not registered”

SSIS: Login failed for user “NT AUTHORITY\ANONYMOUS LOGON”

Recently, we were working on SSIS for ETL(Extract,  Transform and Load) to get the data from AX and push to the staging tables. We were using linked server for AX and we were using Windows Authentication for connecting to it. While running the package from SSDT, it got executed successfully. So, we deployed the packages to … Continue reading SSIS: Login failed for user “NT AUTHORITY\ANONYMOUS LOGON”

SSIS: “The version number in the package is not valid. The version number can’t be greater that current version number”

Recently, while working on SSIS to get data from AX and putting in our staging tables, we faced a weird compatibility issue between SQL Server and SSDT version we were using. We were using database as SQL Server 2012 and SSDT for VS 2013. After completing our development, while executing the package from SSDT, it … Continue reading SSIS: “The version number in the package is not valid. The version number can’t be greater that current version number”

SSIS: An error occurred while assigning a value to the variable

Recently, while working on SSIS, we came across a scenario where we had to assign multiple values to multiple variables to use them in package later. We used "Execute SQL Task" to assign those values to the variables. The SQL query we used, was returning single row with 12 columns. We wanted to store the … Continue reading SSIS: An error occurred while assigning a value to the variable