I have a managed solution in Production (version 34) and I imported a newer version (version 41) that was staged for upgrade. The upgrade installed successfully, but I cannot delete the old solution version 34 (error code 8004F01D). I believe this is because there is a lookup field to an custom entity I forgot to include in the newer version 41. This entity does exist in another unrelated solution in Production though, which is why I didn't include it in the new version.
I tried importing another version 42 that includes the missing entity, but it won't import saying there is already a solution staged for upgrade. And I can't delete the solution staged for upgrade now because of dependencies. And I can't delete the lookup field that is causing all the issues either. So I'm stuck with two versions in Production and can't import changes now if I needed them. Any ideas how to fix this?
thank you!