Release Automation

 View Only
  • 1.  Define Rollback during Flow for Deployment Plan

    Posted May 12, 2015 01:12 AM

    Have been trying out the actions that are available for rollback. I have consistent getting an error where the plan exists but is not able to be retrieved via the actions.

     

    Qns:

    1. Has anyone try out the rollback actions

    2. How does the fields suchs as Project/deployment plan/versions map to with data within the database?



  • 2.  Re: Define Rollback during Flow for Deployment Plan
    Best Answer

    Posted May 12, 2015 04:58 AM

    Hi Tony

    1.Setting Rollback Definition for DP action works on V5.5.1 (You need to run it on the preplan)

    2. I normally find in the DB the last successful deployment based the same project and run on the same environment and set it as my rollback plan.

    The below query will get you last deployment plan info you will need for setting up the rollback action

     

    use nolio_db55;

    select candidates.build, candidates.id ,candidates.name

    from APPLICATIONS apps, RC_VERSION projects, ENVIRONMENTS envs, RC_RELEASES releases, RC_STAGES stages,rc_release_candidate candidates

    where apps.ID = projects.APPLICATIONID and

      releases.PROJECT = projects.ID and

      stages.RELEASE_ID = releases.ID and

      stages.ENVIRONMENT = envs.ID and

      candidates.id = releases.release_candidate and

      releases.RELEASE_RESULT ='SUCCESS' and

      apps.APP_NAME ='Online Financial Trading Platform' and projects.NAME = 'Mobile_Platform' and envs.NAME = 'Dev'

    order by releases.id desc limit 1;

     

    Output

    build, id, name

    '2-50', '878', 'Mobile Deployment Build 50'

     

    Thanks

    Jacky



  • 3.  Re: Define Rollback during Flow for Deployment Plan

    Posted May 13, 2015 12:26 AM

    Please advice on where the attributes from the DB will be used to populate the actions?

     

    Untitled.png



  • 4.  Re: Define Rollback during Flow for Deployment Plan

    Posted May 13, 2015 01:20 AM

    The deployment plan name and version will retrieved based on the SQL query I provide above .For the project name you can use the built-in parameter as both plans most likely belong to the same project



  • 5.  Re: Define Rollback during Flow for Deployment Plan

    Posted Feb 06, 2017 05:23 AM

    Hi Jacky, 

    don't you think that is neccessary to use the name of the deployment Template too?

     

    In my case, per each project I have several deployment template.

     

    regards

    Javi



  • 6.  Re: Define Rollback during Flow for Deployment Plan

    Posted Feb 06, 2017 07:15 AM

    Hi Javi

    You can't define same deployment plan (Name + version) using different template per project so setting project name + deployment plan name + version will provide unique result 

    Jacky 



  • 7.  Re: Define Rollback during Flow for Deployment Plan

    Posted Feb 06, 2017 08:58 AM

    you're right !!!