Ability to transition a plan from Repository Stored Specs (RSS) managed back to a standard plan

Problem Definition

Currently once a plan is managed via RSS, by design there's no path back to a standard plan and it can no longer be edited through the UI.

Suggested Solution

UI action that allows a plan to be transitioned back to a standard plan, the action would need to warn the user that RSS will be disabled for the repository that created this plan as well as warn of any other plans that RSS for that repository manages (if they exist).

Workarounds

Publish Specs for a specific plan manually.

When Specs are published to Bamboo server manually (see our tutorial for more details) then plan will be disconnected from RSS and it will be possible to edit its configuration from UI.

Clone plan

The RSS managed plan needs to be cloned. However, this will lose all the build history.

Run SQL query

This is not a recommended way to proceed and you need to make sure you take a database backup before applying this solution.

• stop Bamboo
• take DB backup
• run the following queries

  -- Disconnect Bamboo plan from RSS
  
  -- Bamboo <= 7.2
  UPDATE build
  SET vcs_specs_source_id=NULL
  WHERE full_key='<full_build_plan_key>'
  AND build_type='CHAIN';
  
  -- Bamboo >= 8.0
  DELETE FROM plan_vcs_specs_source
  WHERE plan_id=( 
    SELECT build_id 
    FROM build 
    WHERE full_key='<full_build_plan_key>'
    AND build_type='CHAIN'
  );
  
  -- Disconnect Bamboo deployment from RSS
  
  -- Any Bamboo version
  UPDATE deployment_project
  SET vcs_specs_source_id=NULL
  WHERE plan_key='<full_deployment_plan_key>';
  

• start Bamboo