Summary

Environment: Bamboo 5.7.1 (MS SQL 2008) upgraded to Bamboo 6.1.1 (MSSQL 2016). Data was migrated through DB backup-restore.

219 environments and about 4500 deployment results. When open deployment dashboard some environments have Never deployed status. But when open deployment details you see several versions deployed to them.

Workaround

1. Stop Bamboo
2. Backup your database for rollback purposes
3. change DEPLOYMENT_RESULT.STARTED_DATE column type to datetime2(7)

   USE <Bamboo_DB>
   
   -- Drop related indexes
   DROP INDEX
   dr_started ON dbo.DEPLOYMENT_RESULT,
   dr_started_env_lc ON dbo.DEPLOYMENT_RESULT;
   
   -- Change column datatype
   ALTER TABLE dbo.DEPLOYMENT_RESULT ALTER COLUMN STARTED_DATE datetime2(7)
   GO
   

   Change <Bamboo_DB> to your database name

4. Restart your Bamboo.

The dropped indexes will be recreated when Bamboo is restarted.