Fixed – CRM service call returned an error: An error has occurred when retrieving metadata for CRM entity ‘table’: The source argument contains duplicate keys – Dataverse/ Dynamics 365 / SSIS


Recently while trying to retrieve OptionSet Metadata using our favorite KingswaySoft SSIS Toolkit we got the below error.

Same error for prod also – [CDS Source [2]] Error: An error occurred with the following error message: “KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmServiceException: CRM service call returned an error: An error has occurred when retrieving metadata for CRM entity ‘copilotexamplequestion’: The source argument contains duplicate keys. (SSIS Integration Toolkit for Microsoft Dynamics 365, v23.2.2.32701 – DtsDebugHost, v16.0.5270.0)System.ArgumentException.  : The source argument contains duplicate keys.”.

More on Metadata Source in CDS Source Component – https://www.kingswaysoft.com/blog/2022/10/18/Introducing-the-Metadata-Source-Type-in-CRMCDS-Source-Component

Interestingly we were getting this issue while running the package in the UAT and Production environment, it was working fine for the Dev environment. Also, it was OOB Table and we could compare and see it to be the same across all the environments.

Well, the way we could progress here is to query and get the required details from the stringmap table.

e.g.

A screenshot of a computer Description automatically generated

Hope it helps..

Advertisements

Fixed – CRM service call returned an error: The number of decimal places on quantity needs to be 0 or less for Quote Product (Dynamics 365 / Dataverse/SSIS)


While running an SSIS Package that creates Quote Product records, we got the below error –

CRM service call returned an error: The number of decimal places on quantity needs to be 0 or less

If we see the decimal places seem to be specified properly for the quantity field in the source file as we had other records created properly from the source.

Well this occurs when we try to add Quote Product and specify decimal precision in quantity which is more than what has been specified in the associate product.

Below we can see the decimal supported is 0 for the product associated to the quote product record.

A screenshot of a computer Description automatically generated

To fix this problem, either we have to increase the decimal supported value or remove decimal precision from the quantity in the quote product based on the product in question.

Hope it helps..

Advertisements

Resizing of side panes now possible – 2024 Release Wave 2 (Model-driven apps / Dynamics 365)


With 2024 Release Wave 2, now we can resize the side panes inside the Model-driven app.

Side panes are used for Teams chat, Copilot Chat, loading Web Resource, etc.

With Release Wave 2 enabled, we get the option to drag and adjust the size.

A screenshot of a computer Description automatically generated

Below we have dragged it to maximum size.

A screenshot of a computer Description automatically generated

Get all details

Hope it helps.. 

Advertisements

New features added in Grid– Dataverse / Dynamics 365


With Release Wave 2, we can see the below features added to Grid.

The option to Group By, Column Width, Move Left and Move Right.

A screenshot of a computer Description automatically generated

Group By (Rating) –

A screenshot of a computer Description automatically generated

Move Left and Move Right as expected will move the selected column accordingly. Not only that we can also Drag and Drop the columns, here we have dragged the Rating column as the 1st column.

A screenshot of a computer Description automatically generated

Column Width – allows us to specify the preferred width of the column.

A screenshot of a computer Description automatically generated

Totals > None, Average, Maximum, Minimum, Sum.

For the numerical column, Annual Revenue in this case we get the option to calculate the total

A screenshot of a computer Description automatically generated

Selecting Total > Sum, adds a row at the bottom, showing the total sum

A screenshot of a computer Description automatically generated

Similarly selecting minimum shows the minimum value.

A screenshot of a computer Description automatically generated

Hope it helps..

Advertisements

How to configure Site.Selected API permissions – SharePoint Online / PnP PowerShell


Let us add/ update the API Permissions for the App

More on registering App – https://nishantrana.me/2024/07/30/calling-sharepoint-online-api-using-azure-ad-app-only-permissions-using-certificate-auth/

Here we have selected the Sites.Selected permission.

A screenshot of a computer Description automatically generated

Also granted the Admin consent.

A screenshot of a computer Description automatically generated
A screenshot of a computer Description automatically generated

Now if we run our code we will get the 403 Forbidden error.

This is because we have selected the Sites.Selected permission, but have not specified the site and the permission.

For that, we can use either Graph API or PnP PowerShell.

Let us use PnP PowerShell here.

Grant-PnPAzureADAppSitePermission -AppId “{app-id}” -DisplayName “{app-name}” -Site “https://{tenant}.sharepoint.com/sites/{site-name}” -Permissions “Write”

Grant-PnPAzureADAppSitePermission -AppId “d7eaeeb7-ef0a-474d-9b94-567013576c14” -DisplayName “SharePointApp” -Site “https://w72tk.sharepoint.com/sites/MyTeamSite” -Permissions “Write”

A computer screen with text and arrows Description automatically generated

This time as expected we do not get the Forbidden error.

The other Permissions that we can specify are – Read, Manage, FullControl.

Get all the details here –https://pnp.github.io/powershell/cmdlets/Grant-PnPAzureADAppSitePermission.html

Hope it helps..

Advertisements

Fixed – The term ‘Connect-PnPOnline’ is not recognized as the name of a cmdlet, function, script file, or operable program – PowerShell


If you are getting the below error even after running the Install-Module PnP.PowerShell command, it could be because of the older version of PowerShell.

The minimum PowerShell version required for PnP.PowerShell is PowerShell 7.2.

Check the current version using the command – $PSVersionTable

A computer screen shot of a program Description automatically generated

Below are different ways to get the latest version of PowerShell

https://learn.microsoft.com/en-gb/powershell/scripting/install/installing-powershell-on-windows?view=powershell-7.4

Here we have used the Winget (Windows Package Manager) tool to install it.

winget search Microsoft.PowerShell

winget install –id Microsoft.Powershell –source winget

A screenshot of a computer Description automatically generated

We can see the PowerShell 7 installed.

Now we can install the PnP.PowerShell module and connect to our site successfully.

A computer screen with text Description automatically generated

https://evolvous.com/learn-from-expert/how-to-install-pnp-powershell-and-connect-with-sharepoint-online/

1–2 minutes

Hope it helps..

Advertisements

Nishant Rana's Weblog

Everything related to Microsoft .NET Technology

Skip to content ↓