SharePoint UPS troubleshooting: Unable to process Put message

  • Article

Error message

Sorry, something went wrong

Unable to process Put message

Technical Details

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.