Release Automation KB: Delete Artifact Types and Definitions

Document created by golbe05 Employee on Jan 6, 2015Last modified by golbe05 Employee on Mar 10, 2015
Version 5Show Document
  • View in full screen mode

Upon the release of Release Automation 5.5.1, deployed Artifact Types, Definitions and Versions will be removable from ROC.


In RA 5.5, a user can delete Artifact Types, Definitions and Versions from ROC only if they were not previously deployed.

Once removed, they are archived for reporting purposes, so you can't create new Types, Definitions and Versions with the same name (you will see an error indicating they're archived).


RA 5.0.x is not designed as to allow deletion of Artifact Types and Definitions from ROC at all.

Users of RA 5.0.x can utilize the following method to delete Artifact Types.

Remember: this method only works if the Artifact Types are not associated with any deployed version. If the versions associated were already deployed, there is no way to remove the Artifact Type.



  1. Go to Artifacts >> Artifact Management >> Click on the Artifact Type name >> Click "Edit" (the pencil icon).
  2. Remove all Components and Attributes associated with this Artifact Type (by hovering over them and clicking on the "X").
  3. If the Artifact Type has Definitions, click on them. If there are Versions, click on "X" to delete them. Repeat until you've removed all Artifact Type Versions associated with this Artifact Type.

In the Database

    • The following steps should be carried out with the utmost caution, to prevent the deletion of information you want to retain.
  1. Find the Application ID: SELECT * FROM  applications;
  2. Find all Artifact Types in this Application and note the relevant Artifact Type ID: SELECT * FROM  artifact_type WHERE  applicationid = [application_id]
  3. Find all Definitions in this Artifact Type and note their IDs: SELECT * FROM  artifact_definition WHERE  artifacttype_id = [artifact_type_id];
  4. Delete all Artifact Type Definitions: DELETE FROM artifact_definition WHERE  id = [definition_id];
  5. Delete Artifact Type: DELETE FROM artifact_type WHERE  id = [artifact_type_id];
1 person found this helpful