locked
Generic SQL error. RRS feed

  • Question

  • Hi all.

    From BizTalk application I do sending Execute request to CRM for create/update. But sometimes(not all times) CRM throw error with this content. Who can explore me cause of this error ? I couldn't found any useful information about this.

    Error Content

    This XML file does not appear to have any style information associated with it. The document tree is shown below.
    <s:Fault xmlns:s="http://www.w3.org/2003/05/soap-envelope">
    <s:Code>
    <s:Value>s:Sender</s:Value>
    </s:Code>
    <s:Reason>
    <s:Text xml:lang="en-US">Generic SQL error.</s:Text>
    </s:Reason>
    <s:Detail>
    <OrganizationServiceFault xmlns="http://schemas.microsoft.com/xrm/2011/Contracts" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
    <ActivityId>88a2d2da-7fda-4ff0-9ad6-e753f47f43ee</ActivityId>
    <ErrorCode>-2147204784</ErrorCode>
    <ErrorDetails xmlns:b="http://schemas.datacontract.org/2004/07/System.Collections.Generic"/>
    <Message>Generic SQL error.</Message>
    <Timestamp>2017-12-20T12:07:53.8045459Z</Timestamp>
    <ExceptionRetriable>false</ExceptionRetriable>
    <ExceptionSource i:nil="true"/>
    <InnerFault>
    <ActivityId>88a2d2da-7fda-4ff0-9ad6-e753f47f43ee</ActivityId>
    <ErrorCode>-2147204784</ErrorCode>
    <ErrorDetails xmlns:b="http://schemas.datacontract.org/2004/07/System.Collections.Generic"/>
    <Message>Generic SQL error.</Message>
    <Timestamp>2017-12-20T12:07:53.8045459Z</Timestamp>
    <ExceptionRetriable>false</ExceptionRetriable>
    <ExceptionSource i:nil="true"/>
    <InnerFault>
    <ActivityId>88a2d2da-7fda-4ff0-9ad6-e753f47f43ee</ActivityId>
    <ErrorCode>-2147204784</ErrorCode>
    <ErrorDetails xmlns:b="http://schemas.datacontract.org/2004/07/System.Collections.Generic"/>
    <Message>Generic SQL error.</Message>
    <Timestamp>2017-12-20T12:07:53.8045459Z</Timestamp>
    <ExceptionRetriable>false</ExceptionRetriable>
    <ExceptionSource i:nil="true"/>
    <InnerFault>
    <ActivityId>88a2d2da-7fda-4ff0-9ad6-e753f47f43ee</ActivityId>
    <ErrorCode>-2147204784</ErrorCode>
    <ErrorDetails xmlns:b="http://schemas.datacontract.org/2004/07/System.Collections.Generic"/>
    <Message>Generic SQL error.</Message>
    <Timestamp>2017-12-20T12:07:53.8045459Z</Timestamp>
    <ExceptionRetriable>false</ExceptionRetriable>
    <ExceptionSource i:nil="true"/>
    <InnerFault>
    <ActivityId>88a2d2da-7fda-4ff0-9ad6-e753f47f43ee</ActivityId>
    <ErrorCode>-2147220970</ErrorCode>
    <ErrorDetails xmlns:b="http://schemas.datacontract.org/2004/07/System.Collections.Generic"/>
    <Message>
    System.Data.SqlClient.SqlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #45288ED5
    </Message>
    <Timestamp>2017-12-20T12:07:53.8045459Z</Timestamp>
    <ExceptionRetriable>false</ExceptionRetriable>
    <ExceptionSource i:nil="true"/>
    <InnerFault i:nil="true"/>
    <OriginalException i:nil="true"/>
    <TraceText i:nil="true"/>
    </InnerFault>
    <OriginalException i:nil="true"/>
    <TraceText i:nil="true"/>
    </InnerFault>
    <OriginalException i:nil="true"/>
    <TraceText i:nil="true"/>
    </InnerFault>
    <OriginalException i:nil="true"/>
    <TraceText i:nil="true"/>
    </InnerFault>
    <OriginalException i:nil="true"/>
    <TraceText i:nil="true"/>
    </OrganizationServiceFault>
    </s:Detail>
    </s:Fault>

    Thanks in advance !


    Regards Edgar Tadevosyan

    Wednesday, December 20, 2017 12:39 PM

All replies