Hi all,
I need help withremoving environment variables and ALM pipelines.
I'm using Dev -> Test -> Prod environments. I'm trying to remove a couple of environment variables from the solution in Dev. The environment variables where used before but not anymore so thats why I want to remove them. However when remove one of the variables and deploy from Dev to Test, the deployment fails and I get this error message:
Solution Upgrade action failed after import as holding. InnerException is: Sql error: Statement conflicted with a constraint. The DELETE statement conflicted with the REFERENCE constraint "environmentvariabledefinition_environmentvariablevalue". The conflict occurred in database "db_crmcoreemea_20240311_05580211_02a9", table "dbo.EnvironmentVariableValueBase", column 'EnvironmentVariableDefinitionId'. The statement has been terminated. CRM ErrorCode: -2147185375 Sql ErrorCode: -2146232060 Sql Number: 547.
If I go to Test, there is an extra solution with the same name and with suffix "_Upgrade". If I delete that and add the variable back into the solution in Dev, the deployment is successful.
How can I get rid of the unnecessary environment variables?


Report
All responses (
Answers (