Release Automation

Expand all | Collapse all

How to get Failed steps from DB for one release

Jump to Best Answer
  • 1.  How to get Failed steps from DB for one release

    Posted 04-19-2016 01:59 AM

    Hi,

     

    Our customer wants to run some SQLs to list all actions whose status is "Failed" for one release, like the event list we can see from the studio. Which tables I should combine to get these data?

     

    I can get the release list from RC_RELEASE table but don't know how to relate it with its failed actions.

     

    Thanks

    Yang



  • 2.  Re: How to get Failed steps from DB for one release
    Best Answer

    Posted 04-19-2016 04:04 AM

    Try use this query (I use MySQL DB)

    It will list the failed actions for specific release id

     

    select rcbm.name as Releaase_step_name,c.PROCESS_NAME as ProcessName,ose.step_title as AcitonName,ose.result_desc as ActionResultDesc ,rcs.stage_mode as Deployment_result,

    rcm.module_mode as step_result from rc_stages rcs

      inner join rc_releases rcr on rcr.id=rcs.release_id

      inner join rc_modules rcm on rcm.stage_id=rcs.id

      inner join rc_basic_modules rcbm on rcbm.id=rcm.id

      inner join offline_execution_jobs oej on oej.id=rcm.job_id

      inner join offline_step_events ose on ose.job_id=oej.id

      inner join published_process s on s.ID=rcbm.published_process

      inner join process_container c on c.ID=s.ID

    where rcr.id = 2380 and ose.step_state like 'finished' and ose.result_type like '1'

     

     



  • 3.  Re: How to get Failed steps from DB for one release

    Posted 04-19-2016 05:23 AM

    Hi Jacky,

     

    Thanks for the quick reply. That works very well. My environment is Oracle,  I changed ose.step_state like 'finished' to ose.step_state like 'FINISHED'.

     

    Yang



  • 4.  Re: How to get Failed steps from DB for one release

    Posted 04-19-2016 05:27 AM

    great

    Jacky