I got this error quite a few times before, when trying to configure User Profile Synchronization Connection. Normally it's caused by permission issue,
as this post explained.
This time it's different.
After some investigation, I think that
resetting Sync DB may fix the problem. But what's wrong with that database?
In windows events log, I found the error message attached at the end of this post. The highlight part says, "
Cannot insert duplicate key row in object 'dbo.mms_partition' with unique index 'IX_mms_partitionma_idpartition_name'. The duplicate key value is (f6faef68-af32-4387-ad64-aed58ba98394, DC=pw2,DC=local)"
I cannot believe that I missed it at the very beginning!
Run SQL Query "SELECT * FROM [SP_SyncDB].[dbo].[mms_partition]" on SharePoint database server, it's clear that "
f6faef68-af32-4387-ad64-aed58ba98394" is already there in the field "ma_id".
My guess is, for some unknown reason, SharePoint User Profile Service tries to create a new "Connection" instead of utilizing existing one.
So I deleted the existing User Profile Synchronization
Connection through Central Admin site, then recreated it.
It works well. :-)
============= Error message in windows events log ==============
The server encountered an unexpected error while performing an operation for a management agent.
"ERR: MMS(4596): sql.cpp(5714): Query (insert into [mms_partition] ([ma_id],[partition_id],[partition_name],[version_number],[ma_custom_data_xml],[is_selected],[filter_xml],[filter_hints_xml],[creation_date],[modification_date],[allowed_operations_flag],[current_export_batch_number],[current_export_sequence_number],[last_successful_export_batch_number]) values ( 'F6FAEF68-AF32-4387-AD64-AED58BA98394','F54CA4AE-2FFA-4517-BF61-7173795CE0B5',N'DC=pw2,DC=local',1,N'
DC=pw2,DC=localpw2.local{901bed2e-5007-4849-8904-1b868995a6b6}1101',1,N'
contact
container
domainDNS
group
inetOrgPerson
user
crossRef
organizationalUnit
CN=Computers,DC=pw2,DC=local
OU=Domain Controllers,DC=pw2,DC=local
CN=ForeignSecurityPrincipals,DC=pw2,DC=local
CN=Managed Service Accounts,DC=pw2,DC=local
OU=Microsoft Exchange Security Groups,DC=pw2,DC=local
CN=Microsoft Exchange System Objects,DC=pw2,DC=local
CN=Program Data,DC=pw2,DC=local
CN=System,DC=pw2,DC=local
CN=Builtin,DC=pw2,DC=local
CN=Infrastructure,DC=pw2,DC=local
CN=LostAndFound,DC=pw2,DC=local
CN=NTDS Quotas,DC=pw2,DC=local
CN=TPM Devices,DC=pw2,DC=local
DC=ForestDnsZones,DC=pw2,DC=local
DC=DomainDnsZones,DC=pw2,DC=local
CN=Configuration,DC=pw2,DC=local
CN=Users,DC=pw2,DC=local
',N'
contact
top
person
organizationalPerson
contact
1
container
top
container
1
domainDNS
top
domain
domainDNS
1
group
top
group
1
inetOrgPerson
top
person
organizationalPerson
user
inetOrgPerson
1
user
top
person
organizationalPerson
user
1
crossRef
top
crossRef
1
organizationalUnit
top
organizationalUnit
1
msExchTransportSettings
top
container
msExchTransportSettings
0
msImaging-PSPs
top
container
msImaging-PSPs
0
msExchProtocolCfgProtocolContainer
top
container
msExchProtocolCfgProtocolContainer
0
msExchMDBContainer
top
container
msExchMDBContainer
0
msExchProtocolCfgHTTPFilters
top
container
msExchProtocolCfgHTTPFilters
0
msExchAddressListServiceContainer
top
container
msExchAddressListServiceContainer
0
msExchInformationStore
top
container
msExchInformationStore
0
msExchOmaDeviceType
top
container
msExchOmaDeviceType
0
msExchContainer
top
container
msExchContainer
0
msExchAvailabilityConfig
top
container
msExchAvailabilityConfig
0
msExchOmaConfigurationContainer
top
container
msExchOmaConfigurationContainer
0
msExchAdvancedSecurityContainer
top
container
msExchAdvancedSecurityContainer
0
msExchPublicFolderTreeContainer
top
container
msExchPublicFolderTreeContainer
0
msExchStorageGroup
top
container
msExchStorageGroup
0
msExchAddressRewriteConfiguration
top
container
msExchAddressRewriteConfiguration
0
msExchOmaContainer
top
container
msExchOmaContainer
0
msExchOmaDataSource
top
container
msExchOmaDataSource
0
msExchOmaDeliveryProvider
top
container
msExchOmaDeliveryProvider
0
msExchChatVirtualNetwork
top
container
msExchChatVirtualNetwork
0
msExchContentConfigContainer
top
container
msExchContentConfigContainer
0
msExchTransportRuleCollection
top
container
msExchTransportRuleCollection
0
rpcContainer
top
container
rpcContainer
0
msExchReplicationConnectorContainer
top
container
msExchReplicationConnectorContainer
0
msExchChatNetwork
top
container
msExchChatNetwork
0
msExchServersContainer
top
container
msExchServersContainer
0
msExchRoutingGroupContainer
top
container
msExchRoutingGroupContainer
0
msExchPoliciesContainer
top
container
msExchPoliciesContainer
0
msExchConnectors
top
container
msExchConnectors
0
msExchMDBAvailabilityGroupContainer
top
container
msExchMDBAvailabilityGroupContainer
0
msExchProtocolCfgSMTPIPAddressContainer
top
container
msExchProtocolCfgSMTPIPAddressContainer
0
msExchMonitorsContainer
top
container
msExchMonitorsContainer
0
msExchIMGlobalSettingsContainer
top
container
msExchIMGlobalSettingsContainer
0
msExchConfigurationContainer
top
container
msExchConfigurationContainer
0
msExchOmaCarrier
top
container
msExchOmaCarrier
0
msExchOmaDeviceCapability
top
container
msExchOmaDeviceCapability
0
msExchProtocolCfgSharedContainer
top
container
msExchProtocolCfgSharedContainer
0
msExchSystemObjectsContainer
top
container
msExchSystemObjectsContainer
0
msExchAdminGroupContainer
top
container
msExchAdminGroupContainer
0
msExchRoutingGroup
top
container
msExchRoutingGroup
0
groupPolicyContainer
top
container
groupPolicyContainer
0
msExchOrganizationContainer
top
container
msExchOrganizationContainer
0
msExchConferenceContainer
top
container
msExchConferenceContainer
0
computer
top
person
organizationalPerson
user
computer
0
msPKI-Key-Recovery-Agent
top
person
organizationalPerson
user
msPKI-Key-Recovery-Agent
0
msExchDepartment
top
organizationalUnit
msExchDepartment
0
','2015-02-17 23:23:17.924','2015-02-17 23:23:17.924',1073741854,1,0,0)) performed with error
ERR: MMS(4596): sql.cpp(5767): The statement has been terminated.
ERR: MMS(4596): sql.cpp(5775): hrError: 0x80040e2f, dwMinor: 3621
ERR: MMS(4596): sql.cpp(5930): SQL error: 01000, native: 3621
ERR: MMS(4596): sql.cpp(5767):
Cannot insert duplicate key row in object 'dbo.mms_partition' with unique index 'IX_mms_partitionma_idpartition_name'. The duplicate key value is (f6faef68-af32-4387-ad64-aed58ba98394, DC=pw2,DC=local).
ERR: MMS(4596): sql.cpp(5775): hrError: 0x80040e2f, dwMinor: 2601
ERR: MMS(4596): sql.cpp(5930): SQL error: 23000, native: 2601
BAIL: MMS(4596): sql.cpp(3742): 0x80040e2f
BAIL: MMS(4596): sql.cpp(3639): 0x80040e2f
BAIL: MMS(4596): partition.cpp(2095): 0x80040e2f
BAIL: MMS(4596): mastate.cpp(4605): 0x80040e2f
BAIL: MMS(4596): ma.cpp(1521): 0x80040e2f
Forefront Identity Manager 4.0.2450.49"
Simply want to say your article is as astounding.
ReplyDeleteThe clarity for your submit is just spectacular and that i could suppose you’re a professional