Symptoms
P&D doesn't allow deploy even if all is 'green'
I have tried to re-run the registration wizard on the prod (taget) environment but no change. I've cleared the P&D cache, no change.
Diagnoses
Upon investigating the package in MMC we saw the same behavior. This issue had been seen before on other tickets and we noticed that it usually revolved around a service instance not being configured properly. We viewed all of our Service Instances and the SQL Service Instance "Master Data Management SQL Service instance" showed an error when we right clicked and selected configure.
Resolution
Our SQL Service Instance "Master Data Management SQL Service instance" in this package showed an error when right clicking and selecting configure. After going into the configure screen for this service instance we saw that, although on the conflict resolving that we set it to use the existing service instance, our only two options here were to 'Overwrite Service instance' or 'Create New Service Instance'.
The conflicts listed on this screen were:
Conflicts: System Name and GUID.
We went ahead and selected the Overwrite existing option and clicked Ok. We reanalyzed the service instance and the next button was now enabled. However, we did not want to overwrite the service instance, we did want to use the existing. When going back into the service instance and selecting the configure option we now saw that we had the selection for "Use Existing Service Instance". We selected this and then reanalyzed the package. After this the Next button was still enabled and we then were able to deploy the package with no issue. After deployment we did not see any issues with the contents of this package.
Most likely there was an inconsistency between our SQL service Instance on TST and that on PROD. That was what caused our issue. This could have been due to some part of their structure.
A Feature Request has been submitted to improve the errors we will see in P&D. Specifically if we have a service instance showing differences with that on the target instance we would point out what parts do not match.
We also submitted a bug for seeing all green check marks but not being able to continue in our package and deployment process.
