How to remove custom test type from ALM core

  • Questions
  • How to remove custom test type from ALM core
Question ID: 106461

We have some custom test types that were used in the past, but moving forward, are no longer needed or used. Having upgraded ALM to version 12, now it seems these custom types if accidentally selected give way to some issues. I would like to just remove them as an option for ALM, but can't find any documentation on this.

Marked as spam
Posted by (Questions: 104, Answers: 0)
Asked on October 26, 2015 3:46 pm
Answers (1)
Private answer


Recommended steps for custom test_type deletion are as follows.

In order to delete the custom test types:

Run the following queries in the project schema to delete the problematic test types.

DELETE FROM ENTITY_SUBTYPE_ATTRIBUTES where esta_subtype_id like '%QA%'

DELETE FROM ENTITY_SUBTYPES where est_name like '%QA%'

DELETE FROM ENTITY_SUBTYPE_RELATIONS where estr_source_subtype_id like '%QA%'

Suggested that ALM service restart as well as a DB restart to ensure changes are loaded properly.

Recommendation before doing deleting the custom test types is to change the tests with these test types to MANUAL first. Following query can help you do these changes once you identify which need to be changed
update TEST set TS_TYPE='MANUAL' where TS_TEST_ID='321'

Run against the individual project schema.

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on October 26, 2015 3:54 pm
Those steps seem to have worked. Testing now but seems like a solid solution.
( at October 26, 2015 5:46 pm)