SharePoint UPS troubleshooting: Unable to process Put message
Error message
Sorry, something went wrong
Unable to process Put message
Troubleshoot issues with Microsoft SharePoint Foundation.
Correlation ID: bbad6d9d-7cfd-209e-563f-53cd4480d105
Date and Time: 3/30/2016 2:00:29 PM
Troubleshooting
Upon investigating the Windows event logs:
FIMSynchronizationService
EventID 6309
The server encountered an unexpected error while performing an operation for a management agent.
FIMSynchronizationService
EventID 6309
The server encountered an unexpected error while performing an operation for a management agent.
"ERR: MMS(10952): 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 ( '98C42074-FFDD-4092-B852-89F68D7E9834','4046657A-8DB0-4D64-BC44-E9452E3C58AF',N'DC=mydomain,DC=local',1,N'<adma-partition-data><dn>DC=mydomain,DC=local</dn><name>mydomain.local</name><guid>{7019fbb9-eedc-4d55-a95f-44068fb6a4be}</guid><sign-and-seal>1</sign-and-seal><is-domain>1</is-domain><ssl-bind crl-check="0">0</ssl-bind><dc-failover>1</dc-failover><ui-data /></adma-partition-data>',1,N'<filter>
<object-classes>
<object-class>contact</object-class>
<object-class>container</object-class>
<object-class>domainDNS</object-class>
<object-class>group</object-class>
<object-class>inetOrgPerson</object-class>
<object-class>user</object-class>
<object-class>crossRef</object-class>
<object-class>organizationalUnit</object-class>
</object-classes>
<containers>
<exclusions>
<exclusion>CN=Builtin,DC=mydomain,DC=local</exclusion>
<exclusion>CN=Infrastructure,DC=mydomain,DC=local</exclusion>
<exclusion>CN=LostAndFound,DC=mydomain,DC=local</exclusion>
<exclusion>CN=NTDS Quotas,DC=mydomain,DC=local</exclusion>
<exclusion>DC=ForestDnsZones,DC=mydomain,DC=local</exclusion>
<exclusion>DC=DomainDnsZones,DC=mydomain,DC=local</exclusion>
<exclusion>CN=Configuration,DC=mydomain,DC=local</exclusion>
</exclusions>
<inclusions>
<inclusion>CN=Computers,DC=mydomain,DC=local</inclusion>
<inclusion>OU=Domain Controllers,DC=mydomain,DC=local</inclusion>
<inclusion>CN=ForeignSecurityPrincipals,DC=mydomain,DC=local</inclusion>
<inclusion>CN=Managed Service Accounts,DC=mydomain,DC=local</inclusion>
<inclusion>CN=Program Data,DC=mydomain,DC=local</inclusion>
<inclusion>CN=System,DC=mydomain,DC=local</inclusion>
<inclusion>CN=Users,DC=mydomain,DC=local</inclusion>
<inclusion>DC=mydomain,DC=local</inclusion>
</inclusions>
</containers>
</filter>
',N'<filter-hints>
<object-classes>
<object-class>
<name>contact</name>
<hierarchy>
<object-class>top</object-class>
<object-class>person</object-class>
<object-class>organizationalPerson</object-class>
<object-class>contact</object-class>
</hierarchy>
<included>1</included>
</object-class>
<object-class>
<name>container</name>
<hierarchy>
<object-class>top</object-class>
<object-class>container</object-class>
</hierarchy>
<included>1</included>
</object-class>
<object-class>
<name>domainDNS</name>
<hierarchy>
<object-class>top</object-class>
<object-class>domain</object-class>
<object-class>domainDNS</object-class>
</hierarchy>
<included>1</included>
</object-class>
<object-class>
<name>group</name>
<hierarchy>
<object-class>top</object-class>
<object-class>group</object-class>
</hierarchy>
<included>1</included>
</object-class>
<object-class>
<name>inetOrgPerson</name>
<hierarchy>
<object-class>top</object-class>
<object-class>person</object-class>
<object-class>organizationalPerson</object-class>
<object-class>user</object-class>
<object-class>inetOrgPerson</object-class>
</hierarchy>
<included>1</included>
</object-class>
<object-class>
<name>user</name>
<hierarchy>
<object-class>top</object-class>
<object-class>person</object-class>
<object-class>organizationalPerson</object-class>
<object-class>user</object-class>
</hierarchy>
<included>1</included>
</object-class>
<object-class>
<name>crossRef</name>
<hierarchy>
<object-class>top</object-class>
<object-class>crossRef</object-class>
</hierarchy>
<included>1</included>
</object-class>
<object-class>
<name>organizationalUnit</name>
<hierarchy>
<object-class>top</object-class>
<object-class>organizationalUnit</object-class>
</hierarchy>
<included>1</included>
</object-class>
<object-class>
<name>groupPolicyContainer</name>
<hierarchy>
<object-class>top</object-class>
<object-class>container</object-class>
<object-class>groupPolicyContainer</object-class>
</hierarchy>
<included>0</included>
</object-class>
<object-class>
<name>msExchConfigurationContainer</name>
<hierarchy>
<object-class>top</object-class>
<object-class>container</object-class>
<object-class>msExchConfigurationContainer</object-class>
</hierarchy>
<included>0</included>
</object-class>
<object-class>
<name>rpcContainer</name>
<hierarchy>
<object-class>top</object-class>
<object-class>container</object-class>
<object-class>rpcContainer</object-class>
</hierarchy>
<included>0</included>
</object-class>
<object-class>
<name>msImaging-PSPs</name>
<hierarchy>
<object-class>top</object-class>
<object-class>container</object-class>
<object-class>msImaging-PSPs</object-class>
</hierarchy>
<included>0</included>
</object-class>
<object-class>
<name>msPKI-Key-Recovery-Agent</name>
<hierarchy>
<object-class>top</object-class>
<object-class>person</object-class>
<object-class>organizationalPerson</object-class>
<object-class>user</object-class>
<object-class>msPKI-Key-Recovery-Agent</object-class>
</hierarchy>
<included>0</included>
</object-class>
<object-class>
<name>computer</name>
<hierarchy>
<object-class>top</object-class>
<object-class>person</object-class>
<object-class>organizationalPerson</object-class>
<object-class>user</object-class>
<object-class>computer</object-class>
</hierarchy>
<included>0</included>
</object-class>
</object-classes>
</filter-hints>
','2016-03-30 18:00:27.207','2016-03-30 18:00:27.207',1073741854,1,0,0)) performed with error
ERR: MMS(10952): sql.cpp(5767): The statement has been terminated.
ERR: MMS(10952): sql.cpp(5775): hrError: 0x80040e2f, dwMinor: 3621
ERR: MMS(10952): sql.cpp(5930): SQL error: 01000, native: 3621
ERR: MMS(10952): 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 (98c42074-ffdd-4092-b852-89f68d7e9834, DC=mydomain,DC=local).
ERR: MMS(10952): sql.cpp(5775): hrError: 0x80040e2f, dwMinor: 2601
ERR: MMS(10952): sql.cpp(5930): SQL error: 23000, native: 2601
BAIL: MMS(10952): sql.cpp(3742): 0x80040e2f
BAIL: MMS(10952): sql.cpp(3639): 0x80040e2f
BAIL: MMS(10952): partition.cpp(2095): 0x80040e2f
BAIL: MMS(10952): mastate.cpp(4605): 0x80040e2f
BAIL: MMS(10952): ma.cpp(1521): 0x80040e2f
Forefront Identity Manager 4.0.2450.51"
Solution:
Delete the connection and try it again.