locked
Error: Singleton Retrieve Query should not return more than 1 record + queuebase table migration from crm3 to crm 2013 RRS feed

  • Question

  • Dear CRM Experts,

    Need your help on migration CRM 3 to CRM 2013. After the migration of QueueBase table by using the SQL Scripts, I face so many errors when I save the Contact form.

    Error: Singleton Retrieve Query should not return more than 1 record + queuebase table migration from crm3 to crm 2013 - the Detailed Error message is here below:

    Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Crm Internal Exception: Singleton Retrieve Query should not return more than 1 record. Query: System.Data.SqlClient.SqlCommandDetail:
    <OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
      <ErrorCode>-2147220913</ErrorCode>
      <ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />
      <Message>Crm Internal Exception: Singleton Retrieve Query should not return more than 1 record. Query: System.Data.SqlClient.SqlCommand</Message>
      <Timestamp>2015-06-07T04:59:46.0719388Z</Timestamp>
      <InnerFault i:nil="true" />
      <TraceText i:nil="true" />
    </OrganizationServiceFault>

    Please help me out. Thank you.


    Thanks, - Israel Pradeep, - Software Engineer & PMP & B.I - Entrepreneur. - I am glad I could help!!! - If this post answers your question, please click “Mark as Answer” on the post and “Mark as Helpful”. For More Information, please feel free to visit our website- http://xrmxtensibles.wordpress.com/

    Monday, June 8, 2015 10:21 PM

All replies

  • Hi,

    Anyone ever found a solution for this issue? I get the same error "Singleton Retrieve Query should not return more than 1 record" when I import a CRM4.0 organisation into a CRM2011 environment.

    Any help is very much appriciated.

    Kind Regards,

    Peter

    Friday, February 5, 2016 10:27 AM
  • It sounds like a data error somewhere. The original post referred to a 'migration of QueueBase table by using the SQL Scripts', which was probably to source of the problem there, but that may not apply here.

    Do you know of any direct data modification that's been done via SQL ? If so, that would be one place to start. Or, do you get any information from your error message about which entity is causing the problem ?

    Otherwise I think the next option is to enable SQL tracing during the import, to try and identify what SQL commands were executed at the time of the error


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Friday, February 5, 2016 11:02 AM
    Moderator