SQL Generic Error When Notes are Clicked RRS feed

  • Question

  • Hi,

    I am using dynamic CRM 2015 version on Premises.When user  click on notes in social pane.An error shows up which is "Generic SQL Error".

    Here is the log

    Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Generic SQL error.Detail: 
    <OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
      <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
      <Message>Generic SQL error.</Message>
      <InnerFault i:nil="true" />
      <TraceText i:nil="true" />

    Actually the main issue is that the error is only showing for a single user not all of them and this happens every time when he click on Notes within a Pipeline Opportunity .Any kind of Help/Suggestion will be appreciated.


    Wednesday, April 13, 2016 9:46 PM

All replies

  • If you enable tracing you should get a more useful error. Strange that it's user-specific - one possibility is you've a very large number of notes (and maybe a complex sharing structure) and the query is timing out

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

    Thursday, April 14, 2016 5:47 AM