I am facing one issue while trying to upgrade a solution. The scenario is that I have one upgraded solution with version 1.2.0.0 and its related patches in the sandbox environment. I imported the upgraded version 1.3.0.0 and it is installed successfully but the base version(1.2.0.0) is not upgraded. The below is the error I am getting.
The UPDATE statement conflicted with the FOREIGN KEY constraint /solution_base_dependencynode/. The conflict occurred in database /db_crmcoreemea_20220503_05150079_b688/, table /dbo.SolutionBase/, column 'SolutionId'. The statement has been terminated.
I have faced the same issue and error message - for me the the problem was solved by staging the new solution (which contains all the changes from the patches), and when the upgrade package has been deployed removing all the installed patches and applying the upgrade (remember to create a backup so you can restore it if something goes wrong)
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.