Microsoft Dynamics CRM 2011 SQL server error while deleting solution

By - September 30, 2014

I attempted to delete a managed solution in my test environment of Microsoft Dynamics CRM and halfway through the process, it failed with a SQL server error below.

CRM 2011 SQL Server Error While Deleting Solution

After downloading the log file, it mentioned a “Generic SQL error”, which did not help much in identifying the cause of the issue.

So, I turned on Dynamics CRM tracing and reviewed the file. I noticed there was a CRM exception error:

Crm Exception: Message: SQL timeout expired., ErrorCode: -2147204783, InnerException: System.Data.SqlClient.SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. —> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

The error above suggested we need to increase our time-out values since it is a big solution and requires more time to complete the delete process in Dynamics CRM.

Hence, I used this Microsoft KB article, A time-out occurs when you import large customization files into Microsoft Dynamics CRM, and after applying method 1, my managed solution was deleted successfully in Dynamics CRM.

I recommend to delete the registry keys afterward since extending the time-out values is not good for the overall performance.

If you need help with resolving Dynamics CRM issues, RSM experience and expertise offers a full range of services from implementation and optimization to development and support. Contact our professionals for more information on our services at 855.437.7202 or crm@mcgladrey.com.

By: Hien Tieu – Philadelphia Microsoft Dynamics CRM partner

Receive Posts by Email

Subscribe and receive notifications of new posts by email.