Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM forum / SQL Server error - whe...
Microsoft Dynamics CRM forum
Suggested answer

SQL Server error - when user tries to run a dialog

(0) ShareShare
ReportReport
Posted on by Adventure1310 5

Our users recently started receiving a very generic SQL Server error when trying to use dialogs in CRM. 

As an admin, I am still able to run the dialogs just fine. The dialogs have all worked for many years in the past. Has anyone come across this or have a solution?

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=xxxxxxxxxxxxx]]: SQL timeout expired.Detail:

<OrganizationServiceFault xmlns:i=http://www.w3.org/2001/XMLSchema-instance xmlns=http://schemas.microsoft.com/xrm/2011/Contracts>

  <ActivityId>adf22710-2732-4907-811b-b17c715913e2</ActivityId>

  <ErrorCode>-2147204783</ErrorCode>

  <ErrorDetails xmlns:d2p1=http://schemas.datacontract.org/2004/07/System.Collections.Generic />

  <Message>SQL timeout expired.</Message>

  <Timestamp>2023-01-05T22:55:13.4732791Z</Timestamp>

  <ExceptionRetriable>false</ExceptionRetriable>

  <ExceptionSource i:nil="true" />

  <InnerFault i:nil="true" />

  <OriginalException i:nil="true" />

  <TraceText>

[Microsoft.Xrm.Sdk.Workflow: Microsoft.Xrm.Sdk.Workflow.Activities.UpdateEntity]

[UpdateStep9]

 

</TraceText>

</OrganizationServiceFault>

Categories:
Development / Customization / SDK
Administration and Setup
Other
  • Suggested answer
    Naveen Ganeshe Profile Picture
    Naveen Ganeshe 3,393 Moderator on at
    RE: SQL Server error - when user tries to run a dialog

    Hi Adventure1310,,

    A FaultException in Dynamics 365 CRM is typically caused by an error that occurred during the execution of a dialog. The error message that you provided suggests that there is an issue with the OrganizationServiceFault which is thrown by the CRM's web service when an error occurs.

    Possible causes of this error include:

    • Incorrect configuration of the CRM environment,
    • Incorrect or outdated custom code,
    • Insufficient permissions of the user running the dialog,
    • An issue with the dialog's workflow,
    • a problem with the SQL Server that hosts the Dynamics 365 CRM databases.

    Here are some steps that you can take to try and resolve the issue:

    1. Check the CRM event log for more information about the error. The event log will typically provide a more detailed error message that can help you to identify the cause of the problem.

    2. Check the SQL Server event log for any related errors.

    3. Ensure that the user running the dialog has the appropriate permissions to run the dialog and access the necessary data.

    4. Check for any custom code that is related to the dialog and ensure that it is correct and up-to-date.

    5. Check the dialog's workflow for any issues or errors.

    6. Try to run the dialog in a different environment to see if the problem is specific to the current environment.

    7. You can also try to isolate the specific cause by disabling the custom code, plugins or custom workflows that are associated with the dialog, to see if the problem is related to them.

    If the problem persists after trying these steps, it may be necessary to contact Microsoft Support or a Dynamics 365 CRM consultant for further assistance.

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Moderator on at
    RE: SQL Server error - when user tries to run a dialog

    Hi Adventure1310,

    Is this the only error you can see in the Process session? If Yes, I recommend to you raise the ticket to Microsoft for further investigation.

    pastedimage1673317942678v1.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans