SQL Error/SAME TABLE REFERENCE when Uninstalling a Managed Solution

(0) Share

Report

Posted on by RugerSR762

375

I am attempting to remove a managed solution but keep receiving Generic SQL errors.

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Generic SQL error.Detail: -2147204784 Generic SQL error. 2018-06-19T19:31:46.8422186Z false

I've attempted to increase the SQL timeout but that did not help. The event log shows the following error:

Uninstall failed. Error: The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "solutioncomponent_parent_solutioncomponent". The conflict occurred in database "CRM_MSCRM", table "dbo.SolutionComponentBase", column 'RootSolutionComponentId'.The statement has been terminated.

The vendor of the managed solution unfortunately said that the Dynamics platform is responsible for uninstall operations so they could not assist further.