Edit

Solution upgrade or uninstall errors in Copilot Studio

Summary

When you upgrade or uninstall a managed solution in Microsoft Copilot Studio, you receive error messages that are related to SQL constraints, managed property evaluation, or unexpected component deletion. These errors typically occur because of active customizations in the target environment or managed property conflicts. This article helps you identify the cause and resolve the error.

Symptoms

When you upgrade or uninstall a managed solution, or when you update, remove, or delete a managed component such as an agent or agent component, you receive one of the following error messages:

  • SQL constraint error:

    Sql error: Statement conflicted with a constraint. The DELETE statement conflicted with the REFERENCE constraint "botcomponent_parent_bot"

  • Managed property evaluation error:

    The evaluation of the current component (name=bot, id="botid") in the current operation (Update) failed during managed property evaluation of condition: Managed Property Name: iscustomizableanddeletable; Component Name: bot; Attribute Name: iscustomizable

  • Unexpected component deletion error:

    Not Found

Determine the cause of the problem

Match the error message to the appropriate cause:

Cause: Active customizations in the target environment

SQL constraint errors occur if the target-managed environment has active customizations on the agent or component that's shown in the constraint. For example, customizations are set on an agent component, workflow, or environment variable.

Solution: Remove active customizations

To view and remove customized components:

  1. In Copilot Studio, go to Solutions, and then open the agent's source solution.
  2. On the Objects pane, select All.
  3. To find all managed agents (Yes), sort the Managed column alphabetically.
  4. To find all customized agents (Yes), sort the Customized column alphabetically.
  5. For each agent that's managed and customized:
    1. Open the command menu (⋮).
    2. Select Advanced.
    3. Select Remove active customizations.
  6. Retry the upgrade or uninstallation.

Cause: Managed property conflicts

Managed property evaluation errors occur if you initially set solution components as customizable, and you then apply customizations but later disable this option in an upgrade. Conflicts or deletions within managed solution layers can also cause components to malfunction or become inaccessible. This situation prevents you from being able to remove active customizations.

Solution: Update the managed property settings

  1. Set the component as customizable in the source solution. For more information, see View and edit managed properties in solutions.
  2. Import the solution in the target environment again.
  3. Try again to remove the active customization.

Create a support case

If you still receive the same errors after you apply the solution, contact Microsoft Support. For more information, see Find support and give feedback for Copilot Studio.

When you create a support case, include the following information:

  • A network trace that captures the error
  • The complete error details (download the full error log shown during the upgrade or uninstall)
  • Screenshots of the following views:
    • Solution layers view
    • Agent dependencies
    • Customize column showing conflicts (if applicable)
  • A description of the steps you already tried
  • The solution .zip file, if possible

Related content

  • Last updated on