Dual-write connection set error: An item with the same key has already been added
If you happen to see this error message then you have duplicate records in cdm_company entity in CDS environment. Check for cdm_companycode field this is normally not allowed but have a look and delete the ones with duplicates.
Dual-write integration for Cross-Company data in D365 Finance and SCM
Dual-write does not work with the cross company data sharing policies in D365 FinOps (there are so many names but I am using this name for reference 😊). Brief overview about cross company data sharing policy first to set the base for the readers, the Cross-Company data sharing lets you have your data accessible from multiple legal entities (companies in D365 FinOps). For example, if you setup a policy for vendors to be crossed-company then whenever you create a new vendor it will be created in all data sharing legal entities. https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/sysadmin/cross-company-data-sharing Now, What happened when you a table under cross-company data sharing (e.g. VendTable) and want to sync vendors through dual-write? Since, VendTable is one of the data sources for Vendors data entity (dual-write entity map) and we know dual-write does not work well with cross-company data sharing by design. You get following error message when you try to Run the entity map. “Copying pre-existing data completed with errors. For additional details, go to initial sync details tab.” The error message is confusing and does not reflect the actual issue behind the scene – you will never be able to figured it out what is wrong until you raise it with MS dual-write team and share the activity Id of the job with them to investigate the telemetry (you don’t have access to check this one 😒) then they share the root cause. However, You can also investigate by putting a breakpoint in method validateDataSharingEnabledForEntityTableBeforDualWriteEnable() of class SysDataSharingValidation. /// <summary> /// Validates that cross company data sharing is not enabled when enabling Dual Write. /// </summary> /// <param name = “_entityName”>The name of the entity containing the table being enabled</param> /// <param name = “_tableName”>Table in entity</param> /// <param name = “_dataAreaId”>Company info</param> [SubscribesTo(classStr(BusinessEventsRegistrationBase), staticdelegatestr(BusinessEventsRegistrationBase, onTableEnabled))] public static void validateDataSharingEnabledForEntityTableBeforDualWriteEnable(str _entityName, str _tableName, DataAreaId _dataAreaId) { SysDataSharingOrganization sysDataSharingOrganizationTable; SysDataSharingRuleEnabled sysDataSharingRuleEnabledTable; select firstonly SharedTableName from sysDataSharingRuleEnabledTable where sysDataSharingRuleEnabledTable.SharedTableName == _tableName join DataSharingPolicy, DataSharingCompany from sysDataSharingOrganizationTable where sysDataSharingRuleEnabledTable.DataSharingPolicy == sysDataSharingOrganizationTable.DataSharingPolicy && sysDataSharingOrganizationTable.DataSharingCompany == _dataAreaId; if (sysDataSharingRuleEnabledTable) { throw error(strFmt(“@DataSharing:CrossCompanySharingError“, _entityName, sysDataSharingOrganizationTable.DataSharingPolicy)); } }