Hello,
I did a run of Power Platform Pipelines, but the deployment crashed:
But despite of it crashing, solution was at least partially migrated to the Test Env:
Solution duplicated with _Upgrade added to its name. For 19h now.
I cannot delete it because i get an error, and cannot start another Pipelines deployment, because I get the message that another upgrade is pending.
Do you have any ideas how to solve this?
Hi,
Unfortunately I didnt understand your solution. If possible can you explain again. 🙂 Many thanks!
I managed to remove the old solution by using a previous solution artifcat that was deployed successfully
If you are using Deployment Pipelines you can go into the history and look for an old solution export the solution
Change the version number to allow for upgrade in the solution Zip files
Import the solution manually as an upgrade, after a successful import, you can then delete the solution
This fixed the problem for me
I am having the same issue - effectively blocked from progressing? Did you find a way to remove the old solution?
Hello
To resolve this you will need to go to the target environment and look for the solution name with _upgrade and remove it
After this try to import the solution in a manual way to the target environment to determine the blocker
Yes, indeed i am using a pipeline. Happens between DEV and STAGE after initial deployment went correctly and I tried to deploy my first delta change (deleting fields from the schema) and trying to redeploy the changes I made in DEV. With this first change to the intial solution, the pipeline breaks.
Do you use the deployment pipeline ?
Hi Everyone
So i was able to fix this problem using an Old Artefact from the Deployment Pipeline (Good to have version/Source control)
I imported the solution manually into the Test Environment and changed the version number as well
Then deploy the update with the pipeline and was all good
I am facing the exact same issue being stuck in not being able to apply the upgrade, cannot delete the existing solutions in destination env nor can I redeploy a modified corrected version. Anybody found a solution yet?
Hi @parvezghumra
This is the using the classic design
System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: Sql error: Statement conflicted with a constraint. The DELETE statement conflicted with the REFERENCE constraint "environmentvariabledefinition_environmentvariablevalue". The conflict occurred in database "db_crmcoregbr_20221031_01452565_2076", table "dbo.EnvironmentVariableValueBase", column 'EnvironmentVariableDefinitionId'.
The statement has been terminated. CRM ErrorCode: -2147185375 Sql ErrorCode: -2146232060 Sql Number: 547 (Fault Detail is equal to Exception details:
ErrorCode: 0x80048D21
Message: Sql error: Statement conflicted with a constraint. The DELETE statement conflicted with the REFERENCE constraint "environmentvariabledefinition_environmentvariablevalue". The conflict occurred in database "db_crmcoregbr_20221031_01452565_2076", table "dbo.EnvironmentVariableValueBase", column 'EnvironmentVariableDefinitionId'.
The statement has been terminated. CRM ErrorCode: -2147185375 Sql ErrorCode: -2146232060 Sql Number: 547
TimeStamp: 2024-01-19T10:21:20.3762891Z
--
@Geeks_D If you try to apply the upgrade in the classic experience, you'll get a more readable error message and listing of the dependencies. Try that and paste the screenshot of the list of dependencies here
stampcoin
17
mmbr1606
15
Super User 2025 Season 1
ankit_singhal
11
Super User 2025 Season 1