we have a sharepoint 2016 on prem with an user profile connection configured for active directory. we have also an claim provider for ADFS for the same domain used in an extranet scenario. When we try to add the the 'synchronization connection' configured with the ADFS claim provider we get
Cannot insert duplicate key row in object 'dbo.ADImportDCMapping' with unique index 'IX_ADImportDcMapping_DCName'. The duplicate key value is (edited.local, DC=edited,DC=local). The statement has been terminated.
is it possible to add a second connection to the same domain with a different authentication provider? we have a similar setup on an sharepoint 2013 that gave us no issue and on the profile config database we see no rows, while in the sharepoint 2016 profile we effectively see one row.
we have also tried different contaner but the definition of the index IX_ADImportDcMapping_DCName prevent us from using the same domain.