You’re offline. This is a read only version of the page.
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>
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:
Here are some steps that you can take to try and resolve the issue:
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.
Check the SQL Server event log for any related errors.
Ensure that the user running the dialog has the appropriate permissions to run the dialog and access the necessary data.
Check for any custom code that is related to the dialog and ensure that it is correct and up-to-date.
Check the dialog's workflow for any issues or errors.
Try to run the dialog in a different environment to see if the problem is specific to the current environment.
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (