Hello Community,
I encountered an issue during the upgrade of a solution in multiple environments. Initially, I customized the system table for email templates by adding a field named "Category" (cr884_category). The upgrade process involved creating this new field in the target environments. Subsequently, I removed the email templates from the solution and deleted the "Category" field since it was no longer required.
However, when attempting to import an upgrade in these target environments using the modified solution (without the email templates table), I encountered the following error:
Solution "" failed to import: Solution Upgrade action failed after import as holding. InnerException is: Invalid column name 'cr884_Category'...
It's worth noting that I'm unable to delete the column from the default solution in the target environment.
To troubleshoot, I attempted to import a new solution that only included the email template table without the "Category" field. Although the solution was imported successfully, the undesired column persisted and was not removed.
My primary objective is to delete the "Category" field from the target environments to facilitate the successful application of the upgrade.
I only need to delete the category field from the target environments to apply the upgrade.
Is there any way to force delete the column from the target environment through a web API since the solution is managed or is there another alternative?
Thank you.