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.
Any help is greatly appreciated.