Steps for a fix:
ssh onto ops manager
sudo su tempest-web
psql tempest_production
select * from stemcells;
update stemcells set present_on_disk=true where id = ID_FROM_ABOVE_STEP;
The
Missing Stemcell warning should go away at this point, so you can continue with an Apply Change process.